Executive Solution Overview
– ## MathW5HM.docx **## MathW5HM.docx** **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 vid…
Instant Solution Download
$6.99Immediate access to the full model answer, formatted citations, and rubric breakdown.
Need a Fresh Custom Paper?
Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →Assignment Prompt & Instructions
– ## MathW5HM.docx
**## MathW5HM.docx**
**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](https://www.triolastats.com/es13-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]](https://www.youtube.com/watch?v=mrX2WD0OUxU)
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]](https://www.youtube.com/watch?v=6OucJx6komQ)
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
**## MathW5HM.docx**
**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](https://www.triolastats.com/es13-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]](https://www.youtube.com/watch?v=mrX2WD0OUxU)
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]](https://www.youtube.com/watch?v=6OucJx6komQ)
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
Leave a Reply