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.
Attach your completed Excel spreadsheet(s) and submit them as your answer.
