Bhavin'Patel'Section:'MWF'9:0569:55'Stats'201:'Pivot'Table'and'Chart'project'Pivot'Chart'1:'!• 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!m ales.!The!maximum!GPA!was!4.86!and!the!minimum!was!1.10.!!!!!!!!!!!!!!!!!!!!!Female! Male!Total!3.82!3.65!3.55!3.60!3.65!3.70!3.75!3.80!3.85!Average!GPA's!Gender!!Average!GPA!by!Gender!by!Bhavin!Patel!!Total!!Pivot'Chart'2:''!• This!pivot!chart!is!analyzing!the!average!GPA!by!gender!separated!by!using!tobacco!or!not.!Females!still!have!a!higher!GPA!than!male s!bu t!if!you!use !tob acc o,!y o u !se e m!to!have!a!low er!GPA.!!From!this!data!I!concluded!that!by!using!tobacco,!you!will!tend!to!have!a!lower!GPA.!!!!!!!!!!!!!!!!!!Female! Male!No!3.83!3.69!Yes!3.71!3.54!3.35!3.40!3.45!3.50!3.55!3.60!3.65!3.70!3.75!3.80!3.85!Average!GPA's!Gender!!Average!GPA!by!Gender!Separated!by!using!Tobacco!or!Not!by!Bhavin!Patel!!No!Yes!!Pivot'Chart'3:'!• The!above!pivot!chart!is!analyzing!the!average!parking!ticket!from !e ach !class!leve l!sepa rate d!form!by!gen de r.!This!chart!is!stating!that!males!tend!to!get!more!tickets!then!females!and!juniors!ar e!g e ttin g !more!parkin g !tick e ts !on !a v era g e .!Th e !c ha rt !be lo w !h a s !an !a cc u ra te !d at a!a ft er!taking!out!an!ou tlier!of!“10 00 ”!pa rking !tickets.!Afte r!taking !the!o utlier!ou t!sen iors!an d!5th!years!have!more!parking!tickets!on!average!than!other!class!levels.!!!• Updated!chart!after!taking!out!outliers.!!Freshman!Sophomore!Junior!5+!year!senior!Senior!NonYtradiZonal!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!0.00!2.00!4.00!6.00!8.00!10.00!12.00!14.00!16.00!18.00!Average!#!of!Zckets!!Class!Level!Average!Parking!Ticket!by!Class!Level!Separated!by!Gender!by!Bhavin!Patel!!Female!Male!Freshman!Sophomore!Junior!
View Full Document