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

in Other (Other) by professor22
Previewing 1 of 14 total pages.
Money-back guarantee
Regular Price: \$21.43
You Save: \$6.43

You have 0 credits. Earn credits

#### Description

15 A+ Solutions

(HLT-362V-O103)

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

Applied Statistics for Health Care Professionals - Hypothesis Testing

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.

+11

+11

+11

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 ?

State the Null Hypothesis

State the Alternative Hypothesis

State the Level of significance

State the Test Statistic

Perform Calculations

Statistical Conclusion

Experimental Conclusion

1. 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.

MenWomen

2029

3728

4620

2328

2042

2345

2119

1545

2016

2832

2738

2045

3041

2234

2728

3821

2942

2021

1630

2728

4230

3743

3940

3916

3244

1615

2116

2620

1741

3916

State the Null Hypothesis

State the Alternative Hypothesis

State the Level of significance

State the Test Statistic

Perform Calculations

Statistical Conclusion

Experimental Conclusion

professor22
@dgoodz
3734
246
Rating:
Published On:
07/09/2016
Print Length:
14 page(s)
File Name:
hlt-362v-week-3-benchmark-hypothesis-testing-excel-worksheet-85.xlsx
File Size:
17.63 KB (0.02 MB)
Sold By:
professor22
Purchased:
2 times
Best Seller Ranking:
#5910