(a) Enter the Excel function =ROUND(NORMINV(RAND(),70,10),0) in cells B1:B100. This will create 100 random data points from...

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 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?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: