# Complete in excel

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

Resource to consult: https://www.triolastats.com/es13-excel-videos See the videos marked 6-1, 6-5

View video “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.

Once you have completed all the steps, save the completed worksheet for you to turn in.

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.

Once you have completed all the steps, save the completed worksheet for you to turn in.