Scatter graphs

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. Which data is best shown on a scatter graph?

A Favourite pizza topping for 30 students

B Hours of sleep and test score for 30 students

2. In a scatter graph, what does each point stand for?

A One record, such as one student

B One whole column of data

3. A scatter graph shows points rising from bottom left to top right. What kind of relationship is this?

A Negative relationship

B Positive relationship

4. The more hours a student spends on their phone, the fewer hours they sleep. The points slope down from left to right. What relationship is this?

A Negative relationship

B Positive relationship

5. The points on a scatter graph are spread all over with no clear direction. What does this show?

A No relationship

B A strong positive relationship

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Insert > Scatter chart		APoints slope downwards: more hours of screen time, lower fitness score
2x axis = Hours of study, y axis = Test score		BPoints slope upwards: more hours of sleep, higher test score
3Positive relationship: as one value goes up, the other value goes up too		CA scatter graph needs two number columns. Names are text, so they cannot be plotted on an axis.
4Negative relationship: as one value goes up, the other goes down		DPoints with no pattern show no relationship, not a strong positive one.
5Select one column of names and one of scores, then Insert > Scatter chart		EThe menu steps that turn two selected number columns into a scatter graph
6The points are scattered all over the graph, so there is a strong positive relationship		FEach point is placed across by hours studied and up by test score

Definitions

scatter graph

Fill in the Blanks

Complete each line of code by filling in the missing parts.

Insert > _______ chart

The _ axis runs up the side of the graph

Points rise to the right: ________ relationship

Points fall to the right: ________ relationship

Points scattered with no pattern: __ relationship

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Columns: Height, Shoe size

B Select both columns

C Go to the Insert menu

D Choose Pie chart

Question 2

A x axis: Hours studied

B y axis: Test score

C Points rise = negative

Question 3

A Select two text columns

B Insert > Scatter chart

C Each row becomes one point

Question 4

A x axis: Age of phone (years)

B y axis: Phone brand

C Relationship: negative

Question 5

A Chart: Shoe size vs Maths mark

B Points rise in a neat line

C Relationship: none

Answer Key

Scatter graphs

Section A: Quick Questions

B — Hours of sleep and test score for 30 students

A — One record, such as one student

B — Positive relationship

A — Negative relationship

A — No relationship

Section B: Match the Pairs

Insert > Scatter chart → The menu steps that turn two selected number columns into a scatter graph

x axis = Hours of study, y axis = Test score → Each point is placed across by hours studied and up by test score

Positive relationship: as one value goes up, the other value goes up too → Points slope upwards: more hours of sleep, higher test score

Negative relationship: as one value goes up, the other goes down → Points slope downwards: more hours of screen time, lower fitness score

Select one column of names and one of scores, then Insert > Scatter chart → A scatter graph needs two number columns. Names are text, so they cannot be plotted on an axis.

The points are scattered all over the graph, so there is a strong positive relationship → Points with no pattern show no relationship, not a strong positive one.

Section C: Definitions

scatter graph — A chart that plots each record as a point using two number columns, one on the x axis and one on the y axis, to show whether two things are related.

Section D: Fill in the Blanks

Insert > Scatter chart

The y axis runs up the side of the graph

Points rise to the right: positive
 relationship

Points fall to the right: negative
 relationship

Points scattered with no pattern: no
 relationship

Section E: Spot the Error

D — A scatter graph is needed to show if two number columns are related. A pie chart cannot do this. It should say: Choose Scatter chart.

C — When the points go up as x goes up, the relationship is positive, not negative. It should say: Points rise = positive.

A — A scatter graph plots numbers on both axes, so you must select two number columns, not text columns.

B — The y axis must be a number column. A brand is text and cannot be plotted. It should say: y axis: Price ($).

B — A neat rising line would show a positive relationship. For no relationship the points are spread out randomly.