# Question

Use the RAND function and the Copy command to generate a set of 100 random numbers.

a. What fraction of the random numbers are smaller than 0.5?

b. What fraction of the time is a random number less than 0.5 followed by a random number greater than 0.5?

c. What fraction of the random numbers are larger than 0.8?

d. Freeze these random numbers. However, instead of pasting them over the original random numbers, paste them onto a new range. Then press the F9 recalculate key. The original random numbers should change, but the pasted copy should remain the same.

a. What fraction of the random numbers are smaller than 0.5?

b. What fraction of the time is a random number less than 0.5 followed by a random number greater than 0.5?

c. What fraction of the random numbers are larger than 0.8?

d. Freeze these random numbers. However, instead of pasting them over the original random numbers, paste them onto a new range. Then press the F9 recalculate key. The original random numbers should change, but the pasted copy should remain the same.

## Answer to relevant Questions

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 ...Use @RISK to draw a triangular distribution with parameters 200, 300, and 600. Then superimpose a normal distribution on this drawing, choosing the mean and standard deviation to match those from the triangular distribution. ...A sweatshirt supplier is trying to decide how many sweatshirts to print for the upcoming NCAA basketball championships. The final four teams have emerged from the quarterfinal round, and there is now a week left until the ...The Fizzy Company produces six-packs of soda cans. Each can is supposed to contain at least 12 ounces of soda. If the total weight in a six-pack is less than 72 ounces, Fizzy is fined $100 and receives no sales revenue for ...A new edition of a very popular textbook will be published a year from now. The publisher currently has 2000 copies on hand and is deciding whether to do another printing before the new edition comes out. The publisher ...Post your question

0