Hlt-362v (hlt-362v-o103) week 3 benchmark: hypothesis testing excel

Category: Mathematics

  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               

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Pay Someone To Write Essay