Order from us for quality, customized work in due time of your choice.
Assignment
Part 1
View video 6-1 “Using Excel to Find Normal Distribution Areas” (https://www.youtube.com/watch?v=mrX2WD0OUxU) 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” (https://www.youtube.com/watch?v=6OucJx6komQ) 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.
Save the completed worksheet as W5_6-1_ZScore.xls
Order from us for quality, customized work in due time of your choice.