Finding patterns, trends and outliers

Tip: Choose Save as PDF in the print dialog to download. Use A4 paper size.

Finding patterns, trends and outliers

Name:
Date:
Class:

Quick Questions

Shade in the A or B circle for each question.

1. A class records the daily temperature for a week: 21, 22, 23, 25, 26. What trend does this data show?
A The temperature is going up
B The temperature is going down
2. Which value is the outlier in this list of ages: 10, 11, 10, 11, 42?
A 42
B 10
3. Scores in a spelling test: 6, 9, 7, 10, 8. Which is the highest score?
A 6
B 10
4. Which sentence correctly describes an outlier?
A The value that appears first in the table
B A value that is very different from the rest of the data
5. Class 5A read 40 books and Class 5B read 25 books. What can you say when comparing the groups?
A Class 5A read more books than Class 5B
B Class 5B read more books than Class 5A

Match the Pairs

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

Left columnRight column
1Sales: 5, 8, 12, 15 A=MIN(B2:B8)
2Ages: 10, 11, 10, 11, 45 B=MAX(B2:B8)
3Finding the highest value in a set of data CA trend going up, because each number is bigger than the one before
4Finding the lowest value in a set of data DThe number 45 is an outlier because it stands out from the rest
5Temps: 20, 22, 24, 26 - 'The trend is going down.' EThe numbers get bigger each time, so the trend is going up, not down.
6Class A average 8, Class B average 6 - 'Class B scored higher.' FClass A has the bigger average, so Class A scored higher when comparing the groups.

Definitions

pattern, trend, outlier

Fill in the Blanks

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

1.
Highest score: =___(B2:B8)
2.
Lowest score: =___(B2:B8)
3.
Data: 4, 5, 6, 5, 50 The number 50 is an _______
4.
Scores: 3, 5, 7, 9 The trend is going __
5.
Class A: =_______(B2:B8) Class B: =AVERAGE(C2:C8)

Spot the Error

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

Question 1
A scores = [4, 6, 5, 20, 5]
B highest = MAX(scores)
C lowest = MIN(scores)
D outlier = 4
Question 2
A temps = [20, 22, 24, 26]
B trend = 'going down'
C print(trend)
Question 3
A class_a = [5, 6, 7]
B avg_a = MAX(class_a)
C class_b = [8, 9, 7]
D avg_b = AVERAGE(class_b)
Question 4
A rain = [10, 12, 9, 11]
B wettest = MAX(rain)
C driest = MIN(rain)
D gap = wettest + driest
Question 5
A scores = [8, 9, 7, 3, 8]
B outlier = 30
C print(outlier)

Answer Key

Finding patterns, trends and outliers
Section A: Quick Questions
Q1
A — The temperature is going up
Q2
A — 42
Q3
B — 10
Q4
B — A value that is very different from the rest of the data
Q5
A — Class 5A read more books than Class 5B
Section B: Match the Pairs
Q1
Sales: 5, 8, 12, 15 → A trend going up, because each number is bigger than the one before
Q2
Ages: 10, 11, 10, 11, 45 → The number 45 is an outlier because it stands out from the rest
Q3
Finding the highest value in a set of data → =MAX(B2:B8)
Q4
Finding the lowest value in a set of data → =MIN(B2:B8)
Q5
Temps: 20, 22, 24, 26 - 'The trend is going down.' → The numbers get bigger each time, so the trend is going up, not down.
Q6
Class A average 8, Class B average 6 - 'Class B scored higher.' → Class A has the bigger average, so Class A scored higher when comparing the groups.
Section C: Definitions
Q1
pattern, trend, outlier — Look for patterns and trends in data, like highest, lowest, going up or down. An outlier is a value that stands out from the rest. Compare groups to see differences.
Section D: Fill in the Blanks
Q1
Highest score: =MAX(B2:B8)
Q2
Lowest score: =MIN(B2:B8)
Q3
Data: 4, 5, 6, 5, 50 The number 50 is an outlier
Q4
Scores: 3, 5, 7, 9 The trend is going up
Q5
Class A: =AVERAGE(B2:B8) Class B: =AVERAGE(C2:C8)
Section E: Spot the Error
Q1
D — The outlier is the value that stands out from the rest. In this list that is 20, not 4. It should be outlier = 20.
Q2
B — The temperatures get bigger each time, so the trend is going up. It should be trend = 'going up'.
Q3
B — To compare groups fairly, both groups must be measured the same way. avg_b uses AVERAGE, so avg_a should be AVERAGE(class_a).
Q4
D — The gap between the highest and lowest values is found by subtracting. It should be gap = wettest - driest.
Q5
A — The outlier is 30, but the list no longer contains 30, so nothing stands out. The list should include 30: [8, 9, 7, 30, 8].