Skip to the worksheet
Revision Library
Choose a subject

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

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

This topic is chapter 1 of GCSE Statistics Foundation Topic Workbook 1 and chapter 1 of GCSE Statistics Foundation 10-Minute Tests 1.

Revision Library
revisionlibrary.co.uk
FOUNDATION

1.1 Data Cleaning and Outliers (Foundation)

EDEXCEL 1ST0 · Calculator allowed · about 225 minutes
Total Marks
Name: _______________________________    Date: ____ / ____ / ______
Answer ALL questions. Show all your working.
1
A school office assistant is entering sign-up details for a new coding club into a spreadsheet. The raw data entered is shown below.
EntryNameAge (years)Height
1Aliyah Khan141.58 m
2Ben Ward(not recorded)1.62 m
3Chloe Bird13152 cm
4Chloe Bird13152 cm
(a)State the problem with entry 2.(1)
(b)State the problem with entries 3 and 4.(1)
(c)Entry 3's height is recorded in a different unit (cm) from the rest of the table (m). Explain why this inconsistency could cause a problem when the data is analysed.(1)
(Total for Question 1 is 3 marks)
2
A leisure centre's membership sign-up log was entered by two different receptionists on the same day.
RowName enteredDate of birth
1Mohammed Iqbal03/05/2011
2M. Iqbal03/05/2011
3Sara Owusu21/11/2010
4Leo Fischer09/02/2012
(a)Write down the two row numbers that most likely refer to the same person.(1)
(b)Give two reasons why rows 1 and 2 are likely to refer to the same person, even though the names were not entered identically.(2)
(Total for Question 2 is 3 marks)
3
Two rows in a database both list 'Age: 12, Name: Tom Lee, School: Elm Road'. Write down what type of data problem this is.
(Total for Question 3 is 1 mark)
4
A column of exam marks records one entry as 'ninety-two' while every other entry is a number such as 85. Write down the data-cleaning problem shown here.
(Total for Question 4 is 1 mark)
5
A cafe records the volume of coffee sold in take-away cups one morning. Some volumes were entered in millilitres and some in litres by mistake.
CupABCDE
Volume recorded3500.42500.3400
(a)Explain why the volumes recorded for cups B and D are likely to have been entered in the wrong unit.(1)
(b)Convert the volumes for cups B and D into millilitres, so that all five volumes use consistent units.(2)
(Total for Question 5 is 3 marks)
6
For each statement about data cleaning, write down whether it is True or False.
(i)An outlier is always caused by a mistake when the data was recorded.(1)
(ii)Removing a genuine extreme value from a data set just because it looks unusual can make the data set less representative of what really happened.(1)
(iii)If a data set contains duplicate entries for the same person, the true sample size may be smaller than the number of rows recorded.(1)
(Total for Question 6 is 3 marks)
7
As part of a science experiment, a technician measured the height, in cm, of 12 seedlings. The raw data recorded is shown below.

132, 138, 141, 129, 1350, 136, 140, 133, 137, 134, 139, 131
(a)Write down the value in the list that is most likely to be a data-entry error.(1)
(b)Give a reason why 1350 cm is likely to be a data-entry error rather than a correct measurement, and suggest what the true value is likely to be.(2)
(Total for Question 7 is 3 marks)
8
The 12 seedling heights from Question 7 are used again here.

132, 138, 141, 129, 1350, 136, 140, 133, 137, 134, 139, 131
(a)Work out the range of the 12 values exactly as they were entered, including the value 1350.(2)
(b)The value 1350 is corrected to 135. Work out the range of the corrected data set.(2)
(c)Explain the effect that the data-entry error had on the range.(1)
(Total for Question 8 is 5 marks)
9
A list of 7 shoe sizes is: 5, 6, 6, 7, 7, 7, 25. Work out the median shoe size, including the value 25.
(Total for Question 9 is 2 marks)
10
A list of 7 test scores out of 20 is: 12, 14, 13, 15, 41, 14, 13. Work out the range of the data as recorded, including the value 41.
(Total for Question 10 is 2 marks)
11
The value 41 in Question 10's list is later corrected to 14, since it was a data-entry error. Work out the range of the corrected data set: 12, 14, 13, 15, 14, 14, 13.
(Total for Question 11 is 2 marks)
12
A vet's spreadsheet has two entries for the same day: 'R. Ahmed, 14:00, Consultation' and 'Raj Ahmed, 14:00, Consultation'. Give two reasons why these are likely to be duplicate entries for the same appointment.
(Total for Question 12 is 2 marks)
13
Jasmine is investigating whether pupils in her year group spend more time on homework on weekdays or at weekends. She plans a survey, collects responses using a paper questionnaire, then enters the data into a spreadsheet before working out any averages. (The statistical enquiry cycle has four stages: plan, collect, process, interpret.)
(a)Jasmine notices that some pupils have written their homework time in minutes and others in hours. At which stage of the enquiry cycle should Jasmine correct this problem, before she calculates any averages?(1)
(b)Explain why it is important to clean the data during the process stage before moving on to the interpret stage.(1)
(c)Jasmine also finds that 3 questionnaires have been returned completely blank. Give one appropriate action she could take with these blank responses at the process stage.(1)
(d)State one reason it would NOT be sensible for Jasmine to guess plausible homework times to fill in the 3 blank questionnaires.(1)
(Total for Question 13 is 4 marks)
14
A clinic logs patient appointment dates. Two different members of staff entered the dates in different formats.
PatientDate entered
P04/07/2026
Q2026-07-11
R09/07/2026
S2026-07-03
(a)Write down which format has been used for patient Q's appointment date.(1)
(b)Explain why mixing date formats like this in one column could cause a problem when the appointments are sorted into date order.(1)
(c)Rewrite patient Q's date using the same day/month/year format as the other patients.(1)
(Total for Question 14 is 3 marks)
15
Here are the shoe sizes recorded for 10 people. Valid values are whole numbers from 3 to 12 inclusive.

11, 4, 120, 5, 7, 8, 3, 5, 7, 5

(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 15 is 5 marks)
16
A sample of 8 measurements is 29, 60, 22, 29, 22, 22, 21, 19. The value 60 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 16 is 4 marks)
17
A sample of 10 measurements is 37, 32, 38, 33, 31, 38, 28, 89, 30, 34. The value 89 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 17 is 4 marks)
18
Here are the shoe sizes recorded for 9 people. Valid values are whole numbers from 3 to 12 inclusive.

6, 12, 11, 5, 999, 3, 5, 8, 0

(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 6 measurements is 28, 25, 24, 27, 82, 28. The value 82 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 19 is 4 marks)
20
Here are the ages of club members in years recorded for 10 people. Valid values are whole numbers from 11 to 17 inclusive.

17, 16, 11, 14, 13, 999, 14, 13, 11, 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 20 is 5 marks)
21
A sample of 10 measurements is 38, 37, 39, 38, 41, 38, 41, 96, 33, 38. The value 96 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 21 is 4 marks)
22
Here are the shoe sizes recorded for 10 people. Valid values are whole numbers from 3 to 12 inclusive.

12, 5, 3, 11, 9, 10, 7, 999, 999, 9

(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 22 is 5 marks)
23
A sample of 10 measurements is 23, 58, 26, 26, 21, 23, 25, 20, 23, 23. The value 58 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 23 is 4 marks)
24
A sample of 8 measurements is 24, 22, 24, 19, 16, 15, 64, 19. The value 64 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
Here are the number of hours of sleep per night recorded for 10 people. Valid values are whole numbers from 3 to 12 inclusive.

3, 8, -1, 1, 11, 12, 5, 11, 4, 4

(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 25 is 5 marks)
26
A sample of 6 measurements is 59, 55, 61, 13, 57, 62. The value 13 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 26 is 4 marks)
27
A sample of 6 measurements is 62, 59, 118, 58, 61, 65. The value 118 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 27 is 4 marks)
28
Here are the ages of club members in years recorded for 9 people. Valid values are whole numbers from 11 to 17 inclusive.

170, 13, 11, 999, 12, 16, 17, 17, 16

(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 28 is 5 marks)
29
A sample of 8 measurements is 24, 22, 16, 18, 22, 69, 16, 18. The value 69 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 29 is 4 marks)
30
A sample of 10 measurements is 42, 43, 46, 48, 91, 48, 45, 44, 43, 45. The value 91 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 30 is 4 marks)
31
Here are the ages of club members in years recorded for 8 people. Valid values are whole numbers from 11 to 17 inclusive.

15, 13, 12, 3, 17, 14, 17, 17

(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 8 measurements is 41, 43, 38, 38, 42, 110, 46, 43. The value 110 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 32 is 4 marks)
33
Here are the number of hours of sleep per night recorded for 9 people. Valid values are whole numbers from 3 to 12 inclusive.

-1, 10, 12, 10, 3, 6, 3, -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 33 is 5 marks)
34
A sample of 8 measurements is 46, 52, 54, 53, 46, 51, 47, 105. The value 105 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 34 is 4 marks)
35
Here are the heights of pupils in centimetres recorded for 8 people. Valid values are whole numbers from 130 to 190 inclusive.

0, 143, 178, 182, 182, 167, 176, 143

(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
A sample of 8 measurements is 79, 25, 27, 26, 28, 29, 23, 31. The value 79 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 36 is 4 marks)
37
A sample of 8 measurements is 87, 36, 33, 37, 33, 36, 36, 31. The value 87 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 37 is 4 marks)
38
Here are the shoe sizes recorded for 9 people. Valid values are whole numbers from 3 to 12 inclusive.

1, 6, 12, 9, 10, 1, 4, 6, 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 38 is 5 marks)
39
A sample of 6 measurements is 55, 56, 56, 56, 61, 4. The value 4 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 39 is 4 marks)
40
A sample of 6 measurements is 15, 49, 45, 49, 51, 50. The value 15 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 40 is 4 marks)
41
Here are the shoe sizes recorded for 8 people. Valid values are whole numbers from 3 to 12 inclusive.

6, -1, 11, 8, 120, 4, 4, 9

(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 41 is 5 marks)
42
The dot plot shows the time, in minutes, taken by 13 runners to complete a 5 km fun run.
25 30 35 40 45 50 55 60 Time (minutes)
(a)Write down the modal time.(1)
(b)Write down the outlier in this data set.(1)
(c)Give a reason why 55 minutes is considered an outlier.(1)
(Total for Question 42 is 3 marks)
43
A sample of 6 measurements is 70, 23, 16, 24, 22, 21. The value 70 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 43 is 4 marks)
44
A sample of 8 measurements is 41, 43, 43, 35, 3, 43, 41, 36. The value 3 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 44 is 4 marks)
45
A weather station records the daily maximum temperature, in °C, in a town for 14 days in July.

22, 23, 21, 24, 23, 22, 38, 23, 24, 22, 21, 23, 24, 22
(a)Write down the value in the data set that could be considered an outlier.(1)
(b)Give one possible genuine explanation for why the temperature was 38°C on that day (i.e. a reason it might NOT be a data-entry error).(1)
(c)Explain why the weather station should not automatically remove this value from the data set.(1)
(Total for Question 45 is 3 marks)
46
A vet records the weight, in kg, of 8 puppies at a check-up. One entry is missing.
PuppyABCDEFGH
Weight (kg)4.23.9(missing)4.54.03.84.14.3
(a)Give one appropriate way the vet could deal with the missing weight for puppy C.(1)
(b)Give one disadvantage of simply deleting puppy C's record from the data set instead.(1)
(c)The vet decides to estimate the missing value using the mean weight of the other 7 puppies. Work out this estimate.(2)
(Total for Question 46 is 4 marks)
47
20 people were asked to name their favourite colour. The raw responses recorded by a volunteer are listed below.

Blue, blue, Green, BLUE, Red, green, Blu, Blue, red, Green, Blue, RED, Green, blue, Red, Greeen, Blue, red, Blue, green
ColourBlueGreenRed
Frequency???
(a)Give two reasons why this list of responses needs to be cleaned before it can be used to make a frequency table.(2)
(b)After cleaning the data, complete the frequency table above for the three colours.(2)
(Total for Question 47 is 4 marks)
48
Using the same 7 shoe sizes from Question 9 (5, 6, 6, 7, 7, 7, 25), work out the mean shoe size.
(Total for Question 48 is 2 marks)
49
A dataset of 6 room temperatures, in °C, is: 21, 22, 20, 23, 21, 2. Explain why 2°C is unlikely to be a genuine room temperature reading, and suggest what digit was probably missed out when it was typed.
(Total for Question 49 is 2 marks)
50
A gym's sign-in sheet for one evening class lists 10 entries, taken automatically from members scanning their cards.
RowNameMember ID
1Grace OduyaM1042
2K. YilmazM1077
3Grace OduyaM1042
4Daniel CrossM1055
5Kerem YilmazM1077
6Priti ShahM1061
7Daniel CrossM1055
8Amir BelloM1089
9Grace OduyaM1042
10Priti ShahM1061
(a)Work out how many unique members actually attended the class.(2)
(b)Write down the Member ID that was recorded the greatest number of times, and state how many times it appears.(2)
(Total for Question 50 is 4 marks)
51
The weekly pocket money, in £, of 9 pupils in a class is recorded below.

£5, £6, £5, £7, £6, £5, £6, £7, £45
(a)Work out the mean and the median weekly pocket money for all 9 pupils.(3)
(b)One pupil's pocket money, £45, is much higher than the rest. Excluding the £45, work out the new mean and new median for the remaining 8 pupils.(3)
(c)Comment on the effect that removing the £45 had on the mean compared with its effect on the median.(1)
(Total for Question 51 is 7 marks)
52
The weekly earnings, in pounds, of 9 employees at a small cafe are: 310, 320, 305, 315, 300, 325, 318, 312, 980. One employee is the manager, who genuinely earns much more than the others (this is not an error). Work out the median weekly earnings and the mean weekly earnings for all 9 employees, and state which average better represents the typical earnings, giving a reason.
(Total for Question 52 is 3 marks)
53
A teacher records the time, in minutes, that 10 students take to complete a test: 32, 35, 33, 34, 36, 33, 35, 34, 32, 95. Give a reason why 95 minutes might be a genuine time rather than a data-entry error, state one appropriate action the teacher could take with this value if it is confirmed genuine, and explain why removing a confirmed genuine value would not be appropriate.
(Total for Question 53 is 3 marks)
54
The number of pints of milk delivered to 11 houses on a street one morning is recorded below, in ascending order.

2, 2, 3, 3, 4, 4, 4, 5, 5, 6, 15
(a)Write down the median number of pints delivered.(1)
(b)Find the lower quartile (Q1) and the upper quartile (Q3) of the data.(2)
(c)Work out the interquartile range (IQR).(1)
(d)A value is an outlier if it is lower than Q1 - 1.5 x IQR or higher than Q3 + 1.5 x IQR. Work out these two boundaries.(2)
(e)Use your boundaries to decide whether the delivery of 15 pints is an outlier. Give a reason.(1)
(f)Mark the lower and upper boundaries on the number line below, and circle any data value(s) that are outliers.(1)
0 2 4 6 8 10 12 14 16 Number of pints
(Total for Question 54 is 8 marks)
55
A researcher is investigating the resting heart rate, in beats per minute (bpm), of 9 volunteers, as part of a health survey. The raw data collected is shown below (this is the process stage of the statistical enquiry cycle).
Row123456789
Heart rate (bpm)6871(missing)70690726913270
(a)Row 3 has a missing heart rate. Suggest one appropriate way the researcher could deal with this missing value at the process stage.(1)
(b)The heart rate for row 5 is recorded as 690 bpm. Explain why this is almost certainly a data-entry error, and suggest what the true value is likely to be.(2)
(c)The heart rate for row 8 is recorded as 132 bpm. Give one reason why this value might be a genuine reading rather than a data-entry error.(1)
(d)Explain why it would not be appropriate to treat rows 5 and 8 in the same way when cleaning this data set.(1)
(e)Row 3's true value is later found to be 70 bpm, and row 5 has been corrected to 69 bpm. Using these corrected values, work out the mean heart rate of all 9 volunteers, including the genuine value of 132 bpm.(2)
(f)Without volunteer 8's reading of 132 bpm, the mean of the remaining 8 volunteers would be 69.9 bpm (1 dp). Comment on the effect that including the genuine value of 132 bpm has on the mean.(1)
(Total for Question 55 is 8 marks)
Mark scheme · 1.1 Data Cleaning and Outliers (Foundation)

Question 1

  • (a) identifies that the age has not been recorded / is missing oeB1
  • (a) Answer: Ben Ward's age is missing (not recorded).
  • (b) identifies that entries 3 and 4 are duplicate entries for the same person oeB1
  • (b) Answer: Entries 3 and 4 are duplicates (the same person, Chloe Bird, has been entered twice).
  • (c) explains that mixing units could lead to heights being compared or averaged incorrectly (e.g. 152 could be mistaken for 152 m) oeB1
  • (c) Answer: If the units are not made consistent, 152 could wrongly be treated as if it were in metres (152 m) when calculating an average or comparing heights, giving a meaningless result.

Question 2

  • (a) 1 and 2 caoB1
  • (a) Answer: Rows 1 and 2
  • (b) both rows have the same date of birth (03/05/2011)B1
  • (b) 'M. Iqbal' is an abbreviated/shortened version of the name 'Mohammed Iqbal' oeB1
  • (b) Answer: Both rows share the same date of birth, and 'M. Iqbal' is just a shortened version of the full name 'Mohammed Iqbal'.

Question 3

  • duplicate entry / the same record entered twice oeB1
  • Answer: A duplicate entry: the same record has been entered twice.

Question 4

  • the value is recorded as text/words instead of a number, so it is in an inconsistent format oeB1
  • Answer: The value is written as words instead of a number, so it is in an inconsistent format and will not be read as numeric data.

Question 5

  • (a) 0.4 and 0.3 millilitres would be an impossibly small amount of coffee, so these must have been recorded in litres instead oeB1
  • (a) Answer: 0.4 ml and 0.3 ml would be far too small for a cup of coffee, so these values must actually be in litres, not millilitres.
  • (b) multiplies each value by 1000 oeM1
  • (b) 400 ml and 300 ml, both correctA1
  • (b) Answer: Cup B = 400 ml, Cup D = 300 ml

Question 6

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

Question 7

  • (a) 1350 caoB1
  • (a) Answer: 1350
  • (b) 1350 cm (13.5 m) is an impossible height for a seedling, so it cannot be a genuine measurement oeB1
  • (b) 135 cm (an extra 0 was probably typed, or the decimal point misplaced) oeB1
  • (b) Answer: 1350 cm is impossible for a seedling, so it is a data-entry error; the true value was probably 135 cm.

Question 8

  • (a) 1350 - 129 oeM1
  • (a) 1221 caoA1
  • (a) Answer: 1221 cm
  • (b) 141 - 129 oeM1
  • (b) 12 caoA1
  • (b) Answer: 12 cm
  • (c) the error made the range far larger than it should be (1221 instead of 12), because the range only uses the two extreme values, so a single wrong value distorts it heavily oeB1
  • (c) Answer: The error made the range hugely inflated (1221 cm instead of the true 12 cm), because the range depends only on the biggest and smallest values, so one incorrect extreme value badly distorts it.

Question 9

  • identifies the data is already in order and finds the middle (4th) value oeM1
  • 7 caoA1
  • Answer: 7

Question 10

  • 41 - 12 oeM1
  • 29 caoA1
  • Answer: 29

Question 11

  • 15 - 12 oeM1
  • 3 caoA1
  • Answer: 3

Question 12

  • both entries share the same time, 14:00 oeB1
  • 'R. Ahmed' is a shortened form of 'Raj Ahmed' oeB1
  • Answer: Both entries share the same time (14:00), and 'R. Ahmed' is simply a shortened version of the name 'Raj Ahmed'.

Question 13

  • (a) process caoB1
  • (a) Answer: The process stage
  • (b) if inconsistent or incorrect data is analysed, the averages/conclusions calculated would be wrong or misleading, so cleaning first ensures the interpretation is based on accurate, comparable data oeB1
  • (b) Answer: If Jasmine analyses uncleaned data, her averages and conclusions could be wrong or misleading, so the data must be made accurate and consistent before it is interpreted.
  • (c) remove/exclude them from the data set, since they contain no usable information oeB1
  • (c) Answer: Remove the 3 blank questionnaires from the data set, since they contain no usable information.
  • (d) guessed values are not genuine data and could bias/distort the results, as they may not reflect what those pupils actually do oeB1
  • (d) Answer: Guessed values would not be genuine data and could bias the results, since they may not reflect what those pupils actually do.

Question 14

  • (a) year-month-day (ISO) format oeB1
  • (a) Answer: Year-month-day format (2026-07-11)
  • (b) a computer or reader could misread which part is the day and which is the month, so the appointments could be sorted into the wrong order oeB1
  • (b) Answer: A date such as 04/07/2026 could be misread as the 4th of July or as April 7th depending on the format expected, so mixed formats could sort the appointments in the wrong order.
  • (c) 11/07/2026 caoB1
  • (c) Answer: 11/07/2026

Question 15

  • invalid values 120B1
  • sum of all values divided by 10M1
  • 17.5 caoA1
  • sum of valid values divided by 9M1
  • 6.1 caoA1
  • Answer: (a) 120; (b) 17.5; (c) 6.1

Question 16

  • mean 28, median 22B1
  • removes 60 and recalculatesM1
  • mean 23.4, median 22A1
  • the medianB1
  • Answer: (a) mean 28, median 22; (b) mean 23.4, median 22; (c) median

Question 17

  • mean 39, median 33.5B1
  • removes 89 and recalculatesM1
  • mean 33.4, median 33A1
  • the medianB1
  • Answer: (a) mean 39, median 33.5; (b) mean 33.4, median 33; (c) median

Question 18

  • invalid values 999, 0B1
  • sum of all values divided by 9M1
  • 116.6 caoA1
  • sum of valid values divided by 7M1
  • 7.1 caoA1
  • Answer: (a) 999, 0; (b) 116.6; (c) 7.1

Question 19

  • mean 35.7, median 27.5B1
  • removes 82 and recalculatesM1
  • mean 26.4, median 27A1
  • the medianB1
  • Answer: (a) mean 35.7, median 27.5; (b) mean 26.4, median 27; (c) median

Question 20

  • invalid values 999B1
  • sum of all values divided by 10M1
  • 111.9 caoA1
  • sum of valid values divided by 9M1
  • 13.3 caoA1
  • Answer: (a) 999; (b) 111.9; (c) 13.3

Question 21

  • mean 43.9, median 38B1
  • removes 96 and recalculatesM1
  • mean 38.1, median 38A1
  • the medianB1
  • Answer: (a) mean 43.9, median 38; (b) mean 38.1, median 38; (c) median

Question 22

  • invalid values 999, 999B1
  • sum of all values divided by 10M1
  • 206.4 caoA1
  • sum of valid values divided by 8M1
  • 8.3 caoA1
  • Answer: (a) 999, 999; (b) 206.4; (c) 8.3

Question 23

  • mean 26.8, median 23B1
  • removes 58 and recalculatesM1
  • mean 23.3, median 23A1
  • the medianB1
  • Answer: (a) mean 26.8, median 23; (b) mean 23.3, median 23; (c) median

Question 24

  • mean 25.4, median 20.5B1
  • removes 64 and recalculatesM1
  • mean 19.9, median 19A1
  • the medianB1
  • Answer: (a) mean 25.4, median 20.5; (b) mean 19.9, median 19; (c) median

Question 25

  • invalid values -1, 1B1
  • sum of all values divided by 10M1
  • 5.8 caoA1
  • sum of valid values divided by 8M1
  • 7.3 caoA1
  • Answer: (a) -1, 1; (b) 5.8; (c) 7.3

Question 26

  • mean 51.2, median 58B1
  • removes 13 and recalculatesM1
  • mean 58.8, median 59A1
  • the medianB1
  • Answer: (a) mean 51.2, median 58; (b) mean 58.8, median 59; (c) median

Question 27

  • mean 70.5, median 61.5B1
  • removes 118 and recalculatesM1
  • mean 61, median 61A1
  • the medianB1
  • Answer: (a) mean 70.5, median 61.5; (b) mean 61, median 61; (c) median

Question 28

  • invalid values 170, 999B1
  • sum of all values divided by 9M1
  • 141.2 caoA1
  • sum of valid values divided by 7M1
  • 14.6 caoA1
  • Answer: (a) 170, 999; (b) 141.2; (c) 14.6

Question 29

  • mean 25.6, median 20B1
  • removes 69 and recalculatesM1
  • mean 19.4, median 18A1
  • the medianB1
  • Answer: (a) mean 25.6, median 20; (b) mean 19.4, median 18; (c) median

Question 30

  • mean 49.5, median 45B1
  • removes 91 and recalculatesM1
  • mean 44.9, median 45A1
  • the medianB1
  • Answer: (a) mean 49.5, median 45; (b) mean 44.9, median 45; (c) median

Question 31

  • invalid values 3B1
  • sum of all values divided by 8M1
  • 13.5 caoA1
  • sum of valid values divided by 7M1
  • 15 caoA1
  • Answer: (a) 3; (b) 13.5; (c) 15

Question 32

  • mean 50.1, median 42.5B1
  • removes 110 and recalculatesM1
  • mean 41.6, median 42A1
  • the medianB1
  • Answer: (a) mean 50.1, median 42.5; (b) mean 41.6, median 42; (c) median

Question 33

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

Question 34

  • mean 56.8, median 51.5B1
  • removes 105 and recalculatesM1
  • mean 49.9, median 51A1
  • the medianB1
  • Answer: (a) mean 56.8, median 51.5; (b) mean 49.9, median 51; (c) median

Question 35

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

Question 36

  • mean 33.5, median 27.5B1
  • removes 79 and recalculatesM1
  • mean 27, median 27A1
  • the medianB1
  • Answer: (a) mean 33.5, median 27.5; (b) mean 27, median 27; (c) median

Question 37

  • mean 41.1, median 36B1
  • removes 87 and recalculatesM1
  • mean 34.6, median 36A1
  • the medianB1
  • Answer: (a) mean 41.1, median 36; (b) mean 34.6, median 36; (c) median

Question 38

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

Question 39

  • mean 48, median 56B1
  • removes 4 and recalculatesM1
  • mean 56.8, median 56A1
  • the medianB1
  • Answer: (a) mean 48, median 56; (b) mean 56.8, median 56; (c) median

Question 40

  • mean 43.2, median 49B1
  • removes 15 and recalculatesM1
  • mean 48.8, median 49A1
  • the medianB1
  • Answer: (a) mean 43.2, median 49; (b) mean 48.8, median 49; (c) median

Question 41

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

Question 42

  • (a) 30 caoB1
  • (a) Answer: 30 minutes
  • (b) 55 caoB1
  • (b) Answer: 55 minutes
  • (c) 55 is much greater than (isolated from) the rest of the data, which is clustered between 28 and 34 minutes oeB1
  • (c) Answer: 55 minutes is far higher than every other runner's time, which are all clustered between 28 and 34 minutes.

Question 43

  • mean 29.3, median 22.5B1
  • removes 70 and recalculatesM1
  • mean 21.2, median 22A1
  • the medianB1
  • Answer: (a) mean 29.3, median 22.5; (b) mean 21.2, median 22; (c) median

Question 44

  • mean 35.6, median 41B1
  • removes 3 and recalculatesM1
  • mean 40.3, median 41A1
  • the medianB1
  • Answer: (a) mean 35.6, median 41; (b) mean 40.3, median 41; (c) median

Question 45

  • (a) 38 caoB1
  • (a) Answer: 38°C
  • (b) a genuine, unusually hot day / short heatwave could have occurred oeB1
  • (b) Answer: There may genuinely have been an unusually hot day (e.g. a brief heatwave), so the reading could be correct.
  • (c) the value may be a genuine, real reading, and removing it without checking would lose important information / make the data set unrepresentative; it should only be removed once checked against other records oeB1
  • (c) Answer: 38°C might be a genuine reading, so removing it straight away could hide a real weather event and make the data set less accurate; it should only be removed if checking confirms it was an error.

Question 46

  • (a) any sensible strategy, e.g. re-weigh puppy C to get the true value, or estimate/impute using the mean of the other puppies' weights oeB1
  • (a) Answer: Re-weigh puppy C to find the true value, or estimate the missing weight using the mean of the other 7 puppies.
  • (b) loses information about puppy C / reduces the sample size, which could make the data set less representative oeB1
  • (b) Answer: Deleting the record loses all information about puppy C and reduces the sample size, which could make the results less representative.
  • (c) (4.2+3.9+4.5+4.0+3.8+4.1+4.3) / 7 oeM1
  • (c) 4.11 kg (awrt 4.1) caoA1
  • (c) Answer: 4.11 kg (awrt 4.1 kg)

Question 47

  • (a) inconsistent capitalisation, e.g. Blue, BLUE and blue are all recorded differently oeB1
  • (a) inconsistent spelling / typing errors, e.g. 'Blu' and 'Greeen' instead of 'Blue' and 'Green' oeB1
  • (a) Answer: The responses use inconsistent capitalisation (Blue/BLUE/blue) and inconsistent spelling (Blu, Greeen).
  • (b) correctly groups all the spelling/capitalisation variants into the three colours oeM1
  • (b) Blue = 9, Green = 6, Red = 5, all correctA1
  • (b) Answer: Blue = 9, Green = 6, Red = 5

Question 48

  • (5+6+6+7+7+7+25) / 7 oeM1
  • 9 caoA1
  • Answer: 9

Question 49

  • 2°C is far too cold for an indoor room, unlike the rest of the data (20 to 23) oeB1
  • a digit was probably missed out, so the true reading was likely in the 20s like the rest of the data, e.g. 22 (leading 2 dropped) or 21, 20 or 23 (second digit dropped); any value from 20 to 29 with the missing digit identified, oeB1
  • Answer: 2°C is far too cold to be a genuine indoor room temperature; a digit was probably dropped, so the true value was likely in the 20s, e.g. 22°C or 21°C.

Question 50

  • (a) groups the 10 rows by Member ID oeM1
  • (a) 5 caoA1
  • (a) Answer: 5 unique members
  • (b) M1042 caoB1
  • (b) 3 (times) caoB1
  • (b) Answer: M1042, recorded 3 times

Question 51

  • (a) 5+6+5+7+6+5+6+7+45 (= 92), oeM1
  • (a) mean = £10.22 (awrt 10.22) caoA1
  • (a) median = £6 caoB1
  • (a) Answer: Mean = £10.22 (awrt), median = £6
  • (b) 5+6+5+7+6+5+6+7 (= 47), oeM1
  • (b) mean = £5.875 (= £5.88 to 2 dp) caoA1
  • (b) median = £6 caoB1
  • (b) Answer: Mean = £5.875 (= £5.88 to 2 dp), median = £6
  • (c) the mean changed a lot (from £10.22 to £5.88 approx) but the median stayed the same (£6), showing the median is much less affected by (more resistant to) an outlier than the mean oeB1
  • (c) Answer: The mean fell a lot (from about £10.22 to about £5.88) but the median stayed exactly the same (£6), showing the median is far less affected by an outlier than the mean.

Question 52

  • median = 315 caoB1
  • mean = 387.22 (awrt) caoB1
  • median is more representative, since the manager's high (genuine) salary pulls the mean up oeB1
  • Answer: Median = £315, mean = £387.22 (awrt); the median better represents typical earnings because the manager's high salary pulls the mean up.

Question 53

  • reason 95 minutes could be genuine, e.g. the student may have needed extra time or has additional learning needs oeB1
  • appropriate action, e.g. keep the value and note it separately rather than deleting it oeB1
  • removing a genuine value would lose real information and make the data set less representative oeB1
  • Answer: 95 minutes could genuinely reflect a student needing extra time; the teacher should keep the value (noting it separately) rather than delete it, since removing a confirmed genuine value would lose real information and make the data less representative.

Question 54

  • (a) 4 caoB1
  • (a) Answer: 4
  • (b) Q1 = 3 caoB1
  • (b) Q3 = 5 caoB1
  • (b) Answer: Q1 = 3, Q3 = 5
  • (c) 2 (ft from Q3 - Q1)B1
  • (c) Answer: 2
  • (d) 3 - 1.5x2 and 5 + 1.5x2, oeM1
  • (d) 0 and 8, both correctA1
  • (d) Answer: Lower boundary = 0, upper boundary = 8
  • (e) yes, because 15 is greater than the upper boundary of 8 oeB1
  • (e) Answer: Yes, 15 is an outlier because it is greater than the upper boundary of 8.
  • (f) boundaries marked at 0 and 8 (ft), and 15 correctly circled as the outlierB1
  • (f) Answer: Boundaries marked at 0 and 8; the value 15 is circled as the outlier.

Question 55

  • (a) any sensible strategy, e.g. contact volunteer 3 to get the true reading, or estimate it using the mean/median of the other readings oeB1
  • (a) Answer: Contact volunteer 3 to get the true reading, or estimate the missing value using the mean of the other readings.
  • (b) 690 bpm is far higher than a resting heart rate could ever realistically be, so a digit has probably been added, or a decimal point missed, by mistake oeB1
  • (b) 69 bpm caoB1
  • (b) Answer: 690 bpm is impossible for a resting heart rate, so it is a data-entry error; the true value was probably 69 bpm.
  • (c) the volunteer may have just been exercising or feeling anxious, which would genuinely raise their heart rate; 132 bpm, unlike 690 bpm, is a realistic value for a human heart rate oeB1
  • (c) Answer: The volunteer may have just been exercising or feeling anxious, which would genuinely raise their heart rate; unlike 690 bpm, 132 bpm is a realistic reading.
  • (d) 690 is impossible and must be corrected/treated as an error, whereas 132 is a possible genuine reading and should be kept (and investigated) rather than deleted or changed oeB1
  • (d) Answer: Row 5 (690 bpm) is impossible and must be corrected as an error, but row 8 (132 bpm) is a possible genuine reading, so it should be kept rather than deleted or changed in the same way.
  • (e) 68+71+70+70+69+72+69+132+70 (= 691), oeM1
  • (e) 76.8 bpm (awrt 76.8) caoA1
  • (e) Answer: 76.8 bpm (awrt)
  • (f) including 132 bpm raises the mean noticeably (from about 69.9 bpm to about 76.8 bpm), showing that even a genuine unusual value can pull the mean up considerably oeB1
  • (f) Answer: Including 132 bpm raises the mean from about 69.9 bpm to about 76.8 bpm, showing that even a genuine extreme value can noticeably affect the mean.

Mark your answers

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

Question 1

3 marks
Did your answer earn the marks?

Question 2

3 marks
Did your answer earn the marks?

Question 3

1 mark
Did your answer earn the marks?

Question 4

1 mark
Did your answer earn the marks?

Question 5

3 marks
Did your answer earn the marks?

Question 6

3 marks
Did your answer earn the marks?

Question 7

3 marks
Did your answer earn the marks?

Question 8

5 marks
Did your answer earn the marks?

Question 9

2 marks

Question 10

2 marks

Question 11

2 marks

Question 12

2 marks
Did your answer earn the marks?

Question 13

4 marks
Did your answer earn the marks?

Question 14

3 marks
Did your answer earn the marks?

Question 15

5 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

5 marks
Did your answer earn the marks?

Question 26

4 marks
Did your answer earn the marks?

Question 27

4 marks
Did your answer earn the marks?

Question 28

5 marks
Did your answer earn the marks?

Question 29

4 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

5 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

4 marks
Did your answer earn the marks?

Question 37

4 marks
Did your answer earn the marks?

Question 38

5 marks
Did your answer earn the marks?

Question 39

4 marks
Did your answer earn the marks?

Question 40

4 marks
Did your answer earn the marks?

Question 41

5 marks
Did your answer earn the marks?

Question 42

3 marks
Did your answer earn the marks?

Question 43

4 marks
Did your answer earn the marks?

Question 44

4 marks
Did your answer earn the marks?

Question 45

3 marks
Did your answer earn the marks?

Question 46

4 marks
Did your answer earn the marks?

Question 47

4 marks
Did your answer earn the marks?

Question 48

2 marks

Question 49

2 marks
Did your answer earn the marks?

Question 50

4 marks
Did your answer earn the marks?

Question 51

7 marks
Did your answer earn the marks?

Question 52

3 marks
Did your answer earn the marks?

Question 53

3 marks
Did your answer earn the marks?

Question 54

8 marks
Did your answer earn the marks?

Question 55

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

Keep going

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