Part C: Exercise Your classmates were invited to complete a MATH 1P98 student survey. In this last part of the assignment, you will work with the results from that survey. Students were asked, "How many days in a week do you exercise for more than 20 minutes?". Students could choose to respond between 0 days to 7 days. See the Excel sheet "Assignment 3- Survey given in in the "Written Assignment 3" folder on Sakai for the responses. 4. (Submit a screenshot of your written or typed answer.) A fitness trainer is interested in finding out the true mean number of days that MATH 1P98 students exercise in a week. The trainer claims that the mean number of days in a week that MATH 1P98 students exercise for more than 20 minutes is 3.5 days. Test this claim at the 0.05 level of significance. a. State the null and alternative hypotheses. Indicate the significance level. b. Identify the test statistic you will use. Are the requirements needed to use that test statistic satisfied? Explain. (Hint: How do you decide between using z ort? Check if the data follows a normal distribution and/or sample size.) c. Use Excel to obtain any sample statistics necessary to calculate the test statistic. (You do not need to submit the Excel sheet.) Then, calculate the test statistic by hand. Show your work. d. Use the Brock Excel calculator to check your answer for part c. Submit a screenshot of that sheet, including all input values and output results. e. Write the critical value(s) used for this test. Compare your test statistic to explain whether or not the null hypothesis is rejected. f. Write a concluding statement that addresses the fitness trainer's claim. 5. (Submit a screenshot of your written or typed answer.) A fitness trainer is interested in finding out if there is a difference between the mean number of days that female MATH 1P98 students exercise and the mean number of days that male MATH 1P98 students exercise. When completing the survey, respondents could self-identify their gender. Students without a response in the Gender column either preferred not to answer or self-identified differently from "female" or "male". Because the focus of this study is interested in comparing exercise days between female and male students, we will only consider the exercise data available for the n = 185 students who identified as female and the n = 236 students who identified as male. a. Filter the data so that you can separate the number of exercise days for female students and the number of exercise days for male students. (There is nothing to submit for this part.) b. Use Excel to compute the summary statistics for each sample. Since you will use these values in calculations, write & and s with four decimals. For this part, submit only the completed table. 2 s Female Male c. Identify whether the two samples are independent or dependent. Provide an explanation. d. Use the sample data to construct a 95% confidence interval by hand to estimate the mean difference of the exercise days between female students and male students. Show your work, including all calculations. e. Check your answer for part d. using the Brock Excel calculator. Submit a screenshot of that sheet, including all input values and output results. f. Report the 95% confidence interval with three decimal places. Interpret this confidence interval in the context of the problem. g. Does the confidence interval suggest there is a difference between the number of days that female MATH 1P98 students exercise and the number of days that male MATH 1P98 students exercise? Explain how you know. If there is a difference, identify which group exercises on more days, on average. A 1 Gender 2 Male 3 Male 4 Male 5 Male 6 Male 7 Male 8 Female B Academic Faculty Goodman School of Busines Goodman School of Busines Goodman School of Busines Goodman School of Busines Applied Health Sciences Goodman School of Busines Goodman School of Busines C Exercise Days 6 7 3 7 6 1 0 9 Male Mathematics and Science 0 10 Male Goodman School of Busines 4 11 Male Goodman School of Busines 0 12 Male Goodman School of Busines 7 13 Female Social Sciences 5 14 Male Goodman School of Busines 2 15 Male Goodman School of Busines 5 16 Male Goodman School of Busines 6 17 Male Goodman School of Busines 6 18 Male Goodman School of Busines 6 19 Female 20 Male 21 Female 22 Male 23 Male Goodman School of Busines 5 Mathematics and Science 6 Goodman School of Busines 2 Goodman School of Busines 3 Social Sciences 0 24 Female Applied Health Sciences 4 25 Male Mathematics and Science 6 26 Male Goodman School of Busines 3 27 Female Goodman School of Busines 0 28 Male Goodman School of Busines 2 29 Female 30 Female Mathematics and Science Goodman School of Busines 6 5 31 Female Goodman School of Busines 0 32 Male Social Sciences 5 33 Male Goodman School of Busines 3 34 Male Goodman School of Busines 7 35 Male 36 37 Male Goodman School of Busines Mathematics and Science Goodman School of Busines 2 0 5 1 Gender 59 Female 60 Male 61 Male 62 Female 63 Female 64 Male 65 Female 66 Male 67 Male 68 Female 69 Male Academic Faculty Applied Health Sciences Goodman School of Busines Goodman School of Busines Goodman School of Busines Mathematics and Science Mathematics and Science Goodman School of Busines Mathematics and Science Goodman School of Busines Mathematics and Science Exercise Days 5 7 7 0 4 7 6 4 5 7 Mathematics and Science 1 70 Male Goodman School of Busines 0 71 Male Social Sciences 7 72 Male Mathematics and Science 7 73 Male Goodman School of Busines 4 74 Female Goodman School of Busines 0 75 Male Goodman School of Busines 3 76 Male Goodman School of Busines 5 77 Male Goodman School of Busines 4 78 Male 79 Male Goodman School of Busines Social Sciences 6 0 80 Male Goodman School of Busines 3 81 Female Goodman School of Busines 0 2 5 5 82 Female 83 Female 84 Female 85 Male 86 Female 87 Male 88 Female 89 Male 90 Male 91 Female 92 Male 93 Male Goodman School of Busines Applied Health Sciences Applied Health Sciences Goodman School of Busines Mathematics and Science Goodman School of Busines Mathematics and Science Goodman School of Busines Goodman School of Busines Applied Health Sciences Goodman School of Busines Social Sciences 7 1 7 2 2 2 1 5 1 94 Female 95 Male Goodman School of Busines Goodman School of Busines 3 0 96 Female Mathematics and Science 5 97 Female Goodman School of Busines 5 98 Female Goodman School of Busines 2 99 Male Goodman School of Busines 6 100 Female Social Sciences 0 101 Male 5 102 Female Goodman School of Busines 5 103 Male Goodman School of Busines 4 104 Male Mathematics and Science 7 105 Male Mathematics and Science 0 106 Female Mathematics and Science 0 107 Female 108 Male 109 Female Mathematics and Science Goodman School of Busines Mathematics and Science 4 3 0 110 Male Goodman School of Busines 4 111 Male Goodman School of Busines 5 112 Male Goodman School of Busines 7 113 Male Goodman School of Busines 3 114 Male Applied Health Sciences 5 115 Male Goodman School of Busines 4 A 1 Gender 116 Female 117 Male 118 Male 119 Male Academic Faculty Applied Health Sciences Goodman School of Busines Goodman School of Busines Goodman School of Busines Exercise Days 3 6 4 0 120 Male Goodman School of Busines 1 121 Male 122 Male 133 Male 134 Male 135 136 Male 123 Female 124 125 Female 126 Male 127 Male 128 Female 129 Female 130 Female 131 Female 132 Female Goodman School of Busines Goodman School of Busines Mathematics and Science Applied Health Sciences Goodman School of Busines Goodman School of Busines Goodman School of Busines Goodman School of Busines Applied Health Sciences Mathematics and Science Goodman School of Busines Goodman School of Busines 2 3 5 1 3 Social Sciences 6 7 Goodman School of Busines 3 0 4 0 4 3 5 Goodman School of Busines 7 Goodman School of Busines 7 137 Female Goodman School of Busines 0 138 Male Mathematics and Science 4 139 Male 140 Male Goodman School of Busines Goodman School of Busines 4 7 141 Male 142 Male 143 Female Applied Health Sciences Mathematics and Science Applied Health Sciences 1 7 3 144 Female Social Sciences 6 145 Male 146 Male Goodman School of Busines 7 Social Sciences 6 147 Female Applied Health Sciences 3 148 Male 149 Male Goodman School of Busines Humanities 6 7 150 Female Goodman School of Busines 3 151 Male Goodman School of Busines 5 152 Male 153 Male Goodman School of Busines Goodman School of Busines 7 4 154 Male Applied Health Sciences 5 155 Goodman School of Busines 0 156 Female Goodman School of Busines 4 157 Male Goodman School of Busines 7 158 Male 159 Male Goodman School of Busines Mathematics and Science 1 6 160 Male 161 Male Goodman School of Busines Goodman School of Busines 2 0 162 Female Applied Health Sciences 0 163 Female Goodman School of Busines 3 164 Female Goodman School of Busines 1 165 Male Goodman School of Busines 4 166 Male Social Sciences 6 167 Female Goodman School of Busines 2 168 Female Goodman School of Busines 2 169 Female Applied Health Sciences 4 170 Female Goodman School of Busines 1 171 Male Goodman School of Busines 6 172 Male Goodman School of Busines 3 1 Gender 173 Female 174 Female 175 Female 176 Female 177 Male 178 Female 179 Male 180 Male 181 Female 182 Female 183 Female 184 185 Female 186 Female 187 Male 188 Female 189 Female 190 Male 191 Female 192 Male Academic Faculty Goodman School of Busines Goodman School of Busines Mathematics and Science Goodman School of Busines Goodman School of Busines Goodman School of Busines Goodman School of Busines Mathematics and Science Goodman School of Busines Mathematics and Science Goodman School of Busines Goodman School of Busines Goodman School of Busines Goodman School of Busines Goodman School of Busines Mathematics and Science Goodman School of Busines Goodman School of Busines Mathematics and Science Exercise Days 4 0 0 7 0 3 3 3 4 0 6 3 2 3 5 4 2 5 4 Goodman School of Busines 4 193 Female Social Sciences 4 204 Male 205 Male 194 Female 195 Female 196 Male 197 Female 198 Female 199 Male 200 Male 201 Female 202 Female 203 Male Goodman School of Busines Applied Health Sciences Mathematics and Science Goodman School of Busines Goodman School of Busines Humanities 1 Applied Health Sciences Mathematics and Science Mathematics and Science Goodman School of Busines Goodman School of Busines 5 3 1 0 5 Goodman School of Busines 2 0 1 4 6 5 206 Female Goodman School of Busines 7 207 Male Goodman School of Busines 2 208 Female Goodman School of Busines 7 209 Male Goodman School of Busines 5 210 Male Goodman School of Busines 5 211 Female 212 Female 213 Female 214 Female 215 Male Goodman School of Busines 7 Applied Health Sciences Humanities 3 7 Mathematics and Science 1 Goodman School of Busines 4 216 Male Social Sciences 5 217 Male Goodman School of Busines 6 218 Male Goodman School of Busines 2 219 Female Applied Health Sciences 3 220 Female Goodman School of Busines 5 221 Female Goodman School of Busines 0 222 Male Mathematics and Science 6 223 Male Goodman School of Busines 5 224 Female Goodman School of Busines 2 225 Female Goodman School of Busines 6 226 Male Goodman School of Busines 0 227 Female Applied Health Sciences 2 228 Male 229 Male Mathematics and Science 5 Goodman School of Busines 7 238 Male 239 Male 240 Female Gender 230 Male 231 Female 232 Male 233 Male 234 Male 235 Male 236 Male 237 Female Academic Faculty Goodman School of Busines Applied Health Sciences Mathematics and Science Mathematics and Science Mathematics and Science Goodman School of Busines Mathematics and Science Goodman School of Busines Mathematics and Science Humanities Goodman School of Busines Exercise Days 3 1 5 2 2 4 0 2 0 5 4 241 Female 242 Male 243 Female Mathematics and Science 3 Goodman School of Busines 1 Goodman School of Busines 4 244 Female 245 Female 246 Male 247 Male 248 Male 249 Male 250 Female 251 Male Social Sciences Goodman School of Busines Mathematics and Science Goodman School of Busines Goodman School of Busines Mathematics and Science Goodman School of Busines Goodman School of Busines 3 4 3 7 0 3 6 5 252 Male Goodman School of Busines 7 253 Female Goodman School of Busines 3 254 Female Goodman School of Busines 4 255 Female Goodman School of Busines 0 256 Male 257 Female 258 Female 259 Female 260 Male Goodman School of Busines Goodman School of Busines Mathematics and Science Mathematics and Science Goodman School of Busines 6 4 6 5 4 261 Female Goodman School of Busines 0 262 Male Goodman School of Busines 2 263 Male Mathematics and Science 2 264 Male Goodman School of Busines 6 265 Male Goodman School of Busines 7 266 Female 267 Male Goodman School of Busines 4 Social Sciences 7 268 Female 269 Female 270 Male Applied Health Sciences Goodman School of Busines Mathematics and Science 2 2 0 271 Female Social Sciences 0 272 Male 273 Female Goodman School of Busines 7 Goodman School of Busines 2 274 Male Goodman School of Busines 5 275 Male Mathematics and Science 6 276 Male Goodman School of Busines 5 277 Male Goodman School of Busines 0 278 Male 279 Male 280 Male 281 Female Applied Health Sciences Goodman School of Busines Mathematics and Science Social Sciences 1 7 6 4 282 Female Goodman School of Busines 7 283 Male Goodman School of Busines 6 284 Female Goodman School of Busines 0 285 Male Mathematics and Science 0 286 Male Goodman School of Busines 6 A 1 Gender 286 Male 287 288 Male 289 Female 290 Female 291 Female 292 Male 293 Male 294 Male 295 Female 296 Female 297 Male B Academic Faculty Goodman School of Busines Goodman School of Busines Goodman School of Busines Goodman School of Busines Goodman School of Busines Goodman School of Busines Goodman School of Busines Goodman School of Busines Mathematics and Science Social Sciences Goodman School of Busines Goodman School of Busines C Exercise Days 6 2 0 0 3 3 2 0 3 2 6 3 298 Male Goodman School of Busines 4 299 Female 300 Female 301 Male 302 Male Goodman School of Busines Goodman School of Busines Social Sciences 0 1 6 Goodman School of Busines 6 303 Female Goodman School of Busines 2 304 Male 305 Male 306 Male 307 Male Goodman School of Busines Mathematics and Science Mathematics and Science Goodman School of Busines 6 3 3 1 308 Female 309 Male Goodman School of Busines Goodman School of Busines 7 2 310 Male Goodman School of Busines 7 311 Female Goodman School of Busines 5 312 Female Goodman School of Busines 4 313 Female Social Sciences 7 314 Female Goodman School of Busines 2 315 Male Goodman School of Busines 6 316 Female 317 Female 318 Female 319 Female Applied Health Sciences Mathematics and Science Mathematics and Science Goodman School of Busines 3 2 7 6 320 Male 321 Goodman School of Busines 4 Female Goodman School of Busines 0 322 Female Goodman School of Busines 0 323 Male Goodman School of Busines 0 324 Female Goodman School of Busines 0 325 Female Goodman School of Busines 1 326 Female Goodman School of Busines 2 327 Female Goodman School of Busines 5 328 Male Goodman School of Busines 3 329 Female 330 Male 331 Female 332 Male 333 Female 334 Male 335 Female Mathematics and Science Mathematics and Science Applied Health Sciences 7 3 2 3 Applied Health Sciences 3 336 Male 337 Female 339 Male 340 Male Applied Health Sciences 338 Female Applied Health Sciences 341 Female Goodman School of Busines Mathematics and Science Goodman School of Busines Mathematics and Science Goodman School of Busines 2 2 4 0 1 1 4 342 Male Mathematics and Science Mathematics and Science 2 2 372 Male 373 Male 374 Male 375 Female 376 Male 1 Gender 343 Female 344 Male 345 Male 346 Female 347 Female 348 Female 349 350 Female 351 Male 352 Male 353 Female 354 Male 355 Female 356 Female 357 Male 358 Male 359 Male 360 Female 361 Female 362 Male 363 Male 364 Female 365 Male 366 Male 367 Male 368 Female 369 Female 370 Male 371 Female Academic Faculty Applied Health Sciences Goodman School of Busines Goodman School of Busines Mathematics and Science Goodman School of Busines Goodman School of Busines Applied Health Sciences Applied Health Sciences Goodman School of Busines Applied Health Sciences Goodman School of Busines Goodman School of Busines Humanities Goodman School of Busines Applied Health Sciences Mathematics and Science Applied Health Sciences Social Sciences Applied Health Sciences Goodman School of Busines Goodman School of Busines Applied Health Sciences Goodman School of Busines Goodman School of Busines Mathematics and Science Humanities Mathematics and Science Humanities Goodman School of Busines Goodman School of Busines Exercise Days 0 3 0 4 5 3 7 3 5 1 3 7 2 3 2 2 4 1 1 7 6 3 3 0 4 0 5 3 7 Mathematics and Science 0 Mathematics and Science Goodman School of Busines 2 0 Mathematics and Science 2 377 Female 378 Male 379 Female 380 Female 381 Male 382 Female 383 Male 384 Male Applied Health Sciences Applied Health Sciences Mathematics and Science Applied Health Sciences Applied Health Sciences 0 Goodman School of Busines 2 Goodman School of Busines 4 0 0 6 Goodman School of Busines 6 385 Female Goodman School of Busines 0 386 Goodman School of Busines 2 387 Male Goodman School of Busines 5 388 Male Goodman School of Busines 3 389 Female Mathematics and Science 2 390 Male Goodman School of Busines 3 391 Female Goodman School of Busines 2 392 Male Goodman School of Busines 7 393 Male 3 394 Male Mathematics and Science 0 395 Male Goodman School of Busines 5 396 Male Goodman School of Busines 4 397 Female 398 Female 399 Male Goodman School of Busines 3 Applied Health Sciences 2 Goodman School of Busines 5 1 Gender 385 Female 386 387 Male 388 Male 389 Female 390 Male 391 Female 392 Male 393 Male 394 Male 395 Male Academic Faculty Goodman School of Busines Goodman School of Busines Goodman School of Busines Goodman School of Busines Mathematics and Science Goodman School of Busines Goodman School of Busines Goodman School of Busines Mathematics and Science Goodman School of Busines Exercise Days 0 2 5 3 2 3 2 7 3 0 5 396 Male Goodman School of Busines 4 397 Female 398 Female 399 Male 400 Male Applied Health Sciences 401 Male 402 Male Goodman School of Busines Goodman School of Busines Goodman School of Busines Mathematics and Science Goodman School of Busines 3 2 5 0 2 0 403 Female Goodman School of Busines 4 404 Male Goodman School of Busines 5 405 Male Goodman School of Busines 7 406 Male Goodman School of Busines 7 407 Female 408 Female Goodman School of Busines Goodman School of Busines 2 3 409 Female Applied Health Sciences 3 410 Male Goodman School of Busines 7 413 416 Male 411 Male 412 Female Male 414 Male 415 Female Social Sciences Mathematics and Science Mathematics and Science Goodman School of Busines Goodman School of Busines 7 Applied Health Sciences 3 2 1 1 3 417 Female Social Sciences 0 418 Female 419 Male Goodman School of Busines Humanities 0 0 420 Female Goodman School of Busines 0 421 Female Mathematics and Science 5 422 Female Applied Health Sciences 7 423 Female 424 Female 425 Female 426 Female Applied Health Sciences Mathematics and Science Applied Health Sciences Applied Health Sciences 3 2 4 5 427 Male Goodman School of Busines 3 428 Male Goodman School of Busines 5 429 Female Mathematics and Science 2 430 Male Goodman School of Busines 4