Skip main navigation

Spreadsheet models for conditional probability

An article to introduce a simple spreadsheet model for the task 'The dog ate my homework!'
A screenshot of the spreadsheet 'Simulation 2'
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.

This article is from the free online

Teaching Probability

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education