Management

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

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