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.
Reach your personal and professional goals
Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.
Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.
