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 Total 3 65 3 60 3 55 Female Male 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 by Gender Separated by using Tobacco or Not by Bhavin Patel 3 90 Average GPA s 3 80 3 70 No Yes 3 60 3 50 3 40 3 30 Female Male 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 Parking Ticket by Class Level Separated by Gender by Bhavin Patel 18 00 16 00 Average of tickets 14 00 12 00 10 00 Female Male 8 00 6 00 4 00 2 00 0 00 Freshman Sophomore Junior 5 year senior Senior Non traditional 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 5 th years have more parking tickets on average than other class levels Average Parking Ticket by Class Level Separated by Gender by Bhavin Patel 6 00 5 00 4 00 Average of Tickets 3 00 Female Male 2 00 1 00 0 00 Class Level Updated chart after taking out outliers
View Full Document
Unlocking...