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
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]
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]
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
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
