Probability: Biased Coins

Rate this resource

This excel program illustrates the effect of introducing bias when throwing coins.

The first interactive excel sheet simulates the outcome of throwing a coin ten times. The probability of each outcome is plotted and shown in a table, alongside the cumulative probability. The probability of obtaining a head can be altered, and the effect this has on the probability distribution can be seen.

The second sheet repeats this process, this time for twenty throws of the coin. Again the probability of obtaining heads can be adjusted.

The file also includes three worksheets to be printed off and completed by students. Topics include: Probability of biased events and relative frequency. No solutions are included.

This program was designed by be viewed on a screen with a resolution of 1024 x 768. Users may have to adjust the resolution of their screen for the pages to display as was originally intended. The program uses macros which need to be enabled on users’ machine.

Show health and safety information

Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.

Published by


Share this resource