An Excel spreadsheet can be made to generate random integers between certain limits. To make the spreadsheet

Question:

An Excel spreadsheet can be made to generate random integers between certain limits. To make the spreadsheet simulate the rolling of an ordinary dice, generating random integers between 1 and 6 will be needed.

a. In cell A1 type ‘=RANDBETWEEN(1,6)’ and then press return. Copy the formula down to cell A12. This will generate 12 random numbers in cells A1 to A12.

b. (i) If the random number generator is truly random, what is the theoretical probability of getting each number between 1 and 6?

(ii) How many of each number would you expect to get?

c. Draw a tally and frequency table of the results.

d. How do the random number generator results compare with the expected results?

e. Copy the formula down to cell A1000; this will generate 1000 random numbers in cells A1 to A1000. Using ‘=COUNTIF(RANGE,VALUE)’ count how many times each number appears in the cells and enter your results in a frequency table.