(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(B1 :B100) to calculate the sample mean and standard deviation for your data array (c) Every time you press F9 you will get a new sample. Press F9 five times and 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? (e) Use Excel's = MIN(B1 :B100) and = MAX(B1:B100) to find the range of your samples. Do the sample ranges look as you would expect from the Empirical Rule?
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.