Range as MAX minus MIN
Name:
Date:
Class:
A
Quick Questions
Shade in the A or B circle for each question.
1. Which formula finds the range of the values in B2:B30?
2. Maths marks are 52, 65, 77, 88 and 95. What is the range?
3. What does the range of a data set tell you?
4. Daily rain is 0, 2, 0, 14, 22, 5, 0 mm. Which statement is true?
5. A class has marks mostly between 60 and 75, then one student scores 5. What happens to the range?
B
Match the Pairs
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 1=MAX(B2:B30)-MIN(B2:B30) | AMIN and MAX are the wrong way round. Subtracting the largest from the smallest gives a negative number. The range must be MAX minus MIN. | |
| 2=MAX(C2:C9)-MIN(C2:C9) | BGives the spread between the highest and lowest values in C2:C9 | |
| 3Range is a measure of spread: how far apart the biggest and smallest values are | CCalculates the range of the data: the largest value minus the smallest value in B2:B30 | |
| 4For the Maths marks (49 to 95), the range is 46 because 95 - 49 = 46 | D=MAX(B2:B9)-MIN(B2:B9) | |
| 5=MIN(B2:B9)-MAX(B2:B9) | EThe formula adds MAX and MIN instead of subtracting. Adding gives a total, not the spread of the data. | |
| 6=MAX(B2:B9)+MIN(B2:B9) | F=MAX(B2:B9)-MIN(B2:B9) |
C
Definitions
=MAX(B2:B30)-MIN(B2:B30)
D
Fill in the Blanks
Complete each line of code by filling in the missing parts.
1.
=___(B2:B30)-MIN(B2:B30)
2.
=MAX(B2:B30)_MIN(B2:B30)
3.
=MAX(D2:D8)-___(D2:D8)
4.
=MAX(C2:C9)-MIN(_____)
5.
_MAX(B2:B30)-MIN(B2:B30)
E
Spot the Error
Shade in the letter of the line that contains an error.
Question 1
A
E1: =MAX(B2:B9)
B
E2: =MIN(B2:B9)
C
E3: =E2-E1
Question 2
A
Range of Maths marks
B
Max is 95, min is 49
C
Range = 95 - 49
D
Range = 144
Question 3
A
F2: =MAX(C2:C9)+MIN(C2:C9)
B
Max English 89, min 58
C
Range is 89 - 58 = 31
Question 4
A
Weather: daily max temps
B
=MAX(B2:B8)-MAX(B2:B8)
C
Highest 31, lowest 19
D
Range is 12 degrees
Question 5
A
Marks: 70, 72, 75, 74, 73
B
Range is 75 - 70 = 5
C
Add 20: range stays at 5
D
One outlier stretches range
Answer Key
Range as MAX minus MIN
Section A: Quick Questions
Q1
A — =MAX(B2:B30)-MIN(B2:B30)
Q2
A — 43
Q3
B — How spread out the values are
Q4
B — The range is 22 mm
Q5
A — It gets much larger because of the outlier
Section B: Match the Pairs
Q1
=MAX(B2:B30)-MIN(B2:B30) → Calculates the range of the data: the largest value minus the smallest value in B2:B30
Q2
=MAX(C2:C9)-MIN(C2:C9) → Gives the spread between the highest and lowest values in C2:C9
Q3
Range is a measure of spread: how far apart the biggest and smallest values are → =MAX(B2:B9)-MIN(B2:B9)
Q4
For the Maths marks (49 to 95), the range is 46 because 95 - 49 = 46 → =MAX(B2:B9)-MIN(B2:B9)
Q5
=MIN(B2:B9)-MAX(B2:B9) → MIN and MAX are the wrong way round. Subtracting the largest from the smallest gives a negative number. The range must be MAX minus MIN.
Q6
=MAX(B2:B9)+MIN(B2:B9) → The formula adds MAX and MIN instead of subtracting. Adding gives a total, not the spread of the data.
Section C: Definitions
Q1
=MAX(B2:B30)-MIN(B2:B30) — Range is the largest value minus the smallest. It shows how spread out data is, but one outlier can stretch it. Not the same as a cell range like B2:B30.Section D: Fill in the Blanks
Q1
=MAX(B2:B30)-MIN(B2:B30)Q2
=MAX(B2:B30)-MIN(B2:B30)Q3
=MAX(D2:D8)-MIN(D2:D8)Q4
=MAX(C2:C9)-MIN(C2:C9)Q5
=MAX(B2:B30)-MIN(B2:B30)Section E: Spot the Error
Q1
C — Range is the largest value minus the smallest. E2-E1 is MIN minus MAX, which gives a negative number (-46). It should be =E1-E2.
Q2
D — The range is 95 - 49 = 46. Adding the two values gives 144, which is not the spread. Line 4 should read Range = 46.
Q3
A — Range subtracts the smallest value from the largest. The + adds them (147). It should be =MAX(C2:C9)-MIN(C2:C9).
Q4
B — Subtracting MAX from MAX always gives 0. The formula needs MIN for the smallest value: =MAX(B2:B8)-MIN(B2:B8).
Q5
C — Adding an outlier of 20 makes the smallest value 20, so the range becomes 75 - 20 = 55. The range does not stay at 5, because it is affected by outliers.