Skip main navigation
We use cookies to give you a better experience, if that’s ok you can close this message and carry on browsing. For more info read our cookies policy.
We use cookies to give you a better experience. Carry on browsing if you're happy with this, or read our cookies policy for more information.
A screenshot of the spreadsheet 'Simulation 2'
We can use a spreadsheet to simulate the results of the experiment

Spreadsheet models for conditional probability

Download the supplied spreadsheet, ‘Simulation 2’. This shows how we can use a spreadsheet to simulate the results of ‘The dog ate my homework’.

Notice that the downloaded spreadsheet is set up with the probabilities incorporated into the spinners we used in the previous step - but these can be adjusted by changing the values in the range E14:E16.

Experiment with the spreadsheet. Use the Function key F9 to generate a new set of randomised results (if F9 does not work, typing a value into any blank cell and then moving to another cell should cause the spreadsheet to recalculate; and for users of Excel on Mac, hold down the Command key and press =).

Use the comments to share your experiences.

Share this article:

This article is from the free online course:

Teaching Probability

Cambridge University Press

Contact FutureLearn for Support