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.

Lesson details

Key learning points

  1. Technology can be used to calculate numerical summary statistics.
  2. Technology can be used to create visual representations of data.
  3. It is important to select appropriate representations and summaries based on context and the type of data.

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.

Keywords

  • Statistical summary - A statistical summary sums up the features of a data set.

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

Loading...

6 Questions

Q1.
A __________ is a circular graph where sectors represent different groups proportionally.
bar chart
pictogram
Correct answer: pie chart
scatter graph
time series graph
Q2.
Find the mode of the following numbers: 15, 13, 20, 15, 17, 16.
Correct Answer: 15, Fifteen
Q3.
Find the median of the following numbers: 15, 13, 20, 15, 17, 16.
Correct Answer: 15.5, Fifteen point five
Q4.
Find the range of the following numbers: 15, 13, 20, 15, 17, 16.
Correct Answer: 7, seven
Q5.
Find the mean of the following numbers: 15, 13, 20, 15, 17, 16.
Correct Answer: 16, sixteen
Q6.
An estimate for the mean of the data presented in the table is kilograms.
An image in a quiz
Correct Answer: 28, twenty eight

6 Questions

Q1.
A __________ sums up the features of a data set.
data cycle
graph
sample
Correct answer: statistical summary
Q2.
When using spreadsheet software, which command would calculate the mean for a column of numerical data?
average(A1:A10)
mean(A1:A10)
Correct answer: =average(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)
Correct answer: =max(A1:A10)-min(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)
Correct answer: =median(A1:A10)
=middle(A1:A10)
Q5.
When using spreadsheet software, what symbol represents multiplication?
Correct Answer: *, asterisk
Q6.
When using spreadsheet software, what symbol represents division?
Correct Answer: /, slash, forward slash