Probability Experiment Spreadsheet

Probability Experiments

This Excel file can be used for any class learning about probability or chance. There are 6 different sheets – 1 Coin, 2 Coins, 3 Coins, 1 Coin and 1 Die, 1 Die and 2 Dice. Each sheet has the option of choosing how many trials are done, it then completes the trials (showing all raw data if you want to use this) and displays the frequency of each event / combination in a table and a graph.

There are no formulas to accidentally delete as the spreadsheet has embedded Macros (VBA) for each of the buttons you press and can be used without access to the internet.

The spreadsheet can be used to show students how random events do not perfectly match theoretical probability (it can approximate it as the number of trials increases). It can also be used to collect data for answering questions on assignments or classwork. You can change the font, colour or size of the text on the pages before use on a data projector or interactive whiteboard or screen.

This file will only run on devices that can allow Macro enabled spreadsheets to function (sadly that means that Ipads are not going to allow these sheets to work).

#Probability #Probability experiments #Chance #Chance Experiments #Coin Flip #2 Coin Flip #3 Coin Flip #Coin and Die #Coin and Dice #1 Die Roll #1 Dice Roll #2 Dice Roll