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

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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Data Analysis and Decision Making

ISBN: 978-0538476126

4th edition

Authors: Christian Albright, Wayne Winston, Christopher Zappe

Question Posted: