DOC PREVIEW
UT Knoxville STAT 201 - Stats 201 pivot chart

This preview shows page 1 out of 3 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 3 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 3 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

Bhavin PatelSection: MWF 9:05-9:55Stats 201: Pivot Table and Chart projectPivot Chart 1:Female Male3.553.603.653.703.753.803.85Average GPA by Gender by Bhavin Patel TotalGender Average GPA's- This Pivot Chart is analyzing the average GPA by gender. Based on the data collected the chart suggested that females have a higher GPA than males. The maximum GPA was 4.86 and the minimum was 1.10.Pivot Chart 2: Female Male3.303.403.503.603.703.803.90Average GPA by Gender Separated by using Tobacco or Not by Bhavin Patel NoYesGender Average GPA's- This pivot chart is analyzing the average GPA by gender separated by using tobacco or not. Females still have a higher GPA than males but if you use tobacco, you seem to have a lower GPA. From this data I concluded that by using tobacco, you will tend to have a lower GPA.Pivot Chart 3:Freshman Sophomore Junior 5+ year senior Senior Non-traditional0.002.004.006.008.0010.0012.0014.0016.0018.00Average Parking Ticket by Class Level Separated by Gender by Bhavin Patel FemaleMaleClass LevelAverage # of tickets - The above pivot chart is analyzing the average parking ticket from each class level separated form by gender. This chart is stating that males tend to get more tickets then females and juniorsare getting more parking tickets on average. The chart below has an accurate data after taking out an outlier of “1000” parking tickets. After taking the outlier out seniors and 5th years have more parking tickets on average than other class levels. 0.001.002.003.004.005.006.00Average Parking Ticket by Class Level Separated by Gender by Bhavin Patel FemaleMaleClass LevelAverage # of Tickets - Updated chart after taking out


View Full Document

UT Knoxville STAT 201 - Stats 201 pivot chart

Documents in this Course
Chapter 8

Chapter 8

43 pages

Chapter 7

Chapter 7

30 pages

Chapter 6

Chapter 6

43 pages

Chapter 5

Chapter 5

23 pages

Chapter 3

Chapter 3

34 pages

Chapter 2

Chapter 2

18 pages

Chapter 1

Chapter 1

11 pages

Load more
Download Stats 201 pivot chart
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Stats 201 pivot chart and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Stats 201 pivot chart 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?