10.1 Simulating a Coin Tossing Experiment

To simulate the experiment, assign to the outcome Head the digit 1 and to Tail the digit 2.

You will draw a random sample of size 30 in Column A from the distributions of integers with a minimum value of 1 to a maximum value of 2.

1. Write the label Coin Toss in cell A1.
2. Type the formula = RANDBETWEEN(1,2) in cell A2 and press Enter/Return.
3. Select cell A2 again, position the mouse pointer in the lower right corner of the selected cell until it becomes a + sign, and click-drag downward across until cell A31.
4. Ensure that Excel randomizes all the values by going to the Formula tab in the menu bar and clicking the Calculate Now ribbon to apply the randomization. Column A should now have 30 random values.