- View more resources from this publisherThe Virtual Textbook
Data Sets: Calculating an Estimate of the Mean
The first sheet of this excel file shows the number of passengers per flight from London to Paris. The raw data is shown in a grouped frequency table and the midpoint of each group can be revealed as well as each stage in the calculation of the estimate of the mean. The next two sheets each show two sets of data which are dealt with in the same manner so that the calculated estimates of the mean can be compared. There are seven more sheets of questions which may be suitable for use in the classroom.
Note: this program was designed by be viewed on a screen with a resolution of 1024 x 768. Users may have to adjust the resolution of their screen for the pages to display as was originally intended. The program uses macros which need to be enabled on users' machines.
Show health and safety information
Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.