Using Excel to Calculate Normal Distribution Areas, Z Scores, and Normal Quantile Plot

In this week’s lesson, we will be learning how to use Excel to calculate normal distribution areas, z scores, and normal quantile plot.

Resources to consult: See the videos marked 6-1, 6-5 Triola Stats Excel Videos

Assignment

Part 1

View the video and complete the following steps on a blank Excel worksheet. 6-1 Using Excel to Find Normal Distribution Areas [03:05]

In cell A1, find the probability that the z score is less than 1.27 when the mean is 0 and the standard deviation is 1.

Save the completed worksheet as W5_6-1_Normal.xls

Part 2

View the video and complete the following steps on a blank Excel worksheet. 6-1 Using Excel for Finding a z Score From a Known Area [03:03]

In cell A1, find a z score corresponding to the 95 percentile when the mean is 0 and the standard deviation is 1.

Save the completed worksheet as W5_6-1_ZScore.xls

Submission

You are to submit the following files in the assignment dropbox:

· W5_6-1_Normal.xls

· W5_6-1_ZScore.xls