Use the RAND function and the Copy command to generate a set of 100 random numbers. a.
Question:
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.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Question Posted: