Using Excel to Find Normal Distribution Areas”  and complete the following steps on a blank Excel worksheet:

Assignment
Part 1
View video 6-1 “Using Excel to Find Normal Distribution Areas”  and complete the following steps on a blank Excel worksheet:

· 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 Video 6-1 “Using Excel for Finding a z Score From a Known Area” and complete the following steps on a blank Excel worksheet:

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

Last Completed Projects