Level:
Correct: 0
Incorrect: 0
Marks: 0/0
Exam Practice
Course:
Topics:
Edexcel GCSE Statistics (Higher Paper 2) Smart practice A mixed round aimed at your weak spots
Unit 1
The statistical enquiry cycle
Statistical enquiry cycle stages 1 and 2; (a) Planning: 1a.01, 1a.02, 1a.03
Statistical enquiry cycle: planning and collecting
Statistical enquiry cycle stages 3, 4 and 5
Statistical enquiry cycle: interpreting and evaluating
Unit 2
The collection of data
(b) Types of data: 1b.01, 1b.02, 1b.03
Types of data and variables
(b) Types of data: 1b.04; (d) Collecting data: 1d.01, 1d.02
Primary and secondary data, reliability and validity
(c) Population and sampling: 1c.01, 1c.02, 1c.03
Populations, sampling frames and non-random sampling
(c) Population and sampling: 1c.04, 1c.05
Random and systematic sampling
(c) Population and sampling: 1c.06
Stratified sampling
(d) Collecting data: 1d.05, 1d.06
Problems with collected data and cleaning data
Unit 3
Processing, representing and analysing data
(a) Tabulation, diagrams and representation: 2a.01
Tabulation, tallies, pictograms and two-way tables
(a) Tabulation, diagrams and representation: 2a.01, 2a.02
Pie charts and comparative pie charts
(a) Tabulation, diagrams and representation: 2a.01
Stem and leaf diagrams
(a) Tabulation, diagrams and representation: 2a.02
Population pyramids, choropleth maps and 2D and 3D diagrams
(a) Tabulation, diagrams and representation: 2a.04
Histograms and frequency density
(a) Tabulation, diagrams and representation: 2a.05, 2a.06, 2a.07, 2a.08
Choosing representations and misleading diagrams
(a) Tabulation, diagrams and representation: 2a.09, 2a.10
Skewness
(b) Measures of central tendency: 2b.01, 2b.02, 2b.03
Mode, median and mean
(b) Measures of central tendency: 2b.01
Weighted mean and geometric mean
(c) Measures of dispersion: 2c.01, 2c.06
Standard deviation and standardised scores
(a) Tabulation, diagrams and representation: 2a.03; (c) Measures of dispersion: 2c.02, 2c.03
Box plots and outliers
(b) Measures of central tendency: 2b.03; (c) Measures of dispersion: 2c.04, 2c.05
Comparing distributions
(d) Further summary statistics: 2d.01
Index numbers
(d) Further summary statistics: 2d.02
Rates of change
(e) Scatter diagrams and correlation: 2e.01, 2e.02, 2e.03
Scatter diagrams, correlation and causation
(e) Scatter diagrams and correlation: 2e.04
Lines of best fit and regression lines
(e) Scatter diagrams and correlation: 2e.05, 2e.06, 2e.07, 2e.08
Spearman's rank and product moment correlation coefficients
(f) Time series: 2f.01, 2f.02; (b) 2b.01 mean seasonal variation
Time series, moving averages and seasonal variation
(g) Quality assurance: 2g.01, 2g.02
Quality assurance and control charts
(h) Estimation: 2h.01, 2h.02, 2h.03
Estimation, sample size and capture-recapture
Unit 4
Probability
3. Probability: 3p.01, 3p.02, 3p.03, 3p.04
Probability, expected frequency and risk
3. Probability: 3p.05, 3p.06, 3p.10
Experimental and theoretical probability and bias
3. Probability: 3p.11
Binomial distribution
3. Probability: 3p.12, 3p.13
Normal distribution
Avg
score:
–
Topics
done:
0/40

Problems with collected data and cleaning data

Practise 13 exam-style questions on Problems with collected data and cleaning data for Edexcel GCSE Statistics (Higher Paper 2). Write your answer as you would in the exam and get it marked in seconds against the mark scheme, point by point, with the Study Helper on hand if you get stuck.

  • 13 questions
  • 1–6 marks each
  • Instant marking
  • No sign-up needed
13 questions, marked as you go

Sample questions with model answers

Here are 4 of the questions in this topic, each with a model answer, an explanation of why it earns the marks and the mark scheme an examiner would use.

Question 1

1 mark

Lily has a spreadsheet with each student's name in column A and the same student's test mark in column B. She selects only column B and sorts the marks from highest to lowest.

Explain what problem this causes.

Model answer

Only the marks have been sorted, so the marks have moved but the names in column A have not. The marks are no longer next to the students who scored them, so every record may now be wrong. Lily should undo the sort and sort both columns together.

Explanation

Each row of a spreadsheet is one record, and the values in a row must stay together. Sorting one column on its own breaks every record, a common spreadsheet error that is easy to miss because the sorted column looks correct. Data that end up in the wrong order like this must be put right before processing.

Mark scheme
  1. 1 mark

    B1 for the marks have been moved but the names have not, so the marks are no longer next to the correct students (each record has been split up and the data are now in the wrong order)

    oe. Accept 'the names and marks no longer match'. B0 for 'the marks are now in order' (that is what she wanted) or 'the data are sorted wrongly' with no reference to the names.

Question 2

2 marks

A survey asked 200 people, 'What is the main way you travel to work?' There were five response boxes. When Asha enters the data, she finds that 14 people ticked two boxes.

Asha plans to count each of these 14 people twice, once for each box they ticked, and then show the results in a pie chart.

Explain why Asha's plan is not appropriate.
Suggest a better way to deal with these 14 responses.

Model answer

The question asked for each person's main way of travelling, so a person who ticked two boxes has not given a valid answer. Counting each of them twice would give 214 answers from 200 people, so the pie chart would count 14 people twice and would not show the main ways people travel.

A better way is to record these 14 responses as invalid, leave them out of the pie chart and state that 14 responses were left out. (Or show them as a separate category, 'More than one way'.)

Explanation

Responses that do not follow the instructions are a common problem in collected data. They should be handled in a way that does not make up answers: excluded and reported, given their own category, or followed up. Every person should be counted once, so the frequencies still add up to the number of people.

Mark scheme
  1. 1 mark

    B1 for the question asked for one main way, so these responses do not give a valid answer, and counting them twice gives 214 answers for 200 people, so the pie chart would not show the main ways people travel (14 people counted twice)

    oe. Accept 'the frequencies will add up to 214, not 200' or 'some people will be counted twice'. B0 for 'the pie chart will be wrong' with no reason.

  2. 1 mark

    B1 for a better way, e.g. record these 14 responses as invalid and leave them out of the pie chart, saying how many were left out / put them in a separate category such as 'More than one way' / contact the people to ask which is their main way

    oe. This mark is independent of the first. B0 for 'choose one of the two boxes at random' or 'count only the first box ticked' (this makes up their answer). B0 for 'change the questionnaire' (that does not deal with the data already collected).

Question 3

3 marks

Jo is comparing the populations of two towns, A and B. She has data from two different sources. The table shows the numbers of people in each age group.

Jo wants to find the total number of people aged 16 to 64 in the two towns together.

Explain why she cannot do this from the data in the table.
Work out the percentage of the people in the two towns together who are aged 65 and over. Give your answer correct to 1 decimal place.

Table with columns "Town A age (years)", "Number of people", "Town B age (years)", "Number of people". Town A age (years): 0 to 15; Number of people: 4820; Town B age (years): 0 to 17; Number of people: 3960 | Town A age (years): 16 to 64; Number of people: 15 260; Town B age (years): 18 to 64; Number of people: 11 470 | Town A age (years): 65 and over; Number of people: 5120; Town B age (years): 65 and over; Number of people: 2970 | Town A age (years): Total; Number of people: 25 200; Town B age (years): Total; Number of people: 18 400.

Model answer

The two sources use different age groups. In Town B, people aged 16 and 17 are in the 0 to 17 group, so Jo does not know how many people in Town B are aged 16 to 64. She cannot add the groups together.

Aged 65 and over: \(5120 + 2970 = 8090\)
Total population: \(25200 + 18400 = 43600\)
Percentage: \(\dfrac{8090}{43600} \times 100 = 18.55...\%\), which is 18.6% (1 dp)

Explanation

Data from different sources often use different categories, units or definitions, so they must be checked before they are combined: only groups that match exactly (here 65 and over) can be added. For the combined percentage, add the counts first and then divide by the combined total; taking the mean of the two towns' percentages ignores their different sizes.

Mark scheme
  1. 1 mark

    B1 for the age groups are different in the two sources: Town B's 16- and 17-year-olds are in its 0 to 17 group, so the number aged 16 to 64 in Town B is not known

    oe. Accept 'the two towns use different age groups, so the groups cannot be added' or 'Town B has no 16 to 64 group'. B0 for 'the data are from different sources' on its own, or 'the towns are different sizes'. Answer-only rule for this question: A correct answer with no working scores full marks.

  2. 1 mark

    M1 for \(\dfrac{5120 + 2970}{25200 + 18400} \times 100\) oe (\(\dfrac{8090}{43600}\))

    oe. This mark is independent of the first. Finding the two percentages separately (20.3% and 16.1%) and taking their mean (18.2%) scores M0, because the towns are different sizes.

  3. 1 mark

    A1 for 18.6(%)

    Accept 18.6 or a more accurate value (18.55...). 18.5 with no more accurate value seen scores M1A0. A correct answer with no working scores full marks. 18.2% scores M0A0.

Question 4

4 marks

Nadia weighs 20 apples. She types the masses, in grams, into a spreadsheet, which gives these summary statistics for the masses as she typed them.

\(n = 20\)   \(\sum x = 2931.2\)   \(\sum x^2 = 449193.04\)

Nadia then notices that one mass of 152 g has been typed as 15.2 g. All the other masses are correct.

Work out the correct mean and the correct standard deviation of the masses of the 20 apples. Give your answers correct to 1 decimal place.

You may use standard deviation \(= \sqrt{\dfrac{\sum x^2}{n} - \left(\dfrac{\sum x}{n}\right)^2}\)

Model answer

Correct total: \(\sum x = 2931.2 - 15.2 + 152 = 3068\)
Correct mean: \(\dfrac{3068}{20} = 153.4\) g

Correct sum of squares: \(\sum x^2 = 449193.04 - 15.2^2 + 152^2 = 449193.04 - 231.04 + 23104 = 472066\)
Standard deviation \(= \sqrt{\dfrac{472066}{20} - 153.4^2} = \sqrt{23603.3 - 23531.56} = \sqrt{71.74} = 8.469...\)

Mean = 153.4 g, standard deviation = 8.5 g (1 dp)

Explanation

To correct summary statistics without the raw data, take out the wrong value and put in the right one, in both \(\sum x\) and \(\sum x^2\) (remember to square both values). Then use the corrected totals in the formulae. One typing slip made a big difference: the uncorrected standard deviation was 31.3 g. Keep the mean exact in the formula; rounding it to 153 changes the standard deviation a lot.

Mark scheme
  1. 1 mark

    M1 for the correct total \(2931.2 - 15.2 + 152\) (= 3068) oe

    oe, e.g. \(2931.2 + 136.8\). Answer-only rule for this question: A correct answer with no working scores full marks.

  2. 1 mark

    A1 for mean = 153.4 (g)

    cao. Implied by \(\dfrac{3068}{20}\).

  3. 1 mark

    M1 for the correct sum of squares \(449193.04 - 15.2^2 + 152^2\) (= 472066) oe and its use in \(\sqrt{\dfrac{472066}{20} - 153.4^2}\)

    oe. ft their corrected mean. Using the uncorrected \(\sum x^2\) with the corrected mean scores M0. Implied by \(\sqrt{71.74}\).

  4. 1 mark

    A1 for standard deviation = 8.5 (g)

    awrt 8.5 (8.469...). Accept 8.47 or better. A correct answer with no working scores full marks. Dividing by \(n - 1\) gives 8.69: M1A0. Using a mean rounded to 153 gives 13.9: M1A0. The uncorrected values (mean 146.6, standard deviation 31.3) score M0A0M0A0.

Ready to try the rest? Every answer you write is marked against the mark scheme, so you can see exactly where the marks are.

Study Helper Hints first, answers after you try

Stuck on this one? Ask for a hint and I’ll point you in the right direction, without giving the answer away. Once you’ve checked your answer, I’ll show you how the marks are awarded.