This sub-collection of resources from the Virtual Text Book collection contains seven resources designed for use on an interactive whiteboard to aid the teaching and learning of a variety of topics in ‘Statistics’. Each resource is an interactive excel worksheet to encourage teacher-student interaction. The topics covered are:

• Averages and Moving Averages
• Box and Whisker
• Correlation
• Cumulative Frequency
• Data Sets: Calculating an Estimate of the Mean
• Pie Charts
• Stem and Leaf

Resources

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...

Pie Charts

The first sheet of this excel file shows a frequency table for up to four different colours. Sometimes the angle 359⁰ or 361⁰ is shown in the table rather than 360⁰ and this can be used to aid discussion about rounding. Students need to calculate the angles so that a...

Stem and Leaf

This excel workbook shows how to construct a stem and leaf diagram. The first sheet has some raw data at the top and a blank stem and leaf diagram with appropriate key is shown below. The cells in the stem and leaf diagram can be revealed or hidden and by clicking on...

Pages

Published by

Actions

Share this resource