[:5 Question Set 2: Describing and Comparing Data from Three or More Groups This question set uses the StudentSurvey_3.csv$datale. These data were collected from a sample of college students. We want to compare students who would prefer to win an Olympic Medal, Academy Award, and Nobel Prize in terms of their grade point averages (GPAs). Question Set 1: Completing an ANOVA Source Table Complete the ANOVA source table below by filling in the pink cells. Show all of your work below the table using the equation editor as needed. Degrees Source of Sum of Squares of Mean Square (MS) F-statistic Variation (SS) Freedom (DF) Treatments SSbetween (SSb)) K - 1 MSb = SSb/ (k - 1) F = MSb/MSw Error (or SSwithin (SSw) N-k MSw = SSw/(N - k) Residual) Total SSTotal (SST) N - 1D Question 11 6 pts Question set 2 B: Step 5: State a real-world conclusion 12pt V Paragraph B\f620 1090 3.05 64 3 470 Olympic Verbal 5 6 76 189 64 H N Sophomore M No 520 620 1140 2.8 14 5 66 127 60 FirstYear F No Olympic Math 440 640 1080 2.5 4 63 135 M No Nobel Math 5 68 Senior 720 700 1420 3.25 5 5 66 140 Sophomore F No Academy Verbal 390 53 920 2.55 70 2 20 68 162 12 Sophomore F No Nobel Math 560 560 1120 3.15 63 No Nobel Verbal 1 3 215 57 Sophomore F 610 1180 3 5 73 200 N 570 84 Senior No Olympic Math 15 660 600 1260 3.02 5 1 62 120 74 No Nobel Verbal Sophomore F 620 640 1260 3.5 5 2 67 165 61 FirstYear M No Nobel Math 660 570 1230 3 - WA 15 175 N 14 71 78 FirstYear M No Olympic Verbal 160 630 610 1240 3.35 3 66 65 Sophomore No Olympic Verbal 5 610 60 1210 3 20 68 145 68 Verbal A N Sophomore M No Nobel 540 680 1220 3 3 5 60 180 No Academy Math 76 Junior 570 570 1140 2.75 7 FirstYear No Nobel Verbal 171 170 F 600 670 1270 2.65 54 10 75 235 2 56 No Olympic Math 20 1200 2.75 Sophomore 60 10 10 65 155 600 88 Sophomore No Olympic 640 1170 3 6 15 65 140 530 No Nobel Math 77 Senior NNNW H 145 560 58 1140 2.65 6 1 66 52 Sophomore F No Olympic Math 56 1120 3.36 3 171 175 560 N 62 FirstYear M No Nobel Verbal 10 500 580 1080 9 6 76 210 80 Sophomore M No Olympic Math 560 180 1040 3.5 20 67 130 Olympic Verbal 1 .5 60 No FirstYear 500 70 1200 2.51 20 28 72 195 Sophomore M No Olympic Math 65 1290 * 67 Math 8 3 67 165 640 -NW N H H 51 Sophomore M No Nobel 660 570 1230 2.5 1 73 180 81 Sophomore M No Olympic Verbal 21 550 5 60 145 550 1100 3 10 62 Sophomore No Olympic Verbal 630 680 1310 2.75 8 163 N 12 70 Sophomore No Math 84 Nobel 700 60 1300 2.8 N 10 1 75 160 75 Junio M No Olympic Verbal 1120 3.4 67 150 560 56 18 7 60 1230 3 Junio No Olympic 65 170 580 71 10 No Olympic Math 15 6 76 Sophomore M Verbal 8 5 110 800 600 1400 3.25 NNN WHY 65 Sophomore No Nobel 170 460 520 980 3.05 6 2 66 65 Senior M No Nobel Math 700 74 1440 2.93 69 64 Sophomore M No Math 12 3 145 Olympic 660 650 1310 3 Verbal 10 4 69 160 75 FirstYear No Olympic 550 14 63 130 500 1050 2.23 93 Junior No Academy Math 600 63 1230 3.15 5 5 65 155 75 Sophomore F No Olympic Math 650 620 1270 3.3 Academy Verbal 6 4 65 - WN + N H FirstYear No 640 1260 3.43 82 F 620 5 5 160 M No Nobel Verbal 620 550 1170 3.63 80 Senior Verbal 5 5 66 151 69 Sophomore F NO Nobel 480 1050 3.2 180 570 No Olympic Verbal 30 10 74 85 Sophomore M 56 1100 3 5 4 64 130 2 540 Math 76 - NW + Senior F No Olympic 670 680 1350 3 12 5 75 185 Math 1240 3.18 76 Junior M Yes Nobel 73 198 620 620 0 1 65 Senior M Yes Nobel Verbal 650 600 1250 2.2 12 5 172 175 - W 67 FirstYear M Yes Olympic Verba 1130 3.29 14 67 123 560 57 64 Senior F Yes Nobel Math 0 69 145 480 1170 3.5 10 64 71 Junior Yes Nobel Math 15 460 52 980 2 .8 Olympic Math 18 15 67 190 65 FirstYear M Yes 500 610 1110 2.65 Math 12 5 65 130 83 Sophomore F Yes Olympic 680 68 1360 3.25 70 Nobel Verbal 2 3 185 1200 2.5 65 Sophomore M Yes 650 12 20 68 165 550 77 - WN N N H W W H H FirstYear M Yes Olympic Math 1310 3 3 5 3 630 68 165 Sophomore Yes Academy Math 620 640 1260 2.9 66 150 N 3 3 67 62 M Yes Olympic Math 1180 3.66 Junio 560 620 Nobel Math 4 3 72 160 58 FirstYear M Yes 142 590 63 1220 3.01 w Olympic Math 12 2 64 48 Junio Yes 530 510 1040 2.25 165 Olympic Verbal 25 5 72 61 FirstYear M Yes 50 1190 3.2 3 4 75 175 690 Junior M Nobel Verbal 50 Yes 175 550 500 1150 3.1 6 69 Yes Math 6 50 1200 2.75 72 Sophomore M Olympic 7 8 68 190 600 Olympic Verbal 1210 2.75 74 Sophomore F Yes -NN HK 2 72 180 610 60 7 80 Sophomore M Yes Nobel Verbal 600 60 1200 3.23 2 74 185 90 Yes Nobel 6 Sophomore M 750 50 1250 2.63 Nobel Verbal 6 2 890 2.35 72 Sophomore M Yes 470 420 Verbal 13 4 64 135 3 64 Sophomore F Yes Olympic 490 1040 2.5 8 73 195 550 25 72 Sophomore M Yes Olympic Verbal 540 60 1140 3.3 Olympic Math 8 12 71 175 70 Senior Yes 530 600 1130 3 Olympic Math 5 5 70 165 1210 3.3 84 Sophomore M Yes 540 67 Math 11 6 68 135 87 FirstYear M Yes Nobel 680 58 1260 2.95 Verbal 18 5 69 140 60 Sophomore F Yes Nobel 510 530 1040 2.35 182 2 10 60 Sophomore M Yes Olympic Math 650 1150 3 6 14 72 155 500 Math 80 1290 3.25 FirstYear M Yes Olympic 680 610 2 1 68 180 Yes Nobel Verbal 1150 3.3 70 H N FirstYear 650 5 25 69 170 500 Math Senior Yes 570 58 1150 3 78 M Nobel Math 5 3 135 1090 2.83 75 Sophomore F Yes Olympic 165 2 540 55 6 25 72 42 FirstYear M Yes Olympic Math 560 1110 3.05 10 10 65 137 O 550 Math 1430 3.35 80 Sophomore Yes Nobel 75 4 1 70 147 12 680 72 N N Sophomore M Yes Nobel Math 630 730 1360 3.7 Olympic Math 5 4 66 150 650 670 1320 2.83 96 Senior Yes 155 Yes Nobel Math 17 2 67 95 W H Junior 680 650 1330 3.05 10 71 160 2 Verbal 1090 3.19 80 Sophomore M Yes Nobel 550 540 Verbal 2 0 83 130 1220 2.75 74 Sophomore F Yes Nobel 620 N HK 8 10 61 180 600 78 N N Sophomore M Yes Olympic Math 540 450 990 3.02 1 65 150 Yes Nobel Verbal 1 72 Sophomore 550 550 1100 2.3 14 5 77 205 N - N 01 M yes Olympic Verbal 510 1010 2.35 FirstYear 500 15 60 Sophomore F Yes Olympic Math 12 115Question set 2B: Use Minitab to conduct a one- way ANOVA to compare the mean GPAs of the Olympic Medal, Academy Award, and Nobel Prize groups. Use the five- step hypothesis testing procedure. D Question 7 6 pts Question set 2 B: Step 1: State hypotheses and check assumptions V Paragraph BD Question 12 15 pts Question Set 2 B: Use Minitab to conduct Tukey simultaneous tests for differences in means. Remember to include all relevant output. Clearly, state which pairs are significantly different and which pairs are not significantly different. 12pt V Paragraph BQuestion 8 6 pts Question set 2 B: Step 2: Compute the test statistic 12pt V Paragraph V B D Question 4 5 pts Question set 2: Use Minitab to construct side- by-side boxplots to compare students who would prefer to win an Olympic Medal, Academy Award, and Nobel Prize in terms of GPA. For a review, see 3.3 in the online notes. 12pt Paragraph B\fD Question 6 10 pts Question set 2: Explain why a one-way ANOVA should be conducted to compare the mean GPAs of the Olympic Medal, Academy Award, and Nobel Prize groups as opposed to a series of three independent means t tests. 12pt V Paragraph BQuestion 10 6 pts Question set 2 B: Step 4: Decide to reject or fail to reject the null hypothesis 12pt V Paragraph V B D Question 5 5 pts Question set 2: Use Minitab to construct a dotplot with groups to compare students who would prefer to win an Olympic Medal, Academy Award, and Nobel Prize in terms of GPA. For a review, see 3.3 in the online notes. 12pt V Paragraph BQuestion 3 5 pts Question set 2: Use Minitab to compute the mean and standard deviation for the GPA variable for each of the three award groups separately (Stat > Basic Statistics > Display Descriptive Statistics > Variable = GPA and Group variable = Award). Remember to include your Minitab output and to identify your nal answers clearly. 12pt V Paragraph V B