This question set uses the StudentSurvey.MTW datafile. 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 how many hours per week they exercise. A. Use Minitab Express to compute the mean and standard deviation for the Exercise variable for each of the three award groups separately (Descriptive Statistics > Variable = Exercise and Group variable = Award). Remember to include your Minitab Express output and to clearly identify your final answers. B. Use Minitab Express 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 how many hours per week they exercise. For a review, see 3.3 in the online notes. C. Use Minitab Express to conduct a one-way ANOVA to compare the mean number of hours per week exercised by the Olympic Medal, Academy Award, and Nobel Prize groups. Use the five-step hypothesis testing procedure. Step 1: State hypotheses and check assumptions Step 2: Compute the test statistic Step 3: Determine the p-value Step 4: Decide to reject or fail to reject the null hypothesis Step 5: State a real-world conclusion D. Use Minitab Express 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. E. Write a few sentences summarizing the results of your one-way ANOVA and Tukey tests for a general audience. Imagine that you are explaining your results to someone with little or no knowledge of statistics.C15 C1-T C2-T C5-T C12 MathSAT SAT GPA Year Gender Award TV Height Weight siblings Senior No Math 10.0 180 640 670 1210 3.13 54 120 520 1150 Sophomo... Yes 56 530 2.50 66 Academy FirstYear No Nobel 14.0 72 208 650 560 1170 2.55 130 Junior No Nobel Math 1120 3.10 78 Sophomo... No Verba 65 720 450 3.20 80 Sophomo... No 5.0 65 2 600 550 1150 94 FirstYear No Olympic 10.0 10 66 640 680 Junior No Verbal 61 IN 550 550 1100 2.80 60 No Nobel 12.0 60 115 670 700 1370 3.70 94 N Sophomo... No Olympic Math 12.0 N 500 1170 2.09 63 N 580 72 13 Sophomo... No Math 12.0 68 530 620 1150 2.90 54 14 Junior No Nobel Verbal 6.0 68 135 650 650 3.08 66 No Nobel 5 68 700 650 72 15 Math 590 1200 3.86 59 16 No 10.0 No Verbal 3.0 15 33 99 - N 600 500 3.00 88 No Nobel 72 165 700 $50 3.00 69 No Nobel Math 62 3.35 N 550 450 3.30 No 10.0 cn 65 N 550 640 1190 3.40 74 21 No Nobel 2 68 560 570 2.90 70 Math 20 73 1180 58 FirstYear 48 24 No Olympic 10 74 200 550 650 1200 3.00 25 No Olympic Math 12.0 3 70 IN 650 580 3.30 74 No Nobel Math 10.0 5 71 175 N 700 720 3.70 60 No Nobel 14.0 74 185 580 1150 3.40 70 28 Math 12.0 6 68 190 550 560 1110 2.50 74 29 No 500 3.30 60 30 Senior No Olympic 10.0 72 165 IN 500 1000 610 620 3.50C16 C3-T C5-T Pulse Year Gender Exercise Siblings 82 500 560 1060 3.30 68 FirstYear No 10.0 20 640 640 1280 2.90 83 34 Senior No Nobel 6.0 10 72 2 53 2 158 2 1010 5.0 67 490 520 2.68 35 FirstYear No Olympic Math 5 62 2 560 580 No Olympic Math 5 73 560 640 FirstYear No 67 129 470 600 070 2.60 No 10.0 5 Sophomo.. Math 6.0 5 67 145 680 670 1350 89 Sophomo... No Academy 48 No 5.0 64 130 570 570 1140 cn 590 No 72 580 540 1120 2.40 73 No Nobel verbal 12.0 64 135 N 550 500 1050 3.00 80 13 Sophomo... No Olympic 2.0 70 145 1040 3.10 85 No Olympic Math 7.0 8 60 N 2 490 550 FirstYear 60 FirstYear 71 620 1240 No Verbal 73 620 7.0 20 72 174 560 550 1110 3.30 80 Senior No Olympic 20 74 160 630 690 2.90 70 48 No Olympic No 8.0 10 70 165 550 650 1200 3.16 58 No 14.0 3 2 590 580 1170 42 51 FirstYear No Olympic 14.0 68 160 640 730 1370 3.84 88 52 Senior No Nobel Math 14 64 130 1320 3.60 68 No Olympic Math 15.0 72 N 20 70 N 15.0 2 65 500 480 980 2.90 35 5 Junior No 6 72 160 620 600 220 3.00 90 FirstYear No Academy 3.0 15 63 600 660 1260 3.30 88 No Academy Math 490 520 1010 2.90 71 No Academy 20.0 N 64 620 1250 3.60 68 FirstYear No Nobel Verbal 3.0 65 135 N 3 630 N 73 No Academy 6.0 73 180 2 600 670 1270 3.56 61 Senior Nobe 12.0 155 590C1-T C3-T C4-T C5-T C6 CB C10 C12 C13 C14 C15 C16 C17 Year Gender Smoke Higher SAT TV Height Weight Siblings BirthOrder VerbalSAT MathSAT SAT GPA Piercings 62 Senior No Math 12.0 155 590 1200 3.70 55 63 No Olympic 550 520 1070 78 No 12 600 600 1200 96 FirstYear 500 Sophomo... No 10.0 3 65 140 600 650 1250 3.30 73 No Olympic Verbal 10.0 20 72 195 N 600 600 3.10 60 68 No 73 185 650 530 2.50 80 Senior No Verbal 12.0 79 209 560 520 1080 3.10 49 71 No Olympic Math 2.0 67 145 540 640 3.50 62 No Olympic 15.0 66 140 640 600 1240 3.00 68 No 10.0 66 146 690 620 1310 3.25 52 600 Sophomo... Nobel 610 650 1260 3.22 No Olympic Verbal 66 130 610 420 65 FirstYear No Olympic 15.0 66 600 600 90 No Olympic 65 No 5.0 66 560 580 1140 3.50 68 80 No Academy Math 10.0 20 76 150 620 680 1300 2.50 60 81 No Olympic Math 15.0 5 69 155 620 660 1280 3.40 65 82 FirstYear No Olympic Math 128 CO 630 650 1280 60 Nobel 65 640 640 1280 85 No Math 18.0 N 67 N 490 590 66 86 No Academy Math 16.0 66 138 550 560 1110 2.80 70 No Academy cn 72 690 550 1240 3.49 70 550 550 FirstYear No 20.0 69 191 600 580 1180 66 FirstYear No Nobel 5.0 69 165 cn 530 1140 2.70 69 No Olympic Math 10.0 73 200 520 620 1140 2.80 89 FirstYear No Olympic Verba 125 520 1180 3.13\fC1-T C2-T C3-T C4-T C5-T C16 GPA Year Gender Award Higher SAT TV Height Siblings BirthOrder VerbalSAT SAT 122 No Olympic 3.0 68 560 580 1140 260 50 123 No Verbal 78 600 600 3.40 70 Sophomo... 124 No 21.0 25 69 480 530 2.70 84 125 Sophomo... No Olympic 12.0 150 650 600 1250 3.15 68 No 600 76 127 No 20.0 70 195 640 640 1280 3.50 620 1230 2.90 65 128 No Olympic 8.0 3 75 230 N 610 Olympic 3 64 N 450 400 850 2.50 65 129 No 78 200 700 600 3.50 130 No Verbal 15.0 68 5 68 FirstYear No Nobel Verbal 69 550 540 1090 74 No 63 160 640 680 1320 3.00 76 133 Sophomo... 134 Sophomo... No Verbal 13.0 5 64 135 560 540 1100 3.0 79 135 No Nobel 63 2 530 700 3.84 81 No N 650 Nobe 10.0 63 235 550 560 1110 2.75 48 137 No No 10.0 140 520 540 1060 2.80 138 63 2 68 139 No Nobe Verbal 3.0 68 130 660 580 1240 3.00 62 Math 3 67 600 1070 3.10 70 No 3 71 No Verbal 65 560 550 1110 2.80 8 8 143 FirstYear No Math 2 72 183 520 540 1060 3.02 68 144 Junior No Verbal 18.0 20 75 175 560 500 2.93 74 145 No Nobel 3 59 125 600 600 3.20 88 69 420 147 No Olympic 20.0 63 145 540 630 1170 3.00 61 148 No Olympic 14.0 74 195 400 460 860 2.70 62 149 No Olympic Math 8.0 3 70 185 530 725 1255 3.20 69 59 150 FirstYear No 5 64 150 530 600 1130 5 FirstYear No Olympic Verbal 14.0 66 150 620 580 2.72\fYear Gender Smoke TV Height Weight MathSAT SAT GPA Pulse Piercings 1000 3.20 Olympic 15 74 184 No Math 16.0 10 135 600 650 185 No Verbal 14.0 130 620 520 3.57 186 No Math 10.0 10 73 230 530 620 1150 3.33 60 187 No Nobel Math 11.0 10 69 198 2 550 620 1170 2.90 188 No 10 66 127 600 1200 3.20 70 189 No Math 12.0 5 66 150 610 680 1290 3.10 53 190 Sophomo... No Math 5.0 73 175 550 600 3.25 70 191 Junior No Nobel Math 8.0 14 71 160 560 580 1140 3.40 75 1912 Junior No Nobel Math 8.0 6 65 140 670 710 3.80 84 N 193 No Nobel 3.0 cn 75 200 610 600 1210 3.38 66 194 No Nobe 8.0 63 130 660 720 3.88 195 No Olympic 20.0 14 74 210 630 660 2.75 70 196 No 10.0 70 210 NJ 520 580 2.90 197 No 3.0 3 63 145 670 750 3.60 198 No 75 156 550 FirstYear NO 10 680 1240 No 68 N No 10 68 2 72 N N 3.30 No Junior NO 5 660 204 No Nobel 65 136 760 205 Sophomo... No Nobe 10 65 680 1390 3.55 206 No 12.0 3 560 640 3.20 207 Sophomo... No 40 72 192 600 630 1230 208 FirstYear No 10 71 218 2 540 560 2.72 209 Sophomo... M No Nobel 14 68 600 640 1240 3.4 52 210 FirstYear No Nobel 10.0 72 220 N 600 570 1170 66 211 No Academy Math 2 64 150 550 560 1110 3.40 55 cn No Verbal 5.0 71 135 550 550 3.10 63\fC1-T C3-T C5-T C6 C8 C9 C10 C12 C13 C14 C15 C16 C17 Year Gender Smoke Award HigherSAT Exercise TV Height Weight Siblings MathSAT SAT GPA 243 FirstYear No Academy 3.0 170 440 560 1000 3.10 42 244 Sophomo... No Verbal 11.0 63 120 700 550 1250 2.89 60 660 560 2.81 59 246 63 247 FirstYear No lath 12.0 70 182 600 620 1220 248 Sophomo... No Verbal 15.0 2 67 138 2 760 640 3.30 52 249 Sophomo... No Math 74 180 680 740 3.00 88 Olympic Math 251 No 12.0 70 222 510 730 1240 3.50 66 252 FirstYear No Academy 5.0 2 70 145 600 600 1200 3.60 55 253 M No Nobel 10.0 70 150 650 680 3.70 74 No Verbal 2.0 68 190 700 670 1370 3.20 59 Olympic 256 No Nobe Verbal 59 520 520 3.30 68 257 Junior No 66 140 580 530 1110 3.30 74 258 Sophomo... No 12.0 68 155 600 600 3.45 58 No Math 3.10 62 260 No Math 8.0 69 155 750 780 1530 3.71 84 261 No 5.0 130 650 650 1300 3.30 72 262 No 6.0 14 75 210 2 $50 580 1130 3.30 52 263 Missing No Verbal 8.0 63 105 650 600 1250 80 68 265 Olympic 18.0 660 1330 266 Junior No Verba 12.0 64 134 2 640 640 3.89 55 267 No Math 10.0 5 68 160 530 650 3.05 68 268 Junior No 10.0 5 68 135 690 650 1340 3.20 67 270 No 7.0 66 135 600 550 1150 2.90 66 271 No Olympic 3.0 5 74 145 2 560 620 1180 3.00 70 272 No 7.0 64 140 2 720 690 1410 3.50 78 273 No 3.0 610 1250 3.50 88720 274 Verbal 65 1150 FirstYear No Nobel Verbal N 130 N 620 570 1190 63 64 276 Sophomo... No Olympic Verbal 72 210 550 690 1240 2.70 70 277 Senior No Nobel Math 7.0 800 3.78 278 Senior No Verbal 69 233 1360 Olympic Olympic 67 185 550 600 1150 No 76 189 3 620 470 1090 3.30 281 Sophomo... No Olympic 5.0 cn 66 127 520 620 1140 2.80 64 6 282 No Olympic Math 14.0 5.0 63 135 440 640 2.50 60 No 140 1420 Academy 66 700 284 Verbal 720 68 63 No Verbal 67 215 560 560 1120 3.40 286 Sophomo... Senior No Olympic Math 15.0 73 2 570 610 1180 3.00 287 62 120 660 600 1260 3.27 84 288 Sophomo... No Nobel Verbal 620 640 1260 3.50 74 289 No Nobe 2 67 15.0 71 2 660 FirstYear Olympic 160 2 630 610 1240 3.60 78 66 291 Sophomo... No Olympic 5.0 1210 3.25 65 292 No 20.0 68 145 N 610 600 293 No Academy 3.0 cn 60 180 540 680 1220 3.00 68 71 570 $70 1140 2.75 76 No Nobel 7.0 295 Olympic Sophomo... No Olympic Missing 10.0 10 65 155 600 600 3.00 296 530 640 1170 3.00 88 297 Senior M No Nobel Math 6.0 15 65 140 3 No Olympic 6.0 66 145 2 560 2.90 298 N 560 560 1120 3.36 299 No Nobel Verbal 10.0 71 2 500 1.5 20 67 130 560 180 1040 301 No Olympic 60 302 No Olympic 20.0 28 72 195 500 700 1200 2.76 Sophomo... No Nobel Math 8.0 67 165 N 640 650 1290 73 304 Verbal 21.0 3 No Olympic 180 660 570