HLT-362V Week 2 Population and Sampling Distribution Excel Worksheet

HLT-362V Week 2 Population and Sampling Distribution Excel  Worksheet                         Applied Statistics for Health Care Professionals - Population
and Sampling Distributions                 
Grand Canyon  University                                                                                                                            

Refer to "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.                                                                    

Topic 2: Population and Sampling Distribution Excel
Worksheet                                                                                 

Directions:  Answer all questions and submit to instructor at the end of Topic 2                                                 

1 A. For a normal distribution that has a mean of 100, and a standard deviation of 8, determine the Z-score for each of the following X values:                                                                                                                          

X = 108  Z =                                                                                                         

X = 112  Z =                                                                                                         

X = 98                    Z =                                                                                         

X = 70                    Z =                                                                                         

X = 124  Z =                                                                                                         

 

1 B. Use the information in 1 A. to determine the area or probability of the following:                                                                                                                    

p(x 108)                                                                                                                           

p(x < 98)                                                                                                                             

p(92 < x < 108)                                                                                                                  

p(84 < x < 116)                                                                                                                  

p(x< 84)……......................................................       
Powered by