Use Excel’s functions (not @RISK) to generate 1000 random numbers from a normal distribution with mean 100 and standard deviation 10. Then freeze these random numbers.  a.  Calculate the mean and...

Use Excel’s functions (not @RISK) to generate 1000 random numbers from a normal distribution with mean 100 and standard deviation 10. Then freeze these random numbers.


a.  Calculate the mean and standard deviation of these random numbers. Are they approximately what you would expect?


b.  Of these random numbers, what fraction is with k standard deviations of the mean? Answer for k= 1; for k =2; for k= 3. Are the answers close to what they should be (as you learned in your statistics course)?


c.  Create a histogram of the random numbers using 10 to 15 categories of your choice. Does this histogram have approximately the shape you would expect? (See the Appendix to this chapter for instructions on creating a histogram.)