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

HLT-362V Week 3 Benchmark: Hypothesis Testing  Excel Worksheet                                  Applied Statistics for Health Care Professionals - Hypothesis Testing                                  Grand Canyon University

Refer to the "Visual Learner: Statistics" for examples to help complete the problems in the attached worksheet. Also, to aide in the Excel calculations, view the appropriate section of the Excel tutorials.
Answer each question completely in the Excel worksheet provided.

Hypothesis Testing

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?

State the Null Hypothesis

State the Alternative Hypothesis

State the Level of significance

State the Test Statistic

Perform Calculations

Statistical Conclusion

Experimental Conclusion

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

State the Null Hypothesis

State the Alternative Hypothesis

State the Level of significance

State the Test Statistic

Perform Calculations

Statistical Conclusion

Experimental Conclusion..........................