Probability Experiment Spreadsheet

Probability Simulation with Coins & Dice – Interactive Excel (Macro-Enabled)

Product Description:

This interactive, macro-enabled Excel spreadsheet is a powerful tool for teaching probability and chance. Ideal for use at Key Stage 2 and Key Stage 3, this resource helps pupils explore both theoretical and experimental probability through coin and dice simulations.

See it in action by clicking video link - https://youtu.be/50k5-U17WkA

What’s Included:

The spreadsheet includes 6 fully interactive simulation sheets:

• 1 Coin – Flip a single coin multiple times

• 2 Coins – Explore compound outcomes

• 3 Coins – Observe growing combinations

• 1 Coin & 1 Die – Mixed outcomes from two different objects

• 1 Die – Roll a standard die and track frequencies

• 2 Dice – Investigate the distribution of outcomes and sums

Each sheet allows you to choose the number of trials, displays all raw data (if desired), and generates frequency tables and graphs automatically.

Why Teachers Love It:

• Easily adjust the number of trials
• Instant data visualisation with tables and bar graphs
• Safe and secure – all actions are controlled via VBA buttons, no risk of deleting formulas
• Perfect for live demonstrations on interactive whiteboards or projectors
• Editable design: Customise font, colour, or size for your needs
• Helps illustrate the difference between theoretical and experimental outcomes

Suggested Uses:

Whole-class lessons

Investigations or group projects

Homework data generation

SEN support for visual learners

Assessment practice

Important Notes:

This is a macro-enabled Excel file (.xlsm) and must be opened on a device that allows VBA macro functionality.
This resource will not work on iPads or cloud-based spreadsheet viewers.

File Type: Excel Spreadsheet (.xlsm)
Suitable for: KS2, KS3, SEN, Maths Interventions, Investigative 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