# 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

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

You'll get a 20.2KB .XLSX file.