Range of a data set
Name:
Date:
Class:
A
Quick Questions
Shade in the A or B circle for each question.
1. Which formula correctly finds the range of the values in B2:B30?
2. A set of marks has a highest mark of 95 and a lowest mark of 49. What is the range?
3. What does the range tell you about a data set?
4. Using the weather sheet, Max temperatures are in B2:B8 (lowest 19, highest 31). Which formula gives the range of Max temperatures?
5. Most students scored between 60 and 80, but one student scored 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:B9)-MIN(B2:B9) | AFinds the range of the values in B2:B9 by subtracting the smallest value from the largest value | |
| 2=MAX(D2:D8)-MIN(D2:D8) | B=MAX(B2:B8)-MIN(B2:B8) | |
| 3The range of the Maths marks is the highest mark minus the lowest mark | CThe formula adds the values instead of subtracting. This gives the sum of the highest and lowest values, not the range. | |
| 4The range of the daily maximum temperatures is the hottest day minus the coolest of the maximums | D=MAX(B2:B9)-MIN(B2:B9) | |
| 5=MIN(B2:B9)-MAX(B2:B9) | EShows how spread out the values in D2:D8 are, from the lowest to the highest | |
| 6=MAX(B2:B9)+MIN(B2:B9) | FMIN and MAX are the wrong way round. This subtracts the largest value from the smallest, so the range comes out negative. |
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(C2:C9)-___(C2:C9)
4.
=MAX(B2:B8)-MIN(_____)
5.
=MAX(_____)-MIN(B2:B9)
E
Spot the Error
Shade in the letter of the line that contains an error.
Question 1
A
E2: =MAX(B2:B30)
B
E3: =MAX(B2:B30)
C
E4: =E2-E3
Question 2
A
=MIN(C2:C9)-MAX(C2:C9)
B
Range = highest - lowest
C
Bigger range = more spread
Question 3
A
highest ← MAX(marks)
B
lowest ← AVERAGE(marks)
C
range ← highest - lowest
Question 4
A
Marks: 40, 55, 60, 95
B
Highest = 95
C
Lowest = 40
D
Range = 95 + 40 = 55
Question 5
A
Set A: 50, 52, 55, 58
B
Set B: 50, 52, 55, 158
C
Range of B = 158 - 50 = 98
D
An outlier makes range bigger
Answer Key
Range of a data set
Section A: Quick Questions
Q1
A — =MAX(B2:B30)-MIN(B2:B30)
Q2
A — 46
Q3
B — How spread out the values are
Q4
B — =MAX(B2:B8)-MIN(B2:B8)
Q5
A — It gets much bigger because of the outlier
Section B: Match the Pairs
Q1
=MAX(B2:B9)-MIN(B2:B9) → Finds the range of the values in B2:B9 by subtracting the smallest value from the largest value
Q2
=MAX(D2:D8)-MIN(D2:D8) → Shows how spread out the values in D2:D8 are, from the lowest to the highest
Q3
The range of the Maths marks is the highest mark minus the lowest mark → =MAX(B2:B9)-MIN(B2:B9)
Q4
The range of the daily maximum temperatures is the hottest day minus the coolest of the maximums → =MAX(B2:B8)-MIN(B2:B8)
Q5
=MIN(B2:B9)-MAX(B2:B9) → MIN and MAX are the wrong way round. This subtracts the largest value from the smallest, so the range comes out negative.
Q6
=MAX(B2:B9)+MIN(B2:B9) → The formula adds the values instead of subtracting. This gives the sum of the highest and lowest values, not the range.
Section C: Definitions
Q1
=MAX(B2:B30)-MIN(B2:B30) — The range is the largest value minus the smallest value. It measures spread, and one outlier can make it much bigger.Section D: Fill in the Blanks
Q1
=MAX(B2:B30)-MIN(B2:B30)Q2
=MAX(B2:B30)-MIN(B2:B30)Q3
=MAX(C2:C9)-MIN(C2:C9)Q4
=MAX(B2:B8)-MIN(B2:B8)Q5
=MAX(B2:B9)-MIN(B2:B9)Section E: Spot the Error
Q1
B — E3 should hold the smallest value, so it needs MIN(B2:B30). With MAX in both cells, E2-E3 would always be 0 instead of the range.
Q2
A — The range is the largest value minus the smallest value. The formula must be =MAX(C2:C9)-MIN(C2:C9). The broken version gives a negative number.
Q3
B — The range needs the smallest value, so lowest must be MIN(marks). AVERAGE gives the mean, which is not the lowest value.
Q4
D — The range is the highest value minus the lowest value, so it is 95 - 40 = 55. Adding them (95 + 40) is wrong and does not equal 55.
Q5
C — 158 - 50 is 108, not 98. The outlier 158 makes the range of Set B much larger than the range of Set A, which is 8.