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