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.

# Interactive Data Resources

This resource from SMILE contains eight interactive spreadsheets as described below:

Rolling one dice: simulates the rolling of one dice and then records the number in the frequency table and simultaneously in the bar graph

The difference when rolling two dice: simulates the rolling of two dice and then recording the difference of the two numbers in a frequency table and simultaneously in the bar graph

The sum when rolling two dice: simulates the rolling of two dice and then records the sum of the two numbers in the frequency table and simultaneously in the bar graph

Using an assumed mean: demonstrates how an assumed mean can be used to calculate the mean height of five students

Calculating the mean from a frequency table: demonstrates how to calculate the mean of up to seven numbers from data in a frequency table. The values can be any set of consecutive numbers with the first number between 0 and 10

Calculating the mean: demonstrates how to calculate the mean of up to seven numbers. The value of each number can be any integer between 1 and 10. The calculation of each set of numbers is displayed. If the calculation involves decimals, these are initially displayed correct to 10 decimal places and then rounded to two decimal places

Calculating the median and range: demonstrates how to calculate the median and range of up to seven numbers. The value of each number can be an integer between 1 and 10

Calculating the mode: demonstrates how to calculate the mode of up to 10 numbers. The value of each number can be an integer between 1 and 7.

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