New

New

Year 10

Foundation

# Statistical summaries using technology

I can use technology to effectively summarise and represent data.

New

New

Year 10

Foundation

# Statistical summaries using technology

I can use technology to effectively summarise and represent data.

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

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

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