Question

NARRBEGIN: SA_65_70
Generate a set of 40 random numbers in a column in an Excel spreadsheet by using RAND function. Fix the set of random numbers by copying the column to another column and using the "Paste Special" command with the "Values" option selected.
NARREND
(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 another random number less than 0.5?
(C) What fraction of the random numbers are larger than 0.8?
(D) What do you expect the answers to (A), (B) and (C) to be before simulating? Do the answers you provided to those questions match your expectations? Explain why or why not.
(E) Suppose your answers to (A), (B) and (C) are not close to the expected answers. What can you do to obtain answers from the simulation that are closer to the expected answers?

Answer

This answer is hidden. It contains 529 characters.