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                                                                                         

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?                                                                                               

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..........................
Powered by