List 5 grades each between 50-100, find the mean rounded to the hundredths and s
ID: 3354722 • Letter: L
Question
List 5 grades each between 50-100, find the mean rounded to the hundredths and sample standard deviation rounded to the hundredths and then use this formula to find the z score. z=(x-xbar)/s where xbar is the mean and s is the sample standard deviation. Round z to 2 places. Let x =82. What is the z score? Now find < z which is the area by typing this in an excel cell =norm.s.dist( z score, true) and hit enter. Note put the value z in for z. Or you can look up z in a standard normal chart in your book. You will list the 5 number. Give the average and standard deviation. Give the z score and the area. You can tell a little about what you did.
Explanation / Answer
Ans:
Area=P(Z<=z)=normsdist(z)
x z area 1 58 -1.20 0.1147 2 65 -0.71 0.2397 3 74 -0.07 0.4718 4 86 0.78 0.7817 5 92 1.20 0.8853 Average= 75 std. dev,s= 14.142Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.