HLT-362V Week 3 Benchmark - Hypothesis Testing Excel Worksheet

HLT-362V Week 3 Benchmark - Hypothesis Testing Excel Worksheet

HLT-362V Week 3 Benchmark - Hypothesis Testing Excel Worksheet

Answer each question completely to receive full credit

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 7 32 23 22 6 16
11 20 19 6 17 35 6
10 34 32 25 13 9 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?

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 to the right to test this claim.

Men Women
20 29
37 28
46 20
23 28
20 42
23 45
21 19
15 45
20 16
28 32
27 38
20 45
30 41
22 34
27 28
38 21
29 42
20 21
16 30
27 28
42 30
37 43
39 40
39 16
32 44
16 15
21 16
26 20
17 41
39 16
Powered by