New
New
Year 10
Higher
Statistical summaries using technology
I can use technology to effectively summarise and represent data.
New
New
Year 10
Higher
Statistical summaries using technology
I can use technology to effectively summarise and represent data.
These resources will be removed by end of Summer Term 2025.
Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.
Lesson details
Key learning points
- Technology can be used to calculate numerical summary statistics.
- Technology can be used to create visual representations of data.
- It is important to select appropriate representations and summaries based on context and the type of data.
Keywords
Statistical summary - A statistical summary sums up the features of a data set.
Common misconception
Spreadsheets should always be used for data analysis as they are perfect.
Spreadsheet software is incredibly powerful but care should be taken as human error can lead to incorrect results.
This lesson requires pupils to use a device that can access the internet. They will be using sets of data provided. The data can be downloaded before the lesson and saved locally if preferred.
Teacher tip
Licence
This content is © Oak National Academy Limited (2024), licensed on Open Government Licence version 3.0 except where otherwise stated. See Oak's terms & conditions (Collection 2).
Lesson video
Loading...
Starter quiz
Download starter quiz
6 Questions
Q1.
A __________ is a circular graph where sectors represent different groups proportionally.
bar chart
pictogram
scatter graph
time series graph
Q2.
Find the mode of the following numbers: 15, 13, 20, 15, 17, 16.
Q3.
Find the median of the following numbers: 15, 13, 20, 15, 17, 16.
Q4.
Find the range of the following numbers: 15, 13, 20, 15, 17, 16.
Q5.
Find the mean of the following numbers: 15, 13, 20, 15, 17, 16.
Q6.
An estimate for the mean of the data presented in the table is kilograms.
Exit quiz
Download exit quiz
6 Questions
Q1.
A __________ sums up the features of a data set.
data cycle
graph
sample
Q2.
When using spreadsheet software, which command would calculate the mean for a column of numerical data?
average(A1:A10)
mean(A1:A10)
=mean(A1:A10)
Q3.
When using spreadsheet software, which command would calculate the range for a column of numerical data?
max(A1:A10)-min(A1:A10)
range(A1:A10)
=range(A1:A10)
Q4.
When using spreadsheet software, which command would calculate the median for a column of numerical data?
median(A1:A10)
middle(A1:A10)
=middle(A1:A10)
Q5.
When using spreadsheet software, what symbol represents multiplication?
Q6.
When using spreadsheet software, what symbol represents division?