# Question: Use Excel s functions not RISK to generate 1000 random numbers

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

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?

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?

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?

**View Solution:**## Answer to relevant Questions

Use @RISK to draw a uniform distribution from 400 to 750. Then answer the following questions.a. What are the mean and standard deviation of this distribution?b. What are the 5th and 95th percentiles of this distribution?c. ...We all hate to keep track of small change. By using random numbers, it is possible to eliminate the need for change and give the store and the customer a fair deal. This problem indicates how it could be done.a. Suppose that ...In the Walton Bookstore example with a discrete demand distribution, explain why an order quantity other than one of the possible demands cannot maximize the expected profit. When you use @RISK’s correlation feature to generate correlated random numbers, how can you verify that they are correlated? Try the following. Use the RISKCORRMAT function to generate two normally distributed random ...A hardware company sells a lot of low-cost, high volume products. For one such product, it is equally likely that annual unit sales will be low or high. If sales are low (60,000), the company can sell the product for $10 per ...Post your question