DOC PREVIEW
UT Knoxville STAT 201 - Stats 201 PivotChart

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'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

UT Knoxville STAT 201 - Stats 201 PivotChart

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 PivotChart
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 PivotChart 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 PivotChart 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?