Population Mean Confidence Interval Creator and Generator

This excel document will automatically calculator a confidence interval from a set of inputted listed data (Upto 64 items)

The document will calculate an estimate for the population mean based on the sample mean. Users must simply input their own data and select a confidence level.

The spreadsheet then calculates the upper and lower bound as well as clearly identifying other values such as variance and standard deviation as well as identifying stages of working out.

As well as detailed answers a mark scheme suitable for AQA Mathematical Studies AQA Core Maths is automatically generated.

It is incredibly useful for creating your own questions and answers without needing to perform your own time consuming hand calcualtions. It also allows you to quickly adapt sample data in order to generate questions which fit your requirements or easily create extension questions such as given the confidence interval calculate the missing value for N or standard deviation