Your investigation
- Choose a spinner, die or card deck in the setup drawer. Give spinner sectors or die faces labels, colours and weights; for cards, choose suits, ranks, draw method and result grouping.
- Start an investigation and write a prediction before collecting trials.
- Run two batches. Keep every valid outcome, even when it surprises you.
- Compare the graph with your prediction. Export raw trials and the summary to Excel.
A weight of 2 makes an entry twice as likely as an entry with weight 1. Repeated labels combine into one outcome. For a fair die, keep all face weights equal. You can deliberately build a weighted die and explain how it differs.
Work is saved in this browser where storage is available. Download a backup before closing or changing devices. No names are needed. Clear this browser’s work after exporting on a shared device.
2 Predict and test
PRACTICEStart an investigation to collect trials.
3 Compare and explain
| Outcome | Chance | Run 1 | Run 2 | Total | Expected total |
|---|
Every recorded trial
| Trial | Run | Trial in run | Outcome | Time | Exact card |
|---|
Expected counts describe the device’s probabilities. They are not targets your results must match. A short run can vary considerably.
Use your results in Excel
- Download Raw trials for Excel and Summary for Excel.
- Open the CSV files in Excel. If labels such as 01 change, use Data → From Text/CSV and set the outcome column to Text.
- Save as an Excel Workbook (.xlsx). Keep the original downloaded records.
- Use the outcome and observed-total columns to create a column chart. Label both axes and compare Run 1 with Run 2.
When your teacher asks you to calculate totals yourself, use the raw file and write your own COUNTIF or COUNTIFS formulas. The summary file is a check after your own work.