(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 calc...

Assuming that the steps in a have been followed and the random data points have been generated in ce ...

(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.

(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!