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

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