Please use the Palisade Decision Tools Excel software (as well as step by step)

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

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

b. What fraction of these random numbers are within 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 (about 68% for k = 1, about95% for k = 2, and over 99% for k = 3)?

c. Make a histogram of the random numbers using about 10 bins of your choice. Does this histogram have approximately the shape you would expect?