Topic 3: Hypothesis testing Excel Worksheet Directions: Answer all questions and submit to instructor at the end of Module 2 To answer a question, please click on \"Choose an item\" and on the dropdown arrow and choose an answer. Here is a resulting drop-down list: If it is not working, you can enter your answers to the table at the end of the file. 1. There is a new drug that is used to treat leukemia. The following data represents the remission time in weeks for a random sample of 21 patients using the drug. 10 11 10 7 20 34 32 19 32 23 6 25 22 17 13 6 35 9 16 6 6 Let X be a random variable representing the remission time in weeks for all patients using the new drug. Assume that the distribution of x is normal. A previously used drug treatment has a mean remission time of 12.5 weeks. Does the data indicate that the mean remission time using the new drug is different from 12.5 week at a level of significance of 0.01? State the null hypothesis: A. B. C. D. =12.5 12.5 <12.5 >12.5 Answer: Choose an item. State the alternative hypothesis: A. B. C. D. =12.5 12.5 <12.5 >12.5 Let X be a random variable representing the remission time in weeks for all patients using the new drug. Assume that the distribution of x is normal. A previously used drug treatment has a mean remission time of 12.5 weeks. Does the data indicate that the mean remission time using the new drug is different from 12.5 week at a level of significance of 0.01? Answer: Choose an item. State the level of significance: A. B. C. D. 0.001 0.01 0.05 0.10 Answer: Choose an item. State the test statistic: A. B. C. D. 0.058 0.552 1.058 2.106 Answer: Choose an item. Perform calculations Please write down your solutions or copy and paste your Excel output here: Then answer the following two questions: Critical value: A. B. C. D. 0.050 1.960 2.086 2.845 Answer: Choose an item. P-value: A. p <0.001 B. 0.001 p <0.01 C. 0.01 p <0.05 D. 0.05 p Answer: Choose an item. Statistical Conclusion A. Reject the null hypothesis B. Do not reject the null hypothesis Answer: Choose an item. Experimental Conclusion A. There is sufficient evidence to conclude that the mean remission time using the new drug is different from 12.5 week at a level of significance of 0.01. B. There is no sufficient evidence to conclude that the mean remission time using the new drug is different from 12.5 week at a level of significance of 0.01. Answer: Choose an item. 2. We wish to test the claim that the mean body mass index (BMI) of men is equal to the mean BMI of women. Use the data below to test this claim. Men 20 37 46 23 20 23 21 15 20 28 27 20 30 22 27 38 29 20 Women 29 28 20 28 42 45 19 45 16 32 38 45 41 34 28 21 42 21 16 27 42 37 39 39 32 16 21 26 17 39 30 28 30 43 40 16 44 15 16 20 41 16 State the Null Hypothesis A. B. C. D. 1 = 2 1 2 1 > 2 1 < 2 Where 1 and 2 are the mean body mass index for men and women, respectively. Answer: Choose an item. State the alternative hypothesis: A. B. C. D. 1 = 2 1 2 1 > 2 1 < 2 Answer: Choose an item. State the Level of significance State the level of significance: A. B. C. D. 0.001 0.01 0.05 0.10 Answer: Choose an item. State the test statistic (its absolute value, for example the absolute value of -1.5 is 1.5): A. B. C. D. 0.058 0.515 1.273 2.108 Answer: Choose an item. Perform calculations Please write down your solutions or copy and paste your Excel output here: Then answer the following two questions: Critical value: A. B. C. D. 0.050 1.960 2.002 2.045 Answer: Choose an item. P-value: A. p <0.001 B. 0.001 p <0.01 C. 0.01 p <0.05 D. 0.05 p Answer: Choose an item. Statistical Conclusion A. Reject the null hypothesis B. Do not reject the null hypothesis Answer: Choose an item. Experimental Conclusion A. There is sufficient evidence to conclude that the mean body mass index (BMI) of mean is equal to the mean BMI of women. B. There is no sufficient evidence to conclude that that the mean body mass index (BMI) of mean is equal to the mean BMI of women. Answer: Choose an item. Grading Please do not make any changes for the following grading table unless you have a problem with the drop-down lists (then you can enter your answers in the second column). If you use the drop-down lists, the instructor will update your answers in the table. Thanks Question 1 H0 H1 Sig. level Test statistic* Critical value P-value Stat conclusion Experimental conclusion 2 H0 H1 Sig. level Test statistic* Critical value P-value Stat conclusion Experimental conclusion Total *including grade for calculations Your answer Correct answer Possible points 5 5 3 12 5 4 5 5 5 5 5 12 5 4 5 5 90 Your points