Revision Library
Choose a subject
Menu

GCSE Statistics Higher Topic Workbooks · Book 2 of 8

GCSE Statistics Higher Topic Workbook 2

Collecting Data, Designing Questionnaires and Surveys, Experimental Design and 5 more

Level
GCSE Higher · Edexcel 1ST0
Series
GCSE Statistics Higher Topic Workbooks, book 2 of 8
Suitable for
Years 10-11, Edexcel
FreePDF download · 2027 edition · 103 A4 pages
  • One file, prints straight to A4
  • No account, no password

Workbooks like this one, with 8 topics, 101 questions and mark schemes at the back, are usually printed and sold by publishers. This one is one of 558 free PDFs on the shelf.

Pages
103 A4 pages
Chapters
8 worksheet chapters
Questions
101 · 494 marks
Answers
From page 86
Working time
About 8h 35m

What is inside

8 chapters · answers from p86

Each chapter starts with a page showing its marks and a suggested time, followed by the questions. The mark schemes for all 8 chapters are at the back, so the book works for homework, a timed test or revision.

  1. 01Collecting Data12 questions · 50 marks · about 50 min Topic guide: Collecting Datap3
  2. 02Designing Questionnaires and Surveys16 questions · 57 marks · about 60 min Topic guide: Designing Questionnaires and Surveysp11
  3. 03Experimental Design14 questions · 54 marks · about 55 min Topic guide: Experimental Designp21
  4. 04Data Cleaning and Outliers (Higher)11 questions · 72 marks · about 75 min Topic guide: Data Cleaning and Outliers (Higher)p31
  5. 05Spreadsheets and ICT (Higher)12 questions · 55 marks · about 60 min Topic guide: Spreadsheets and ICT (Higher)p41
  6. 06Histograms and Frequency Density12 questions · 77 marks · about 80 min Topic guide: Histograms and Frequency Densityp51
  7. 07Comparative and Proportional Pie Charts12 questions · 75 marks · about 80 min Topic guide: Comparative and Proportional Pie Chartsp64
  8. 08Box Plots from Cumulative Frequency and Outliers12 questions · 54 marks · about 55 min Topic guide: Box Plots from Cumulative Frequency and Outliersp74
  9. AnswersMark schemes for every chapterp86

Each chapter is drawn from one of our worksheet packs. Follow a chapter title for the full pack on its own page, or browse every GCSE Statistics pack. Every book on the shelf is a complete printable workbook of up to 120 A4 pages.

Explore this volume

GCSE Statistics Higher Topic Workbook 2 includes Collecting Data (from page 3); Designing Questionnaires and Surveys (from page 11); Experimental Design (from page 21); Data Cleaning and Outliers (Higher) (from page 31); Spreadsheets and ICT (Higher) (from page 41); Histograms and Frequency Density (from page 51); Comparative and Proportional Pie Charts (from page 64); Box Plots from Cumulative Frequency and Outliers (from page 74).

Worked question 12 - Spreadsheets and ICT (Higher)

Open the included worksheet

A small local sports club has 40 members, and wants to work out the total and mean annual subscription income. A national retailer processes about 2 million transactions every month, and wants to work out the same kind of summary statistics.

Compare these two situations, and recommend, with justification, whether each organisation should rely mainly on manual calculation or on ICT/database software to process its data.

Answer and mark scheme

Question 12

CreditAnswer or working
B1the club's data set (40 members) is small enough that manual calculation is a reasonable, proportionate option, without the cost or training needed for specialist software
B1the retailer's data set (about 2 million transactions) is far too large for manual calculation to be practical or accurate within a reasonable time, so ICT/database software is essential
B1a relevant risk/limitation is identified for at least one case, e.g. a single formula error in the retailer's software could affect an enormous number of records, so results still need to be checked
B1a clear overall conclusion, e.g. the best method depends on the scale (and nature) of the data, rather than one method always being better
  • Answer: For the club's 40 members, manual calculation is perfectly proportionate and avoids unnecessary software or training costs. For the retailer's roughly 2 million monthly transactions, manual calculation is not feasible in a reasonable time, so ICT/database software is essential, although any formula error could then affect a huge number of records, so results should still be checked. Overall, the best method depends on the scale of the data, rather than one method always being better.

Question 9 - Spreadsheets and ICT (Higher)

Open the included worksheet

A national weather agency processes the daily rainfall total recorded at each of 3000 weather stations, using spreadsheet software rather than manual calculation.
(a)Give one advantage of using spreadsheet software, rather than manual calculation, to find the mean daily rainfall across all 3000 weather stations.(1)
(b)Give one disadvantage or risk of relying entirely on spreadsheet software when processing data on this scale.(1)
(c)"For very large data sets, using ICT is always better than manual calculation." Discuss this statement, giving a reason for the statement and a reason against it, and give a justified overall conclusion.(3)

Answer and mark scheme

Question 9

CreditAnswer or working
B1(a) any valid advantage, e.g. it can process a very large amount of data almost instantly, which would take a very long time by hand and would be far more likely to contain an arithmetic error
B1(b) any valid disadvantage, e.g. a single error in the data or in a formula could go unnoticed and affect every calculated result, or specialist software/training may be needed
B1(c) a reason supporting the statement, e.g. ICT can handle far more data, far more quickly and consistently, than a person calculating by hand
B1(c) a reason against the statement, e.g. ICT still depends on the data and formulas being correct in the first place, and specialist software or training is not always available
B1(c) a clear, justified conclusion, e.g. ICT is usually better for very large data sets, but is not automatically 'always' better, since the result is still only as good as the data and formulas used
  • (a) Answer: It processes all 3000 values almost instantly, which would take a very long time by hand and would be far more likely to contain an arithmetic error.
  • (b) Answer: If the data or a formula contains even one error, it could affect every result calculated from it, and this might not be noticed among so many values.
  • (c) Answer: ICT lets huge amounts of data be processed quickly and consistently, which manual calculation cannot match, but it is only as good as the data and formulas entered, so it is not automatically better in every case. Overall, ICT is usually the better choice for very large data sets, provided the data and formulas are checked.

Question 11 - Spreadsheets and ICT (Higher)

Open the included worksheet

A university research team plans to investigate wellbeing among 15 000 students nationally, using ICT at each stage of the statistical enquiry cycle: plan, collect, process and interpret.
(a)Give one way a spreadsheet's random number function could be used at the plan stage, before the main survey, to help select a manageable sample from the full list of 15 000 students.(2)
(b)Give one limitation of collecting responses using an online survey alone at the collect stage, for this population of students.(2)
(c)State one way ICT allows this large data set to be processed that would not be feasible by hand within a reasonable time.(1)
(d)A researcher claims: "Because the spreadsheet performed all the calculations, the results must be reliable." Evaluate this claim.(2)

Answer and mark scheme

Question 11

CreditAnswer or working
B1(a) names a function such as RAND or RANDBETWEEN
B1(a) explains that this gives each student on the list a fair, unbiased chance of being chosen for the sample
B1(b) identifies that some students may not have reliable internet/email access, or may not check or respond to it
B1(b) explains that this could bias the sample, as certain groups of students may be under-represented in the results
B1(c) any valid use, e.g. a spreadsheet function instantly calculates a summary statistic, such as the mean or standard deviation, for all 15 000 responses
B1(d) recognises that the reliability of the results depends on the quality of the data (and the sampling method), not only on the calculations performed
B1(d) explains that a spreadsheet will process incorrect, biased or poorly collected data without warning, so correct calculations alone do not guarantee reliable results
  • (a) Answer: A function such as RANDBETWEEN could assign each of the 15 000 students a random number, and the students with, say, the lowest 500 numbers are chosen, giving everyone a fair chance of selection.
  • (b) Answer: Some students may not have reliable internet access, or may simply not respond, so those students are under-represented, which could bias the results.
  • (c) Answer: A spreadsheet function can calculate the mean or standard deviation of all 15 000 responses in seconds.
  • (d) Answer: This claim is not necessarily true. A spreadsheet only guarantees that the calculations are carried out correctly; if the data collected is inaccurate, incomplete, or comes from a biased sample, the spreadsheet will process it without warning, so the results could still be unreliable.

Question 10 - Data Cleaning and Outliers (Higher)

Open the included worksheet

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)

Answer and mark scheme

Question 10

CreditAnswer or working
B1(a) 20.64 mm cao
M1(b) 309.6 - 29.6 + 19.6, oe
A1(b) 299.6 cao
M1(c) 6476.86 - 29.62 + 19.62, oe
A1(c) 5984.86 cao
M1(d) mean = 299.6/15, oe
A1(d) 19.97 (awrt 19.97) cao
A1(d) SD = 0.24 (awrt 0.24) cao
B1(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 oe
  • (a) Answer: 20.64 mm.
  • (b) Answer: sum of x = 299.6.
  • (c) Answer: sum of x2 = 5984.86.
  • (d) Answer: Mean = 19.97 mm (awrt), standard deviation = 0.24 mm (awrt).
  • (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 9 - Data Cleaning and Outliers (Higher)

Open the included worksheet

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)

Answer and mark scheme

Question 9

CreditAnswer or working
B1(a) bag 4 (50 g) cao
B1(b) 500 g - a zero has probably been dropped when the mass was typed in, oe
M1(c) sum = 4553, oe
A1(c) mean = 455.3 cao
M1(c) correct substitution into the formula, e.g. 2255545/10 - 455.32, oe
A1(c) 135.1 (awrt 135.1) cao
M1(d) sum = 5003, oe
A1(d) mean = 500.3 cao
A1(d) SD = 2.1 cao
B1(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 oe
  • (a) Answer: Bag 4 (50 g).
  • (b) Answer: 500 g (a zero was probably dropped when it was typed in).
  • (c) Answer: Mean = 455.3 g, standard deviation = 135.1 g (awrt).
  • (d) Answer: Mean = 500.3 g, standard deviation = 2.1 g.
  • (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.

GCSE Statistics Higher Topic Workbooks runs to 8 volumes

Book 2 of 8 · 825 pages in the set

Each book is a separate free PDF.

Volume 1

99 pp · 104 Qs

Stratified Sampling (Higher), Capture Recapture, Estimating from Samples (Higher) and 4 more

Volume 2 · this book

103 pp · 101 Qs

Collecting Data, Designing Questionnaires and Surveys, Experimental Design and 5 more

Volume 3

102 pp · 84 Qs

Recognising Misleading Graphs (Higher), Frequency Tables and Tally Charts, Grouped Frequency Tables and 4 more

Volume 4

109 pp · 101 Qs

Histograms, Frequency Polygons, Cumulative Frequency and 5 more

Volume 5

109 pp · 94 Qs

Quality Assurance and Control Charts, Percentiles and Interpercentile Range, Skewness and 5 more

Volume 6

99 pp · 86 Qs

Combined Mean, Median Quartiles and IQR, Correlation and Causation (Higher) and 4 more

Volume 7

107 pp · 98 Qs

Time Series, Risk (Higher), Conditional Probability (Higher) and 5 more

Volume 8

97 pp · 84 Qs

Venn Diagrams, Tree Diagrams, Crude and Standardised Rates and 4 more

More GCSE Higher books

Want a different mix of topics?

Sitting an exam soon? Build a GCSE Statistics mock paper or print a ready-made one.