Question: (a) Enter the Excel function =ROUND(NORMINV(RAND(),70,10),0) in cells B1:B100. This will create 100 random data points from a normal distribution using parameters = 70
(a) Enter the Excel function =ROUND(NORMINV(RAND(),70,10),0) in cells B1:B100. This will create 100 random data points from a normal distribution using parameters μ = 70 and σ = 10. Think of these numbers as exam scores for 100 students.
(b) Use the Excel functions =AVERAGE(B1:B100) and =STDEV.S(B1:B100) to calculate the sample mean and standard deviation for your data array.
(c) Write down the sample mean and standard deviation.
(d) Compare the sample statistics with the desired parameters μ = 70 and σ = 10. Do Excel’s random samples have approximately the desired characteristics?
Step by Step Solution
3.52 Rating (149 Votes )
There are 3 Steps involved in it
Assuming that the steps in a have been followed and the random data points have been generated in ce... View full answer
Get step-by-step solutions from verified subject matter experts
Study Help