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

PLDZ-7 In Stock
\$ 15.00 USD
Description

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.

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 617 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

Recent Reviews Write a Review
0 0 0 0 reviews