Bhavin Patel Section MWF 9 05 9 55 Stats 201 Pivot Table and Chart project Pivot Chart 1 Average GPA by Gender by Bhavin Patel 3 85 Average GPA s 3 80 3 75 3 70 3 65 Total 3 60 3 55 Total Female Male 3 82 3 65 Gender 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 Average GPA s Average GPA by Gender Separated by using Tobacco or Not by Bhavin Patel 3 85 3 80 3 75 3 70 3 65 3 60 3 55 3 50 3 45 3 40 3 35 No Female Male No 3 83 3 69 Yes 3 71 3 54 Yes Gender 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 Average of Zckets Average Parking Ticket by Class Level Separated by Gender by Bhavin Patel 18 00 16 00 14 00 12 00 10 00 8 00 6 00 4 00 2 00 0 00 Female Freshma n Sophom ore Junior 5 year senior Senior Non tradiZon al Female 0 39 1 61 2 76 5 00 2 89 2 67 Male 0 63 1 94 15 65 4 71 4 50 3 40 Male Class Level 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 juniors are 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 Average of Tickets Average Parking Ticket by Class Level Separated by Gender by Bhavin Patel 6 00 5 00 4 00 3 00 2 00 1 00 0 00 Female Freshman Sophomo re Junior Senior 5 year senior Non tradiZona l Female 0 39 1 61 2 76 2 89 5 00 2 67 Male 0 63 1 94 2 87 4 50 4 71 3 40 Male Class Level Updated chart after taking out outliers
View Full Document
Unlocking...