Using and applying statistics

Skill Activities

We welcome feedback and contributions. If you have any comments, ideas or resources to offer please contact June Haighton.

Please note that resources added most recently are at the bottom of the page.

Athletics
Excel spreadsheet contains large datasets of track and field events. Teacher notes give suggestions for their use.

Teacher Notes: (application/msword, 47 KB) (application/pdf, 11 KB)
Spreadsheet: (application/vnd.ms-excel, 663 KB)

Box and Whisker Plots
Students can use this Excel spreadsheet to draw up to 4 box and whisker plots. Includes instructions. Contributed by Lindy McGuinness of Braintree College.

Spreadsheet (application/vnd.ms-excel, 37 KB)

Casio Calculators
Instructions for using a Casio fx83WA or fx85WA to find the mean, standard deviation, product moment correlation coefficient and regression line of y on x. Contributed by Kingston College.

Student Information (application/msword, 51 KB) (application/pdf, 89 KB)

Climate
Excel spreadsheet containing sunshine, rainfall and temperature data for England and Wales, Northern Ireland and Scotland for each month in every year from 1961.

Spreadsheet (application/vnd.ms-excel, 70 KB)

Correlation
Students find product moment correlation coefficients and draw scatter graphs. Contributed by Anne Mullice of St. Vincent College.

Student Information (application/msword, 38 KB) (application/pdf, 17 KB)
Spreadsheet (application/vnd.ms-excel, 17 KB)

Datasets
Data concerning road accidents, causes of mortality, marriage, divorce and food consumption in an Excel spreadsheet.

Spreadsheet (application/vnd.ms-excel, 690 KB)

DISCUSS Correlation & Regression
Simulations to aid understanding of correlation and regression. Internet access needed. Teacher Notes included.

Student Information (application/msword, 83 KB) (application/pdf, 41 KB)

DISCUSS Sampling
Simulations to aid understanding of how variation occurs within and between samples. Internet access needed. Teacher Notes included

Student Information (application/msword, 130 KB) (application/pdf, 74 KB)

Health Data
Data sets involving the health of adults and children in the UK and information about hospital waiting lists etc.

Teacher Notes (application/msword, 74 KB) (application/pdf, 26 KB)

Histogram
Instructions explaining how to construct an accurate histogram and frequency polygon in Excel. Contributed by Linda McGuinness of Braintree College.

Student Information (application/msword, 97 KB) (application/pdf, 35 KB)

Indicators of Child Well-being
Excel spreadsheet contains indicators of individual and social well-being of children in various countries. Teacher notes give suggestions for their use.

Teacher Notes: (application/msword, 41 KB) (application/pdf, 10 KB)
Spreadsheet (application/vnd.ms-excel, 41 KB)

Module Results
Students analyse and compare results for two modules. Includes use of Excel and Autograph as well as diagrams and calculations done by hand. Contributed by Anne Mullice of St. Vincent College.

Student Information (application/msword, 38 KB) (application/pdf, 19 KB)
Spreadsheet (application/vnd.ms-excel, 16 KB)

Pareto Charts
Combination of bar and cumulative frequency charts that are useful in economics, business and management. Data sheet and worksheet. Teacher Notes included

Student Information (application/msword, 332 KB) (application/pdf, 112 KB)

Subjects
Spreadsheet containing recent A level results in 13 subjects. Use for practice of spreadsheet skills or in an assignment.

Spreadsheet (application/vnd.ms-excel, 58 KB)

Trends
Excel spreadsheet containing large sets of data concerning marriages, household expenditure and deaths

Spreadsheet (application/vnd.ms-excel, 59 KB)

Pulse Rates
Experiment to find the effect of exercise on pulse rates. Spreadsheet gives results from such an experiment carried out over a number of years by Dr Richard Wilson at the University of Queensland. Teacher Notes included.

Student Information (application/msword, 90 KB) (application/pdf, 30 KB)
Spreadsheet (application/octet-stream, 24 KB)

Election results for Using and Applying statistics
Spreadsheet containing the 2001 and 2005 General Election Results. Use for practice of spreadsheet skills or in an assignment.

Excel spreadsheet (application/vnd.ms-excel, 279 KB)

Cumulative frequency graphs in Excel
Activity that shows students how to draw a cumulative frequency graph in Excel. Teacher notes included.

Student Information and Teacher notes: (application/msword, 621 KB) (application/pdf, 323 KB)