Skip main navigation

A spreadsheet model

Introducing a spreadsheet model for simulating experimental data.
A picture of the spreadsheet model used in this step
We can also use a spreadsheet to simulate experimental data.

Download the provided spreadsheet, ‘Simulation 1’. This has been set up to provide a simulation of the experiment that you have just carried out using a spinner.

Make sure that you can use the spreadsheet to generate a set of simulated experimental data.

The spreadsheet is provided in Microsoft Excel format, but can also be opened in other compatible packages (including Apple’s Numbers spreadsheet).

  • To generate a new set of data, force the spreadsheet to recalculate by pressing the function key F9.
  • This will not work in Apple Numbers. The easiest way to recalculate a Numbers spreadsheet is to format an empty cell as a check box. Checking or unchecking the checkbox will recalculate the sheet.

Can you see how the model works? Would you be able to adapt it for other activities?

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