AutoSave OFF @ E. Chapters 10-11 Summer 2021 Homework Home Insert Draw Page Layout Formulas Data Review View XLSTAT Tell me Share 0 Comments NIT Calibri (Body) v 11 X LO A V ab Wrap Text General F WE ILX Ayo Paste BIU v E Merge & Center a Av A $ % ) Insert .00 000 v Format Delete Conditional Format Cell Formatting as Table Styles v Sort & Filter Find & Select Analyze Data Yes No Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? fox C19 y A B D F G . H 1 1 K M N 0 O R S T U V w w x Y Y Z 10.3 A company researcher wants to test a new formula for a sports drink that has been designed to improve running performance. Instead of the regular "carbohydrate-only drink that the company produces, this new sports drink contains a "carbohydrate-protein" formula. The researcher would like to know whether this new carbohydrate-protein sports drink leads to a difference in running performance compared to the carbohydrate-only sports drink. To carry out the experiment, the researcher recruited 20 middle distance runners. All of these participants performed two trials in which they had to run as far as possible for 2 hours on a treadmill. In one of the trials, all 20 participants drank from a bottle containing the carbohydrate-only formula. In the other trial, the same 20 participants drank from a bottle containing the carbohydrate-protein formula. Whilst all participants completed both trials, the order in which they underwent the trials differed, which is known as counterbalancing. At the end of the two trials, the distance each participant ran (in km) was recorded. A) Determine whether there is a statistically significant difference in distance run between the two trials fi.e., when using the carbohydrate-protein drink compared to the carbohydrate-only drink). B) What assumptions is necessary about the population dstribution in order to perform this test? C) Use a graphical method to test the validity of the assumption. D) Construct and interpret a 95% confidence interval estimate of the differnce in the mean run time between the two sets of runners (Hint: You may need to look in your book for the 1 Null Hypothesis 2 Alternative Hypothesis 3 4 type of test 5 test Statistic Value 6 P-value 7 Decision State your decision Relative to the Problem 8 9 Part B. 10 Assumption: 11 Part C. 12 Show graph on right 13 Part 14 CL Lower Bound 15 CI Upper Bound 16 Interpretation of CI 17 18 Carb Carb_Protein 19 10.575 10.53 20 10.89 11.16 21 10.17 10.305 22 11.61 11.79 23 11.79 11.88 24 9.72 9.81 25 10.8 10.98 26 11.79 12.01 27 10.575 10.755 28 10.98 11.115 29 11.655 11.7 30 12.375 12.375 31 10.08 10.215 32 10.755 11.07 33 11.07 1135 34 11.745 11.745 35 11.25 11.385 36 12.15 12.24 37 11.43 1152 38 11.925 12.105 39 40 41 42 43 44 45 46 47 Hints Ch10 Answers Ch11 Ans. 10.1 10.2 10.3 10.4 11.1 11.2 11.3 Paired Paired Low Paired_Upper Pooled Pooled LOWE + Ready + 84%