Problem

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

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.

Step-by-Step Solution

Request Professional Solution

Request Solution!

We need at least 10 more requests to produce the solution.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the solution will be notified once they are available.
Add your Solution
Textbook Solutions and Answers Search
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT