Skip to the worksheet
Revision Library
Choose a subject

Data Cleaning and Outliers (Higher) - Worksheets, Questions and Revision

43 original exam-style questions - 25 pages of questions with a full mark scheme - free printable PDF.

This topic is chapter 4 of GCSE Statistics Higher Topic Workbook 2 and chapter 11 of GCSE Statistics Higher 10-Minute Tests 1.

Revision Library
revisionlibrary.co.uk
HIGHER

2.3 Data Cleaning and Outliers (Higher)

EDEXCEL 1ST0 · Calculator allowed · about 230 minutes
Total Marks
Name: _______________________________    Date: ____ / ____ / ______
Answer ALL questions. Show all your working.
1
A cycling club logs the distance, in km, ridden by each of its 8 members on a Saturday club run. The office assistant's raw log is shown below.
RowRiderDistance recorded
1Priya42 km
2Tom38 km
3Freya45 km
4Oscar51 km
5Freya45 km
6Nadia29 miles
7Callum47 km
8Isla33 km
(a)State which two row numbers are a duplicate entry for the same ride.(1)
(b)Explain why recording row 6's distance in miles, when every other row is in km, could cause a problem when the club works out the total distance ridden.(1)
(c)Given that 1 mile = 1.6 km, convert Nadia's distance to km, correct to 1 decimal place.(2)
(Total for Question 1 is 4 marks)
2
A small museum records the number of visitors on each of 11 consecutive days.
Day1234567891011
Visitors84799188769581082897785
(a)Write down the value in the list that is most likely to be a data-entry error.(1)
(b)Suggest what the correct number of visitors was likely to be on day 7, and explain your reasoning.(1)
(c)Work out the range of the visitor numbers exactly as recorded, including the value 810.(2)
(d)The value is corrected to 81. Work out the range of the corrected data set.(2)
(e)Explain the effect that this data-entry error had on the range.(1)
(Total for Question 2 is 7 marks)
3
For each statement about data cleaning and outliers, write down whether it is True or False.
(i)The rule Q1 - 1.5 x IQR is used to find an upper boundary for identifying outliers.(1)
(ii)A single very large outlier typically increases the standard deviation of a data set.(1)
(iii)If a missing value is imputed using the mean of the remaining data, the overall mean of the completed data set stays the same.(1)
(iv)Deleting a data point simply because it looks unusual, without first checking whether it is a genuine value, is good statistical practice.(1)
(Total for Question 3 is 4 marks)
4
A fitness app records the number of steps walked by 13 participants in a charity step challenge on one day, listed here in ascending order.

4200, 4550, 4700, 4800, 5100, 5300, 5450, 5600, 5750, 5900, 6100, 6300, 14200
(a)Write down the median number of steps.(1)
(b)Find the lower quartile (Q1) and the upper quartile (Q3) of the data.(2)
(c)Work out the interquartile range (IQR).(1)
(Total for Question 4 is 4 marks)
5
The step-count data from Question 4 is used again here: Q1 = 4750, Q3 = 6000 and IQR = 1250.
(a)A value is considered an outlier if it lies below Q1 - 1.5 x IQR or above Q3 + 1.5 x IQR. Work out these two boundaries for the step-count data.(2)
(b)Use your boundaries to identify any outlier(s) in the step-count data set.(1)
(c)The participant with 14200 steps says they took part in a long charity walk that day, in addition to their normal daily activity. Explain whether this participant's data should be deleted from the step-count data set.(2)
(Total for Question 5 is 5 marks)
6
A cafe records the number of customers served in the first 15 minutes of each of 8 hours during a shift.
Hour12345678
Customers served2225192421232026
(a)Work out the mean number of customers served.(2)
(b)Using the formula standard deviation = square root of [ (sum of (x - mean)2) / n ], work out the standard deviation of the number of customers served. Give your answer correct to 2 decimal places.(3)
(Total for Question 6 is 5 marks)
7
A delivery company records the time, in minutes, taken for 10 parcels to be delivered from the depot to customers' homes.
Parcel12345678910
Time (min)1822(not recorded)191452120172319
(a)Parcel 3's delivery time was not recorded. Give one advantage and one disadvantage of imputing (estimating) this missing value using the mean of the other delivery times, rather than deleting parcel 3's record entirely.(2)
(b)Parcel 5's delivery time is recorded as 145 minutes, far higher than every other parcel. Explain why the company should investigate this value rather than immediately deleting it or replacing it with the mean.(2)
(c)The company decides to impute parcel 3's missing value using the mean of the other 9 recorded times (treating parcel 5's 145 minutes as genuine for now). Work out this imputed value, correct to 1 decimal place.(2)
(d)Comment on whether this imputed value from part (c) is a sensible estimate for parcel 3's delivery time.(1)
(Total for Question 7 is 7 marks)
8
For the marks of a group of people in a test, the lower quartile is 17 and the upper quartile is 33. The smallest value is 3 and the largest value is 61. A value is an outlier if it is more than 1.5 x interquartile range below the lower quartile or above the upper quartile.
(a) Work out the interquartile range.
(b) Work out the limits beyond which a value is an outlier.
(c) State which of the smallest and the largest value, if any, are outliers.
(Total for Question 8 is 4 marks)
9
Here are the number of hours of sleep per night recorded for 8 people. Valid values are whole numbers from 3 to 12 inclusive.

11, 999, 120, 10, 8, 5, 9, 6

(a) Write down the invalid values.
(b) Work out the mean of all 8 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
(Total for Question 9 is 5 marks)
10
A sample of 8 measurements is 51, 58, 53, 112, 51, 59, 59, 57. The value 112 is an outlier.
(a) Work out the mean and the median of all 8 values (mean to 1 decimal place if needed).
(b) Work out the mean and the median without the outlier.
(c) Which average is changed less by removing the outlier?
(Total for Question 10 is 4 marks)
11
Here are the heights of pupils in centimetres recorded for 10 people. Valid values are whole numbers from 130 to 190 inclusive.

145, 155, 190, 180, 175, 144, 0, 164, 157, 187

(a) Write down the invalid values.
(b) Work out the mean of all 10 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
(Total for Question 11 is 5 marks)
12
For the numbers of messages sent by a group of people in a day, the lower quartile is 18 and the upper quartile is 40. The smallest value is 5 and the largest value is 82. A value is an outlier if it is more than 1.5 x interquartile range below the lower quartile or above the upper quartile.
(a) Work out the interquartile range.
(b) Work out the limits beyond which a value is an outlier.
(c) State which of the smallest and the largest value, if any, are outliers.
(Total for Question 12 is 4 marks)
13
Here are the number of hours of sleep per night recorded for 10 people. Valid values are whole numbers from 3 to 12 inclusive.

5, 6, 10, 4, 5, 9, 9, 1, 9, 11

(a) Write down the invalid values.
(b) Work out the mean of all 10 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
(Total for Question 13 is 5 marks)
14
For the times, in minutes, taken by a group of people to finish a puzzle, the lower quartile is 34 and the upper quartile is 53. The smallest value is 8 and the largest value is 78. A value is an outlier if it is more than 1.5 x interquartile range below the lower quartile or above the upper quartile.
(a) Work out the interquartile range.
(b) Work out the limits beyond which a value is an outlier.
(c) State which of the smallest and the largest value, if any, are outliers.
(Total for Question 14 is 4 marks)
15
A sample of 8 measurements is 28, 25, 26, 32, 23, 31, 24, 94. The value 94 is an outlier.
(a) Work out the mean and the median of all 8 values (mean to 1 decimal place if needed).
(b) Work out the mean and the median without the outlier.
(c) Which average is changed less by removing the outlier?
(Total for Question 15 is 4 marks)
16
For the heights, in centimetres, of a group of people, the lower quartile is 13 and the upper quartile is 23. The smallest value is 4 and the largest value is 47. A value is an outlier if it is more than 1.5 x interquartile range below the lower quartile or above the upper quartile.
(a) Work out the interquartile range.
(b) Work out the limits beyond which a value is an outlier.
(c) State which of the smallest and the largest value, if any, are outliers.
(Total for Question 16 is 4 marks)
17
A sample of 6 measurements is 50, 49, 54, 119, 48, 55. The value 119 is an outlier.
(a) Work out the mean and the median of all 6 values (mean to 1 decimal place if needed).
(b) Work out the mean and the median without the outlier.
(c) Which average is changed less by removing the outlier?
(Total for Question 17 is 4 marks)
18
Here are the shoe sizes recorded for 9 people. Valid values are whole numbers from 3 to 12 inclusive.

10, 5, 10, 8, 4, 1, 4, -1, 12

(a) Write down the invalid values.
(b) Work out the mean of all 9 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
(Total for Question 18 is 5 marks)
19
A sample of 10 measurements is 32, 34, 36, 30, 99, 29, 32, 34, 32, 33. The value 99 is an outlier.
(a) Work out the mean and the median of all 10 values (mean to 1 decimal place if needed).
(b) Work out the mean and the median without the outlier.
(c) Which average is changed less by removing the outlier?
(Total for Question 19 is 4 marks)
20
Here are the heights of pupils in centimetres recorded for 8 people. Valid values are whole numbers from 130 to 190 inclusive.

175, 157, 43, 130, 164, 149, 146, 999

(a) Write down the invalid values.
(b) Work out the mean of all 8 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
(Total for Question 20 is 5 marks)
21
For the heights, in centimetres, of a group of people, the lower quartile is 23 and the upper quartile is 35. The smallest value is 11 and the largest value is 62. A value is an outlier if it is more than 1.5 x interquartile range below the lower quartile or above the upper quartile.
(a) Work out the interquartile range.
(b) Work out the limits beyond which a value is an outlier.
(c) State which of the smallest and the largest value, if any, are outliers.
(Total for Question 21 is 4 marks)
22
Here are the number of hours of sleep per night recorded for 9 people. Valid values are whole numbers from 3 to 12 inclusive.

7, 4, 12, 1, 5, 1, 10, 7, 12

(a) Write down the invalid values.
(b) Work out the mean of all 9 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
(Total for Question 22 is 5 marks)
23
For the marks of a group of people in a test, the lower quartile is 25 and the upper quartile is 43. The smallest value is 9 and the largest value is 79. A value is an outlier if it is more than 1.5 x interquartile range below the lower quartile or above the upper quartile.
(a) Work out the interquartile range.
(b) Work out the limits beyond which a value is an outlier.
(c) State which of the smallest and the largest value, if any, are outliers.
(Total for Question 23 is 4 marks)
24
A sample of 8 measurements is 20, 18, 16, 21, 15, 19, 25, 57. The value 57 is an outlier.
(a) Work out the mean and the median of all 8 values (mean to 1 decimal place if needed).
(b) Work out the mean and the median without the outlier.
(c) Which average is changed less by removing the outlier?
(Total for Question 24 is 4 marks)
25
For the masses, in kilograms, of a group of people, the lower quartile is 26 and the upper quartile is 43. The smallest value is 10 and the largest value is 65. A value is an outlier if it is more than 1.5 x interquartile range below the lower quartile or above the upper quartile.
(a) Work out the interquartile range.
(b) Work out the limits beyond which a value is an outlier.
(c) State which of the smallest and the largest value, if any, are outliers.
(Total for Question 25 is 4 marks)
26
A sample of 8 measurements is 54, 52, 57, 57, 17, 55, 56, 51. The value 17 is an outlier.
(a) Work out the mean and the median of all 8 values (mean to 1 decimal place if needed).
(b) Work out the mean and the median without the outlier.
(c) Which average is changed less by removing the outlier?
(Total for Question 26 is 4 marks)
27
Here are the ages of club members in years recorded for 8 people. Valid values are whole numbers from 11 to 17 inclusive.

16, 999, 12, 12, 17, 11, -1, 13

(a) Write down the invalid values.
(b) Work out the mean of all 8 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
(Total for Question 27 is 5 marks)
28
A sample of 10 measurements is 34, 93, 38, 35, 37, 41, 43, 35, 35, 37. The value 93 is an outlier.
(a) Work out the mean and the median of all 10 values (mean to 1 decimal place if needed).
(b) Work out the mean and the median without the outlier.
(c) Which average is changed less by removing the outlier?
(Total for Question 28 is 4 marks)
29
Here are the heights of pupils in centimetres recorded for 10 people. Valid values are whole numbers from 130 to 190 inclusive.

149, 43, 178, 168, 145, 132, 135, 177, 131, 133

(a) Write down the invalid values.
(b) Work out the mean of all 10 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
(Total for Question 29 is 5 marks)
30
For the masses, in kilograms, of a group of people, the lower quartile is 16 and the upper quartile is 33. The smallest value is 2 and the largest value is 67. A value is an outlier if it is more than 1.5 x interquartile range below the lower quartile or above the upper quartile.
(a) Work out the interquartile range.
(b) Work out the limits beyond which a value is an outlier.
(c) State which of the smallest and the largest value, if any, are outliers.
(Total for Question 30 is 4 marks)
31
Here are the heights of pupils in centimetres recorded for 8 people. Valid values are whole numbers from 130 to 190 inclusive.

154, 188, 0, 162, 170, 155, 141, 130

(a) Write down the invalid values.
(b) Work out the mean of all 8 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
(Total for Question 31 is 5 marks)
32
A sample of 10 measurements is 56, 55, 52, 57, 57, 59, 12, 55, 58, 59. The value 12 is an outlier.
(a) Work out the mean and the median of all 10 values (mean to 1 decimal place if needed).
(b) Work out the mean and the median without the outlier.
(c) Which average is changed less by removing the outlier?
(Total for Question 32 is 4 marks)
33
For the masses, in kilograms, of a group of people, the lower quartile is 30 and the upper quartile is 51. The smallest value is 2 and the largest value is 79. A value is an outlier if it is more than 1.5 x interquartile range below the lower quartile or above the upper quartile.
(a) Work out the interquartile range.
(b) Work out the limits beyond which a value is an outlier.
(c) State which of the smallest and the largest value, if any, are outliers.
(Total for Question 33 is 4 marks)
34
A sample of 6 measurements is 52, 48, 54, 54, 54, 96. The value 96 is an outlier.
(a) Work out the mean and the median of all 6 values (mean to 1 decimal place if needed).
(b) Work out the mean and the median without the outlier.
(c) Which average is changed less by removing the outlier?
(Total for Question 34 is 4 marks)
35
Here are the ages of club members in years recorded for 8 people. Valid values are whole numbers from 11 to 17 inclusive.

17, 17, 11, 13, 16, 15, 11, 0

(a) Write down the invalid values.
(b) Work out the mean of all 8 values, to 1 decimal place if needed.
(c) Work out the mean after the invalid values are removed, to 1 decimal place if needed.
(Total for Question 35 is 5 marks)
36
Later that day, the same cafe runs a one-hour promotion. In this extra hour, 74 customers were served in the first 15 minutes, far more than in any of the 8 hours in Question 6. Including this promotional hour, the full data set of 9 values is:

19, 20, 21, 22, 23, 24, 25, 26, 74
(a)Work out the new mean number of customers, including the promotional hour. Give your answer correct to 2 decimal places.(2)
(b)Write down the new median.(1)
(c)Work out the new standard deviation of the 9 values, using the same formula as in Question 6. Give your answer correct to 2 decimal places.(3)
(d)By comparing your answers here with the mean (22.5), median (22.5) and standard deviation (2.29) from Question 6, comment on which measure changed the most because of the promotional hour, and which changed the least.(2)
(Total for Question 36 is 8 marks)
37
The box plot shows the time, in minutes, taken by 40 runners to finish a fun run. One runner's time is marked separately with a dot, since it was not included when the box and whiskers were drawn.
20 30 40 50 60 70 80 Time (minutes) 71
(a)Write down the median time and the interquartile range (IQR) shown on the box plot.(2)
(b)One runner's time is marked separately at 71 minutes. Using the rule that a value is an outlier if it is above Q3 + 1.5 x IQR, show that 71 minutes is an outlier.(2)
(c)Give a possible genuine reason why this runner's time was so much higher than everyone else's, rather than assuming it must be a data-entry error.(1)
(Total for Question 37 is 5 marks)
38
A gardener records the height, in cm, of 15 sunflower plants at the end of the growing season, listed here in ascending order.

142, 145, 148, 150, 151, 153, 154, 156, 158, 159, 161, 163, 165, 168, 210
130 140 150 160 170 180 190 200 210 220 Height (cm)
(a)Find the median, the lower quartile (Q1) and the upper quartile (Q3) of the 15 heights.(3)
(b)Show that the tallest sunflower (210 cm) is an outlier, using the boundary Q3 + 1.5 x IQR.(2)
(c)On the grid provided, draw a box plot for the 14 non-outlier heights (that is, excluding the 210 cm sunflower). Plot the 210 cm sunflower separately, as an isolated point beyond the whisker.(3)
(Total for Question 38 is 8 marks)
39
Aaron is investigating how many hours Year 11 students spend revising per week. He designs a questionnaire, distributes it to a random sample of 30 students, and enters their responses into a spreadsheet. (The statistical enquiry cycle has four stages: plan, collect, process, interpret.)
(a)Aaron notices that two students have left the revising-hours question blank. At which stage of the statistical enquiry cycle should Aaron decide how to deal with these missing responses?(1)
(b)One response reads '20 hours', much higher than every other response (all between 2 and 12 hours). Aaron calculates that Q1 = 4 hours and Q3 = 9 hours for the sample. Use the rule Q3 + 1.5 x IQR to decide whether 20 hours should be treated as an outlier.(3)
(c)Aaron decides to leave the two blank responses out of his analysis rather than guessing a value for them, but to investigate the '20 hours' response further rather than deleting it immediately. Explain why both of these are reasonable decisions.(2)
(Total for Question 39 is 6 marks)
40
A quality-control inspector at a factory measures the mass, in grams, of 10 bags of rice from a production line.
Bag12345678910
Mass (g)50149850350502500499497504499
(a)Identify the bag whose mass is very likely a data-entry error.(1)
(b)State the value this entry should probably be corrected to, and explain your reasoning.(1)
(c)Using the RAW data (that is, with 50 g for bag 4), work out the mean and standard deviation of the 10 masses. Give the standard deviation correct to 1 decimal place. You may use the formula standard deviation = square root of [ (sum of x2)/n - mean2 ].(4)
(d)Using the CORRECTED data (that is, with 500 g for bag 4), work out the mean and standard deviation of the 10 masses. Give the standard deviation correct to 1 decimal place.(3)
(e)Comment on the effect that this single data-entry error had on the standard deviation.(1)
(Total for Question 40 is 10 marks)
41
A machine operator records the diameter, in mm, of 15 ball bearings and calculates two summary totals from her spreadsheet: the sum of the diameters, sum of x = 309.6, and the sum of the squared diameters, sum of x2 = 6476.86.
(a)Using sum of x = 309.6, work out the mean diameter as originally recorded.(1)
(b)A check of the machine's calibration log shows that one ball bearing's diameter was recorded as 29.6 mm, but should have been 19.6 mm (a digit was mistyped). Work out the corrected value of sum of x.(2)
(c)Work out the corrected value of sum of x2.(2)
(d)Hence work out the corrected mean and standard deviation of the 15 diameters. Give the standard deviation correct to 2 decimal places. You may use the formula standard deviation = square root of [ (sum of x2)/n - mean2 ].(3)
(e)Given that the standard deviation calculated from the original (uncorrected) sum of x and sum of x2 was 2.40 mm (2 dp), comment on the effect that correcting the single misrecorded value had on the standard deviation.(1)
(Total for Question 41 is 9 marks)
42
A car park attendant's spreadsheet automatically logs the length of stay, in minutes, of vehicles using the car park. While checking the log for one day, she discovers that 6 vehicles which left during the 60 < t ≤ 90 minute class were also mistakenly logged a second time in the 90 < t ≤ 120 minute class, because of a fault in the automatic timer. The table below shows the frequencies as they were first recorded (before this fault was found).
Length of stay, t (min)0 < t ≤ 3030 < t ≤ 6060 < t ≤ 9090 < t ≤ 120
Frequency (as recorded)8142321
(a)Explain why the total of the frequencies in the table (66) does not match the 60 vehicles that actually used the car park that day.(1)
(b)Write down the corrected frequency for the 90 < t ≤ 120 class.(1)
(c)Using mid-interval values, work out an estimate for the mean length of stay using the corrected frequencies (8, 14, 23, 15).(3)
(d)Given that sum of fx2 = 324900 for the corrected data, work out an estimate for the standard deviation of the corrected data. Give your answer correct to 1 decimal place.(2)
(e)Using the UNCORRECTED (originally recorded) frequencies, the estimated mean is 70.9 minutes and the estimated standard deviation is 29.9 minutes (both 1 dp). Comment on the effect that the duplicate-logging error had on these estimates.(1)
(Total for Question 42 is 8 marks)
43
The table below shows three measures of spread for the rice-bag masses from Question 40, calculated before and after the data-entry error was corrected.
Measure of spreadBefore cleaning (raw)After cleaning (corrected)
Range454 g7 g
Interquartile range (IQR)4 g3 g
Standard deviation135.1 g2.1 g
(a)By comparing the 'before' and 'after' values in the table, state which measure of spread changed the LEAST as a result of cleaning the data.(1)
(b)Explain why the interquartile range is much less affected than the range or the standard deviation by a single extreme/erroneous value.(2)
(c)A different data set is known to contain at least one extreme data-entry error, but there is no time to check and correct every entry before a report is due. Recommend which of the three measures of spread in the table the analyst should use to describe the data, and justify your recommendation.(2)
(Total for Question 43 is 5 marks)
Mark scheme · 2.3 Data Cleaning and Outliers (Higher)

Question 1

  • (a) 3 and 5 caoB1
  • (a) Answer: Rows 3 and 5
  • (b) explains that mixing units would make the total/sum of distances meaningless unless all values are converted to the same unit first oeB1
  • (b) Answer: If the 29 is added to the other distances without converting it, the total distance ridden would be wrong, because 29 miles is not the same as 29 km.
  • (c) 29 x 1.6, oeM1
  • (c) 46.4 km caoA1
  • (c) Answer: 46.4 km

Question 2

  • (a) 810 caoB1
  • (a) Answer: 810
  • (b) 81 (an extra 0 was probably typed after 81), oe reasoning that links to the range of the other valuesB1
  • (b) Answer: 81 visitors (an extra 0 was probably typed by mistake).
  • (c) 810 - 76, oeM1
  • (c) 734 caoA1
  • (c) Answer: 734
  • (d) 95 - 76, oeM1
  • (d) 19 caoA1
  • (d) Answer: 19
  • (e) the error made the range far larger than it should be (734 instead of 19), because the range only uses the two most extreme values, so one incorrect extreme value distorts it heavily oeB1
  • (e) Answer: The error inflated the range hugely (734 instead of the true 19), because the range depends only on the biggest and smallest values, so a single wrong extreme value badly distorts it.

Question 3

  • (i) False caoB1
  • (i) Answer: False
  • (ii) True caoB1
  • (ii) Answer: True
  • (iii) True caoB1
  • (iii) Answer: True
  • (iv) False caoB1
  • (iv) Answer: False

Question 4

  • (a) 5450 caoB1
  • (a) Answer: 5450
  • (b) Q1 = 4750 caoB1
  • (b) Q3 = 6000 caoB1
  • (b) Answer: Q1 = 4750, Q3 = 6000
  • (c) 1250 (ft from Q3 - Q1)B1
  • (c) Answer: 1250

Question 5

  • (a) 4750 - 1.5x1250 and 6000 + 1.5x1250, oeM1
  • (a) 2875 and 7875, both correctA1
  • (a) Answer: Lower boundary = 2875, upper boundary = 7875
  • (b) 14200 cao (ft from part a)B1
  • (b) Answer: 14200 steps
  • (c) the value is a genuine result, explained by real behaviour, rather than a data-entry error oeB1
  • (c) it should be kept (and possibly flagged/analysed separately) rather than deleted, since deleting genuine data would lose real information and could bias the results oeB1
  • (c) Answer: No, it should not be deleted; 14200 is a genuine value explained by the charity walk, so removing it would lose real information and could bias the results.

Question 6

  • (a) 22+25+19+24+21+23+20+26, oe (=180)M1
  • (a) 22.5 caoA1
  • (a) Answer: 22.5
  • (b) finds the deviation of each value from the mean (22.5) and squares each oneM1
  • (b) sums the squared deviations and divides by n=8, oe (=5.25)M1
  • (b) 2.29 (awrt 2.29) caoA1
  • (b) Answer: 2.29 (awrt)

Question 7

  • (a) advantage: keeps the sample size at 10 / keeps some information about parcel 3, so later calculations can still use all the deliveries oeB1
  • (a) disadvantage: the imputed value is not a genuine measurement and may not reflect parcel 3's true delivery time, especially if it was unusual oeB1
  • (a) Answer: Advantage: keeps the full sample of 10 parcels for later calculations. Disadvantage: the imputed value is not a real measurement and may not reflect what actually happened to parcel 3.
  • (b) 145 minutes might reveal a genuine problem, e.g. a lost or delayed parcel, which is valuable information for the business oeB1
  • (b) deleting or replacing it straight away would hide this problem and could make future delivery-time estimates unrealistically low/optimistic oeB1
  • (b) Answer: 145 minutes could reveal a genuine delivery problem (e.g. a lost parcel); deleting or replacing it immediately would hide this and could make future delivery-time estimates too optimistic.
  • (c) 18+22+19+145+21+20+17+23+19, oe (=304), divided by 9M1
  • (c) 33.8 (awrt 33.8) caoA1
  • (c) Answer: 33.8 minutes (awrt)
  • (d) no - because parcel 5's extreme 145 minutes was included in the calculation, it pulls the mean far higher than a typical delivery (all other times are between 17 and 23 minutes), so 33.8 minutes is not realistic; parcel 5 should be resolved before imputing parcel 3 oeB1
  • (d) Answer: No; including the extreme 145-minute delivery pulls the imputed value up to 33.8 minutes, far higher than a typical delivery time (17 to 23 minutes), so it is not a sensible estimate.

Question 8

  • 16B1
  • 17 - 1.5 x 16 or 33 + 1.5 x 16M1
  • -7 and 57 caoA1
  • the largest onlyB1
  • Answer: (a) 16; (b) -7 and 57; (c) the largest only

Question 9

  • invalid values 999, 120B1
  • sum of all values divided by 8M1
  • 146 caoA1
  • sum of valid values divided by 6M1
  • 8.2 caoA1
  • Answer: (a) 999, 120; (b) 146; (c) 8.2

Question 10

  • mean 62.5, median 57.5B1
  • removes 112 and recalculatesM1
  • mean 55.4, median 57A1
  • the medianB1
  • Answer: (a) mean 62.5, median 57.5; (b) mean 55.4, median 57; (c) median

Question 11

  • invalid values 0B1
  • sum of all values divided by 10M1
  • 149.7 caoA1
  • sum of valid values divided by 9M1
  • 166.3 caoA1
  • Answer: (a) 0; (b) 149.7; (c) 166.3

Question 12

  • 22B1
  • 18 - 1.5 x 22 or 40 + 1.5 x 22M1
  • -15 and 73 caoA1
  • the largest onlyB1
  • Answer: (a) 22; (b) -15 and 73; (c) the largest only

Question 13

  • invalid values 1B1
  • sum of all values divided by 10M1
  • 6.9 caoA1
  • sum of valid values divided by 9M1
  • 7.6 caoA1
  • Answer: (a) 1; (b) 6.9; (c) 7.6

Question 14

  • 19B1
  • 34 - 1.5 x 19 or 53 + 1.5 x 19M1
  • 5.5 and 81.5 caoA1
  • neitherB1
  • Answer: (a) 19; (b) 5.5 and 81.5; (c) neither

Question 15

  • mean 35.4, median 27B1
  • removes 94 and recalculatesM1
  • mean 27, median 26A1
  • the medianB1
  • Answer: (a) mean 35.4, median 27; (b) mean 27, median 26; (c) median

Question 16

  • 10B1
  • 13 - 1.5 x 10 or 23 + 1.5 x 10M1
  • -2 and 38 caoA1
  • the largest onlyB1
  • Answer: (a) 10; (b) -2 and 38; (c) the largest only

Question 17

  • mean 62.5, median 52B1
  • removes 119 and recalculatesM1
  • mean 51.2, median 50A1
  • the medianB1
  • Answer: (a) mean 62.5, median 52; (b) mean 51.2, median 50; (c) median

Question 18

  • invalid values 1, -1B1
  • sum of all values divided by 9M1
  • 5.9 caoA1
  • sum of valid values divided by 7M1
  • 7.6 caoA1
  • Answer: (a) 1, -1; (b) 5.9; (c) 7.6

Question 19

  • mean 39.1, median 32.5B1
  • removes 99 and recalculatesM1
  • mean 32.4, median 32A1
  • the medianB1
  • Answer: (a) mean 39.1, median 32.5; (b) mean 32.4, median 32; (c) median

Question 20

  • invalid values 43, 999B1
  • sum of all values divided by 8M1
  • 245.4 caoA1
  • sum of valid values divided by 6M1
  • 153.5 caoA1
  • Answer: (a) 43, 999; (b) 245.4; (c) 153.5

Question 21

  • 12B1
  • 23 - 1.5 x 12 or 35 + 1.5 x 12M1
  • 5 and 53 caoA1
  • the largest onlyB1
  • Answer: (a) 12; (b) 5 and 53; (c) the largest only

Question 22

  • invalid values 1, 1B1
  • sum of all values divided by 9M1
  • 6.6 caoA1
  • sum of valid values divided by 7M1
  • 8.1 caoA1
  • Answer: (a) 1, 1; (b) 6.6; (c) 8.1

Question 23

  • 18B1
  • 25 - 1.5 x 18 or 43 + 1.5 x 18M1
  • -2 and 70 caoA1
  • the largest onlyB1
  • Answer: (a) 18; (b) -2 and 70; (c) the largest only

Question 24

  • mean 23.9, median 19.5B1
  • removes 57 and recalculatesM1
  • mean 19.1, median 19A1
  • the medianB1
  • Answer: (a) mean 23.9, median 19.5; (b) mean 19.1, median 19; (c) median

Question 25

  • 17B1
  • 26 - 1.5 x 17 or 43 + 1.5 x 17M1
  • 0.5 and 68.5 caoA1
  • neitherB1
  • Answer: (a) 17; (b) 0.5 and 68.5; (c) neither

Question 26

  • mean 49.9, median 54.5B1
  • removes 17 and recalculatesM1
  • mean 54.6, median 55A1
  • the medianB1
  • Answer: (a) mean 49.9, median 54.5; (b) mean 54.6, median 55; (c) median

Question 27

  • invalid values 999, -1B1
  • sum of all values divided by 8M1
  • 134.9 caoA1
  • sum of valid values divided by 6M1
  • 13.5 caoA1
  • Answer: (a) 999, -1; (b) 134.9; (c) 13.5

Question 28

  • mean 42.8, median 37B1
  • removes 93 and recalculatesM1
  • mean 37.2, median 37A1
  • the medianB1
  • Answer: (a) mean 42.8, median 37; (b) mean 37.2, median 37; (c) median

Question 29

  • invalid values 43B1
  • sum of all values divided by 10M1
  • 139.1 caoA1
  • sum of valid values divided by 9M1
  • 149.8 caoA1
  • Answer: (a) 43; (b) 139.1; (c) 149.8

Question 30

  • 17B1
  • 16 - 1.5 x 17 or 33 + 1.5 x 17M1
  • -9.5 and 58.5 caoA1
  • the largest onlyB1
  • Answer: (a) 17; (b) -9.5 and 58.5; (c) the largest only

Question 31

  • invalid values 0B1
  • sum of all values divided by 8M1
  • 137.5 caoA1
  • sum of valid values divided by 7M1
  • 157.1 caoA1
  • Answer: (a) 0; (b) 137.5; (c) 157.1

Question 32

  • mean 52, median 56.5B1
  • removes 12 and recalculatesM1
  • mean 56.4, median 57A1
  • the medianB1
  • Answer: (a) mean 52, median 56.5; (b) mean 56.4, median 57; (c) median

Question 33

  • 21B1
  • 30 - 1.5 x 21 or 51 + 1.5 x 21M1
  • -1.5 and 82.5 caoA1
  • neitherB1
  • Answer: (a) 21; (b) -1.5 and 82.5; (c) neither

Question 34

  • mean 59.7, median 54B1
  • removes 96 and recalculatesM1
  • mean 52.4, median 54A1
  • the medianB1
  • Answer: (a) mean 59.7, median 54; (b) mean 52.4, median 54; (c) median

Question 35

  • invalid values 0B1
  • sum of all values divided by 8M1
  • 12.5 caoA1
  • sum of valid values divided by 7M1
  • 14.3 caoA1
  • Answer: (a) 0; (b) 12.5; (c) 14.3

Question 36

  • (a) 19+20+21+22+23+24+25+26+74, oe (=254)M1
  • (a) 28.22 (awrt 28.22) caoA1
  • (a) Answer: 28.22 (awrt)
  • (b) 23 caoB1
  • (b) Answer: 23
  • (c) finds the deviation of each value from the new mean and squares each oneM1
  • (c) sums the squared deviations and divides by n=9, oeM1
  • (c) 16.33 (awrt 16.33) caoA1
  • (c) Answer: 16.33 (awrt)
  • (d) the standard deviation changed by far the most, rising from 2.29 to about 16.33, roughly 7 times bigger oeB1
  • (d) the median changed the least, rising only slightly from 22.5 to 23, while the mean rose more noticeably to 28.22, showing the median is the measure most resistant to an extreme value oeB1
  • (d) Answer: The standard deviation changed the most (2.29 to 16.33); the median changed the least (22.5 to 23); the mean also rose noticeably (22.5 to 28.22). This shows the median is the most resistant to an outlier, while the standard deviation is the most sensitive.

Question 37

  • (a) median = 38 caoB1
  • (a) IQR = 44 - 32 = 12 caoB1
  • (a) Answer: Median = 38 minutes, IQR = 12 minutes
  • (b) 44 + 1.5x12, oeM1
  • (b) 62, and 71 > 62 so it is an outlier, caoA1
  • (b) Answer: 62 minutes; since 71 > 62, it is an outlier.
  • (c) e.g. the runner may have stopped to help an injured runner, walked most of the course, or been injured themselves, oeB1
  • (c) Answer: The runner may have stopped to help someone else, been injured, or walked most of the course, so 71 minutes could be a genuine time.

Question 38

  • (a) median = 156 caoB1
  • (a) Q1 = 150 caoB1
  • (a) Q3 = 163 caoB1
  • (a) Answer: Median = 156 cm, Q1 = 150 cm, Q3 = 163 cm
  • (b) IQR = 13 and 163 + 1.5x13, oeM1
  • (b) 182.5, and 210 > 182.5 so it is an outlier, caoA1
  • (b) Answer: 182.5 cm; since 210 > 182.5, it is an outlier.
  • (c) box drawn correctly from Q1 = 150 to Q3 = 161 with the median line at 155B1
  • (c) whiskers drawn correctly to the minimum (142) and to the maximum of the remaining values (168)B1
  • (c) the 210 cm sunflower plotted as a separate point, clearly apart from the whiskerB1
  • (c) Answer: Box from 150 to 161 with median line at 155; whiskers to 142 and 168; the 210 cm sunflower plotted as a separate point.

Question 39

  • (a) process caoB1
  • (a) Answer: The process stage.
  • (b) IQR = 9 - 4 = 5, oeM1
  • (b) 9 + 1.5x5, oeM1
  • (b) 16.5, and 20 > 16.5 so yes it is an outlier, caoA1
  • (b) Answer: Yes; the boundary is 16.5 hours, and 20 hours is greater than this.
  • (c) blank responses contain no genuine information, so guessing a value could introduce bias/inaccuracy that a real value would not have oeB1
  • (c) an unusually high but not impossible value like 20 hours could be genuine, e.g. a student revising intensively before exams, so deleting it straight away could lose real, useful information oeB1
  • (c) Answer: Blank responses have no genuine data to guess from, so estimating them risks bias. 20 hours could be a genuine value (e.g. a student cramming before exams), so it should be checked rather than deleted straight away.

Question 40

  • (a) bag 4 (50 g) caoB1
  • (a) Answer: Bag 4 (50 g).
  • (b) 500 g - a zero has probably been dropped when the mass was typed in, oeB1
  • (b) Answer: 500 g (a zero was probably dropped when it was typed in).
  • (c) sum = 4553, oeM1
  • (c) mean = 455.3 caoA1
  • (c) correct substitution into the formula, e.g. 2255545/10 - 455.32, oeM1
  • (c) 135.1 (awrt 135.1) caoA1
  • (c) Answer: Mean = 455.3 g, standard deviation = 135.1 g (awrt).
  • (d) sum = 5003, oeM1
  • (d) mean = 500.3 caoA1
  • (d) SD = 2.1 caoA1
  • (d) Answer: Mean = 500.3 g, standard deviation = 2.1 g.
  • (e) the error inflated the standard deviation enormously, from 2.1 g to about 135.1 g (more than 60 times larger), showing that even one incorrect value can make the spread look far bigger than it really is oeB1
  • (e) Answer: The error inflated the standard deviation hugely, from 2.1 g (corrected) to about 135.1 g (raw), more than 60 times larger, showing how much one wrong value can distort a measure of spread.

Question 41

  • (a) 20.64 mm caoB1
  • (a) Answer: 20.64 mm.
  • (b) 309.6 - 29.6 + 19.6, oeM1
  • (b) 299.6 caoA1
  • (b) Answer: sum of x = 299.6.
  • (c) 6476.86 - 29.62 + 19.62, oeM1
  • (c) 5984.86 caoA1
  • (c) Answer: sum of x2 = 5984.86.
  • (d) mean = 299.6/15, oeM1
  • (d) 19.97 (awrt 19.97) caoA1
  • (d) SD = 0.24 (awrt 0.24) caoA1
  • (d) Answer: Mean = 19.97 mm (awrt), standard deviation = 0.24 mm (awrt).
  • (e) correcting the value reduced the standard deviation hugely, from about 2.40 mm to about 0.24 mm (roughly one tenth of its original size), showing how much a single incorrect entry can inflate a standard deviation oeB1
  • (e) Answer: The standard deviation fell dramatically, from about 2.40 mm (using the recorded value) to about 0.24 mm (corrected), about one tenth the size, showing how much one wrong entry can inflate the spread.

Question 42

  • (a) the 6 vehicles that left during the 60-90 min class were logged twice - once correctly and once in error in the 90-120 min class - so these 6 extra rows do not represent extra vehicles oeB1
  • (a) Answer: The 6 vehicles that left in the 60-90 minute class were logged a second time by mistake in the 90-120 minute class, so those 6 extra entries do not represent extra vehicles.
  • (b) 15 cao (21 - 6)B1
  • (b) Answer: 15.
  • (c) mid-values 15, 45, 75, 105 used, oeM1
  • (c) sum of f x mid-value = 4050, oeM1
  • (c) mean = 67.5 minutes caoA1
  • (c) Answer: 67.5 minutes.
  • (d) 324900/60 - 67.52, oeM1
  • (d) 29.3 (awrt 29.3) caoA1
  • (d) Answer: 29.3 minutes (awrt).
  • (e) the error increased both the estimated mean (by about 3.4 minutes) and the estimated standard deviation (by about 0.6 minutes), because it wrongly added extra vehicles into a higher time class oeB1
  • (e) Answer: The error increased the estimated mean (by about 3.4 minutes) and the estimated standard deviation (by about 0.6 minutes), since it wrongly shifted 6 extra 'vehicles' into a higher time class than they really belonged to.

Question 43

  • (a) the interquartile range (IQR) cao - changed from 4 g to 3 g, a change of only 1 gB1
  • (a) Answer: The interquartile range (IQR), which changed from 4 g to only 3 g.
  • (b) the IQR only uses the middle 50% of the data (the values between Q1 and Q3), so a single extreme value at either end has no direct effect on it oeB1
  • (b) the range uses only the two most extreme values, and the standard deviation uses every squared deviation from the mean, so both are heavily influenced by a single very large or very small value oeB1
  • (b) Answer: The IQR only depends on the middle 50% of the data, so an extreme value at either end does not affect it directly. The range depends only on the two most extreme values, and the standard deviation depends on every squared deviation from the mean, so both are strongly affected by a single extreme or erroneous value.
  • (c) recommends the interquartile range (IQR)B1
  • (c) justifies this because the IQR is more resistant/robust to outliers and errors than the range or standard deviation, so it will still give a fair description of the spread of the majority of the data even if some values are wrong oeB1
  • (c) Answer: The analyst should use the interquartile range (IQR), because it is far more resistant to outliers and data-entry errors than the range or standard deviation, so it will still describe the spread of the data fairly even with an uncorrected error present.

Mark your answers

Check answers without an account. Some answers can be checked automatically; use the mark scheme to mark the rest.

Question 1

4 marks
Did your answer earn the marks?

Question 2

7 marks
Did your answer earn the marks?

Question 3

4 marks
Did your answer earn the marks?

Question 4

4 marks
Did your answer earn the marks?

Question 5

5 marks
Did your answer earn the marks?

Question 6

5 marks
Did your answer earn the marks?

Question 7

7 marks
Did your answer earn the marks?

Question 8

4 marks
Did your answer earn the marks?

Question 9

5 marks
Did your answer earn the marks?

Question 10

4 marks
Did your answer earn the marks?

Question 11

5 marks
Did your answer earn the marks?

Question 12

4 marks
Did your answer earn the marks?

Question 13

5 marks
Did your answer earn the marks?

Question 14

4 marks
Did your answer earn the marks?

Question 15

4 marks
Did your answer earn the marks?

Question 16

4 marks
Did your answer earn the marks?

Question 17

4 marks
Did your answer earn the marks?

Question 18

5 marks
Did your answer earn the marks?

Question 19

4 marks
Did your answer earn the marks?

Question 20

5 marks
Did your answer earn the marks?

Question 21

4 marks
Did your answer earn the marks?

Question 22

5 marks
Did your answer earn the marks?

Question 23

4 marks
Did your answer earn the marks?

Question 24

4 marks
Did your answer earn the marks?

Question 25

4 marks
Did your answer earn the marks?

Question 26

4 marks
Did your answer earn the marks?

Question 27

5 marks
Did your answer earn the marks?

Question 28

4 marks
Did your answer earn the marks?

Question 29

5 marks
Did your answer earn the marks?

Question 30

4 marks
Did your answer earn the marks?

Question 31

5 marks
Did your answer earn the marks?

Question 32

4 marks
Did your answer earn the marks?

Question 33

4 marks
Did your answer earn the marks?

Question 34

4 marks
Did your answer earn the marks?

Question 35

5 marks
Did your answer earn the marks?

Question 36

8 marks
Did your answer earn the marks?

Question 37

5 marks
Did your answer earn the marks?

Question 38

8 marks
Did your answer earn the marks?

Question 39

6 marks
Did your answer earn the marks?

Question 40

10 marks
Did your answer earn the marks?

Question 41

9 marks
Did your answer earn the marks?

Question 42

8 marks
Did your answer earn the marks?

Question 43

5 marks
Did your answer earn the marks?
Mark my answers

Worksheets are written for Revision Library and come with a full mark scheme; a few English packs quote an out-of-copyright text, and name it on the page. Exam board names and specification codes say which qualification a pack suits: we are not affiliated with, endorsed by or approved by any exam board, and no past-paper question is reproduced here. Rights queries: hello@revisionlibrary.co.uk