In this report, analyse a randomised subset of a student survey. It is an in-class survey of statistics students over several years. only consider the First Year data. This subset only has three variables, namely Sex [F and M denote female and male student respectively], Smoke [Smoker? No or Yes] and GPA [College grade point average].

Task 1: Identify data type Identify each variable (i.e., Sex, Smoke and GPA) in the subset whether it is categorical nominal, categorical ordinal, quantitative discrete or quantitative continuous.

Task 2: Show the difference of GPA by Sex

a. Construct side-by-side boxplots for the GPA variable by the Sex variable (i.e., the two groups are female students and male students)

b. Calculate the Q1, Q2, Q3, interquartile range and whisker limits for the GPA variable of the female and male groups separately.

c. Use the respective median and inter-quartile range to compare the data position and variability or spread of GPA for the female and male groups separately. [Hint: Refer to "Measures of Central Tendency" for the calculation of Q1 Q2 and Q3 as well as the whisker limits.]

Task 3: Calculate the percentage of smoker by Sex

a. MAKE a contingency table to show student's Sex frequencies by the Smoke variable (i.e., a smoker or not).

b. Calculate and compare the percentage of smoker in the female students and the male students separately.

Conclusion: From the Task 2, should have some idea of the difference of the distribution of GPA for the female students and male students. Also, the result from Task 3 would indicate which group has a higher smoker percentage. a short report summarising main findings.

the survey data:

M Inter Ti Join & add Sign @ @HC| 7 Ha Forn Fair G Whe | G Lung | G is bi | N Nett | New | f (1) F | Anal | Anal Grol Anal Hon 9 Mail |( X + wineduau-my.sharepoint.com/:x:/r/personal/983331_win_edu_au/_layouts/15/Doc.aspx?sourcedoc=%785294FB68-A657-4481-8DBC-D72768BE8DA5%7D&file=... 983331 Excel ds611 - Saved Search (Option + Q) Draw Page Layout Formulas Data Review View Automate Help Viewing Share Comments Catch up File Home Insert 12 B ab, . . . 5 v [ v v M Av ... General 00 .00 A1 " X fx Sex T U V A B D E F G H I J K L M N P Q R S 1 Sex Smoke GPA 2 M No 2.55 3 No 2.77 No 3.7 No 3.86 No 3 M No 3.5 8 M No 2.5 9 M No 3.3 10 F No 2.68 11 M No 3.51 12 F No 3.1 13 M No 2.94 14 M No 3 15 F No 3.6 16 F No 4 17 M No 3.4 18 F No 3.25 19 F No 2.1 20 F No 3.83 21 M No 2.7 22 No 3.13 23 M No 3.6 24 No 3.57 25 M No 3.88 26 M No 2.1 27 F No 3 A I - in Give Feedback to Microsoft - 100% + Workbook Statistics ds611 (2).csv Show all X ds611 (5).csv ds611 (4).csv ds611 (3).csv Analysis-Report-1.pdfM Inter Ti Join & add Sign @ @HC| 7 Ha Forn Fair G Whe | G Lung | G is bi | N Nett | New | f (1) F | Anal | Anal Grol Anal Hon 9 Mail |( X + wineduau-my.sharepoint.com/:x:/r/personal/983331_win_edu_au/_layouts/15/Doc.aspx?sourcedoc=%785294FB68-A657-4481-8DBC-D72768BE8DA5%7D&file=... Excel ds611 - Saved Search (Option + Q) 983331 File Home Insert Draw Page Layout Formulas Data Review View Automate Help Viewing Share Comments Catch up 5 v Q v 12 B v My Av ... ab, General 00 .00 HEY EV ATV OV . . . A1 ~ X fx Sex A B C D E F G H I K L M N 0 P Q R S T U V 28 3.2 29 M No 2.6 30 M No 2.9 31 F No 2.8 32 M No 2.27 33 F No 2.8 34 M No 3.02 35 F No 3.2 36 No 3 37 No 2.9 38 M No 2.72 39 F No 3.3 40 No 3.5 41 F No 3.69 42 M No 3.31 43 M No 2.82 44 No 3.57 45 M No 2.2 46 M No 2.85 47 No 3.2 48 M No 2.72 49 No 2.6 50 M No 3.1 51 M No 3.77 52 M No 3.6 53 M No 3.3 54 F No 3.13 55 M No in Workbook Statistics Give Feedback to Microsoft - 100% + ds611 (5).csv ds611 (4).csv ds611 (3).csv Analysis-Report-1.pdf ds611 (2).csv Show all XM Inter Ti Join & add Sign @ @HC| 7 Ha Forn Fair G Whe | G Lung | G is bi | N Nett | New | f (1) F | Anal | Anal Grol Anal Hon 9 Mail |( X + wineduau-my.sharepoint.com/:x:/r/personal/983331_win_edu_au/_layouts/15/Doc.aspx?sourcedoc=%785294FB68-A657-4481-8DBC-D72768BE8DA5%7D&file=... Excel ds611 - Saved Search (Option + Q) 983331 File Home Insert Draw Page Layout Formulas Data Review View Automate Help Viewing Share Comments Catch up 5 v [ v 12 B v My Av ... ab, General 00 .00 . . . A1 X fx Sex A B C D E F G H I K L M N 0 P Q R S T U V 55 M No 3 56 F No 3.5 57 F No 3.4 58 F No 4 59 M No 3 60 F No 2.8 61 M No 3.5 62 M No 3 63 No 2.75 64 M No 3.36 65 F No 3.5 66 No 3.3 67 M Yes 2.2 68 M Yes 2.8 69 M Yes 2.5 70 M Yes 3.66 71 M Yes 2.25 72 M Yes 3.3 73 M Yes 74 F Yes 3.25 75 M Yes 2.83 76 M Yes 2.3 77 78 79 80 81 in + Workbook Statistics Give Feedback to Microsoft - 100% + ds611 (5).csv ds611 (4).csv ds611 (3).csv Analysis-Report-1.pdf ds611 (2).csv Show all X