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

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)