- View more resources from this publisher
The Virtual Textbook
Tooltip
These resources have been reviewed and selected by STEM Learning’s team of education specialists for factual accuracy and relevance to teaching STEM subjects in UK schools.
Frequency Tables and Quantiles
This excel resource contains a series of interactive sheets exploring frequency tables and quartiles.
The first sheet calculates the mean from a frequency table. The second calculates an estimate for the mean from a grouped frequency table. New examples for both sheets can be generated at the click of a button.
The third interactive sheet demonstrates how linear coding can be used to calculate an estimate of the mean from a table. The assumed mean and divisor used can be altered to demonstrate the effect on the calculation.
The next sheet calculates the quartiles for a skewed set of grouped data using a cumulative frequency table.
In a similar way the next two sheets calculate the deciles, and then percentiles, for a set of grouped data.
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’ machine.
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.
Downloads
Show downloads
-
Frequency tables and quantiles 745.5 KB
Information on the permitted use of this resource is covered by the Category Three Content section in STEM Learning’s Terms and conditions.
