xlsx, 151.83 KB
xlsx, 151.83 KB

An Excel simulator does twenty samples each flipping a fair coin one hundred times. Each sample generates a confidence interval for the mean number of heads. On average, 19 out of the 20 confidence intervals will include the true mean of 50 heads,

This simulation can be run many times (by pressing F9) and each time a new graph visually updates, showing how confidence intervals work.

The number of flips and the probabilities can all be changed too.

Creative Commons "Sharealike"

Reviews

4.5

Something went wrong, please try again later.

alisontodd19

4 years ago
5

DaveGale

7 years ago
4

Students are often not clear what a confidence interval is all about. This resource helps show some understanding based around a familiar context.

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.