Spreadsheets and ICT (Higher) - Worksheets, Questions and Revision
53 original exam-style questions - 50 pages of questions with a full mark scheme - free printable PDF.
Spreadsheets and ICT (Higher) revision guideMore GCSE Statistics practiceMock exams
This topic is chapter 5 of GCSE Statistics Higher Topic Workbook 2 and chapter 12 of GCSE Statistics Higher 10-Minute Tests 1.
2.4 Spreadsheets and ICT (Higher)
=SUM(B2:B9)
| Reaction time, t (ms) | Frequency |
|---|---|
| 150 ≤ t < 170 | 8 |
| 170 ≤ t < 190 | ? |
| 190 ≤ t < 210 | 10 |
| 210 ≤ t < 230 | 7 |
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.
| Row (A) | B: Hours | C: Rate |
|---|---|---|
| 2: Lemons | 5 | 7 |
| 3: Pears | 11 | 10 |
| 4: Grapes | 20 | 6 |
| 5: Apples | 18 | 5 |
| 6: Cherries | 16 | 14 |
Work out the value produced by each formula.
(a) =MAX(C2:C6)
(b) =SUM(C2:C6)
(c) =MAX(B2:B6)-MIN(B2:B6)
| Books read | Frequency |
|---|---|
| 0 | 5 |
| 1 | 8 |
| 2 | 8 |
| 3 | 1 |
| 4 | 12 |
| 5 | 1 |
(a) Work out the median.
(b) Work out the mean. Give your answer to 2 decimal places if necessary.
(c) Work out the range.
| Row (A) | B: Week 1 | C: Week 2 |
|---|---|---|
| 2: Limes | 5 | 3 |
| 3: Grapes | 14 | 10 |
| 4: Melons | 14 | 3 |
| 5: Lemons | 13 | 2 |
| 6: Pears | 4 | 10 |
Work out the value produced by each formula.
(a) =COUNTIF(B2:B6,">7")
(b) =MAX(C2:C6)
(c) =B6*C6
| Row (A) | B: Week 1 | C: Week 2 |
|---|---|---|
| 2: Melons | 8 | 2 |
| 3: Apples | 8 | 3 |
| 4: Cherries | 20 | 6 |
| 5: Pears | 9 | 6 |
| 6: Grapes | 19 | 13 |
Work out the value produced by each formula.
(a) =MAX(C2:C6)
(b) =B3+C3
(c) =SUM(C2:C6)
| Number of pets | Frequency |
|---|---|
| 0 | 7 |
| 1 | 5 |
| 2 | 7 |
| 3 | 8 |
| 4 | 5 |
(a) Work out the median.
(b) Work out the mean. Give your answer to 2 decimal places if necessary.
(c) Work out the range.
| Row (A) | B: Mark 1 | C: Mark 2 |
|---|---|---|
| 2: Cherries | 13 | 15 |
| 3: Apples | 6 | 3 |
| 4: Lemons | 4 | 10 |
| 5: Limes | 6 | 10 |
| 6: Melons | 19 | 9 |
Work out the value produced by each formula.
(a) =B6*C6
(b) =SUM(C2:C6)
(c) =AVERAGE(B2:B6)
| Row (A) | B: Week 1 | C: Week 2 |
|---|---|---|
| 2: Apples | 18 | 6 |
| 3: Pears | 10 | 12 |
| 4: Grapes | 19 | 11 |
| 5: Cherries | 3 | 3 |
| 6: Lemons | 12 | 11 |
Work out the value produced by each formula.
(a) =MAX(B2:B6)-MIN(B2:B6)
(b) =B3+C3
(c) =B2*C2
| Eggs | Frequency |
|---|---|
| 0 | 12 |
| 1 | 6 |
| 2 | 3 |
| 3 | 5 |
| 4 | 8 |
| 5 | 11 |
(a) Write down the mode.
(b) Work out the median.
(c) Work out the mean. Give your answer to 2 decimal places if necessary.
| Row (A) | B: Mark 1 | C: Mark 2 |
|---|---|---|
| 2: Cherries | 10 | 3 |
| 3: Melons | 11 | 4 |
| 4: Grapes | 19 | 2 |
| 5: Plums | 11 | 9 |
| 6: Pears | 2 | 9 |
Work out the value produced by each formula.
(a) =MAX(C2:C6)
(b) =B6*C6
(c) =B3+C3
| Row (A) | B: Price (pounds) | C: Quantity |
|---|---|---|
| 2: Apples | 9 | 6 |
| 3: Grapes | 12 | 12 |
| 4: Lemons | 18 | 9 |
| 5: Melons | 10 | 8 |
| 6: Limes | 15 | 6 |
Work out the value produced by each formula.
(a) =COUNTIF(B2:B6,">7")
(b) =B3+C3
(c) =AVERAGE(B2:B6)
| Rooms | Frequency |
|---|---|
| 1 | 12 |
| 2 | 6 |
| 3 | 9 |
| 4 | 5 |
| 5 | 1 |
(a) Work out the sum of the frequencies, and so confirm the number of items.
(b) Work out the median.
(c) Work out the mean. Give your answer to 2 decimal places if necessary.
| Row (A) | B: Hours | C: Rate |
|---|---|---|
| 2: Lemons | 12 | 4 |
| 3: Limes | 14 | 15 |
| 4: Cherries | 18 | 14 |
| 5: Grapes | 14 | 10 |
| 6: Pears | 14 | 6 |
Work out the value produced by each formula.
(a) =B3+C3
(b) =AVERAGE(B2:B6)
(c) =MAX(C2:C6)
| Row (A) | B: Week 1 | C: Week 2 |
|---|---|---|
| 2: Pears | 17 | 15 |
| 3: Apples | 2 | 6 |
| 4: Limes | 10 | 5 |
| 5: Grapes | 12 | 2 |
| 6: Melons | 4 | 6 |
Work out the value produced by each formula.
(a) =MAX(C2:C6)
(b) =SUM(B2:B6)
(c) =MIN(C2:C6)
| Eggs | Frequency |
|---|---|
| 0 | 7 |
| 1 | 5 |
| 2 | 8 |
| 3 | 6 |
| 4 | 3 |
(a) Work out the sum of the frequencies, and so confirm the number of items.
(b) Write down the mode.
(c) Work out the mean. Give your answer to 2 decimal places if necessary.
| Row (A) | B: Price (pounds) | C: Quantity |
|---|---|---|
| 2: Plums | 7 | 2 |
| 3: Lemons | 19 | 9 |
| 4: Apples | 2 | 9 |
| 5: Melons | 19 | 12 |
| 6: Pears | 14 | 10 |
Work out the value produced by each formula.
(a) =MIN(C2:C6)
(b) =COUNTIF(B2:B6,">9")
(c) =B6*C6
| Row (A) | B: Price (pounds) | C: Quantity |
|---|---|---|
| 2: Cherries | 4 | 9 |
| 3: Pears | 16 | 7 |
| 4: Lemons | 4 | 4 |
| 5: Apples | 14 | 2 |
| 6: Melons | 8 | 5 |
Work out the value produced by each formula.
(a) =AVERAGE(B2:B6)
(b) =B3+C3
(c) =SUM(B2:B6)
| Goals | Frequency |
|---|---|
| 0 | 8 |
| 1 | 2 |
| 2 | 2 |
| 3 | 4 |
| 4 | 12 |
(a) Work out the median.
(b) Work out the mean. Give your answer to 2 decimal places if necessary.
(c) Work out the range.
| Row (A) | B: Week 1 | C: Week 2 |
|---|---|---|
| 2: Melons | 10 | 10 |
| 3: Limes | 7 | 11 |
| 4: Plums | 8 | 3 |
| 5: Lemons | 16 | 11 |
| 6: Apples | 10 | 8 |
Work out the value produced by each formula.
(a) =SUM(C2:C6)
(b) =AVERAGE(B2:B6)
(c) =MAX(C2:C6)
| Row (A) | B: Price (pounds) | C: Quantity |
|---|---|---|
| 2: Cherries | 7 | 14 |
| 3: Apples | 17 | 14 |
| 4: Pears | 13 | 13 |
| 5: Limes | 17 | 6 |
| 6: Plums | 16 | 14 |
Work out the value produced by each formula.
(a) =COUNTIF(B2:B6,">9")
(b) =AVERAGE(B2:B6)
(c) =B2*C2
| Days absent | Frequency |
|---|---|
| 0 | 12 |
| 1 | 10 |
| 2 | 7 |
| 3 | 9 |
| 4 | 11 |
(a) Work out the median.
(b) Work out the mean. Give your answer to 2 decimal places if necessary.
(c) Work out the range.
| Row (A) | B: Mark 1 | C: Mark 2 |
|---|---|---|
| 2: Lemons | 12 | 15 |
| 3: Cherries | 2 | 13 |
| 4: Pears | 18 | 3 |
| 5: Grapes | 5 | 3 |
| 6: Melons | 12 | 13 |
Work out the value produced by each formula.
(a) =B2*C2
(b) =COUNTIF(B2:B6,">12")
(c) =MAX(C2:C6)
| Number of cars | Frequency |
|---|---|
| 1 | 9 |
| 2 | 1 |
| 3 | 3 |
| 4 | 3 |
| 5 | 1 |
(a) Work out the sum of the frequencies, and so confirm the number of items.
(b) Write down the mode.
(c) Work out the mean. Give your answer to 2 decimal places if necessary.
| Row (A) | B: Hours | C: Rate |
|---|---|---|
| 2: Pears | 18 | 8 |
| 3: Lemons | 9 | 5 |
| 4: Limes | 15 | 13 |
| 5: Melons | 3 | 15 |
| 6: Cherries | 10 | 7 |
Work out the value produced by each formula.
(a) =AVERAGE(B2:B6)
(b) =B6*C6
(c) =MIN(C2:C6)
| Books read | Frequency |
|---|---|
| 0 | 2 |
| 1 | 6 |
| 2 | 9 |
| 3 | 3 |
| 4 | 5 |
| 5 | 10 |
(a) Write down the mode.
(b) Work out the median.
(c) Work out the mean. Give your answer to 2 decimal places if necessary.
| Row (A) | B: Mark 1 | C: Mark 2 |
|---|---|---|
| 2: Limes | 18 | 8 |
| 3: Melons | 20 | 2 |
| 4: Apples | 8 | 8 |
| 5: Lemons | 9 | 8 |
| 6: Pears | 18 | 8 |
Work out the value produced by each formula.
(a) =B6*C6
(b) =SUM(B2:B6)
(c) =AVERAGE(B2:B6)
| Row (A) | B: Week 1 | C: Week 2 |
|---|---|---|
| 2: Lemons | 8 | 2 |
| 3: Apples | 14 | 15 |
| 4: Melons | 3 | 7 |
| 5: Limes | 2 | 7 |
| 6: Cherries | 2 | 9 |
Work out the value produced by each formula.
(a) =MIN(C2:C6)
(b) =B6*C6
(c) =COUNTIF(B2:B6,">7")
| Eggs | Frequency |
|---|---|
| 1 | 4 |
| 2 | 4 |
| 3 | 8 |
| 4 | 10 |
| 5 | 9 |
(a) Work out the sum of the frequencies, and so confirm the number of items.
(b) Write down the mode.
(c) Work out the mean. Give your answer to 2 decimal places if necessary.
| Row (A) | B: Mark 1 | C: Mark 2 |
|---|---|---|
| 2: Apples | 15 | 3 |
| 3: Melons | 13 | 6 |
| 4: Plums | 15 | 2 |
| 5: Limes | 20 | 9 |
| 6: Pears | 12 | 8 |
Work out the value produced by each formula.
(a) =MAX(B2:B6)-MIN(B2:B6)
(b) =B6*C6
(c) =COUNTIF(B2:B6,">11")
| Row (A) | B: Hours | C: Rate |
|---|---|---|
| 2: Lemons | 2 | 15 |
| 3: Plums | 4 | 13 |
| 4: Cherries | 16 | 15 |
| 5: Pears | 13 | 12 |
| 6: Apples | 14 | 10 |
Work out the value produced by each formula.
(a) =COUNTIF(B2:B6,">8")
(b) =SUM(C2:C6)
(c) =B6*C6
| Number of cars | Frequency |
|---|---|
| 0 | 5 |
| 1 | 3 |
| 2 | 3 |
| 3 | 6 |
| 4 | 11 |
(a) Work out the sum of the frequencies, and so confirm the number of items.
(b) Write down the mode.
(c) Work out the mean. Give your answer to 2 decimal places if necessary.
| Row (A) | B: Hours | C: Rate |
|---|---|---|
| 2: Plums | 12 | 8 |
| 3: Limes | 6 | 9 |
| 4: Cherries | 8 | 7 |
| 5: Apples | 12 | 4 |
| 6: Grapes | 2 | 14 |
Work out the value produced by each formula.
(a) =MAX(B2:B6)-MIN(B2:B6)
(b) =B6*C6
(c) =AVERAGE(B2:B6)
| Row (A) | B: Hours | C: Rate |
|---|---|---|
| 2: Lemons | 16 | 15 |
| 3: Plums | 16 | 7 |
| 4: Limes | 15 | 3 |
| 5: Apples | 10 | 11 |
| 6: Cherries | 14 | 4 |
Work out the value produced by each formula.
(a) =MIN(C2:C6)
(b) =COUNTIF(B2:B6,">7")
(c) =SUM(C2:C6)
| Row (A) | B: Hours | C: Rate |
|---|---|---|
| 2: Lemons | 18 | 3 |
| 3: Apples | 14 | 5 |
| 4: Limes | 15 | 7 |
| 5: Melons | 14 | 15 |
| 6: Plums | 15 | 14 |
Work out the value produced by each formula.
(a) =B2*C2
(b) =B6*C6
(c) =SUM(B2:B6)
| Row (A) | B: Hours | C: Rate |
|---|---|---|
| 2: Plums | 17 | 9 |
| 3: Apples | 6 | 15 |
| 4: Limes | 10 | 14 |
| 5: Grapes | 19 | 9 |
| 6: Pears | 10 | 14 |
Work out the value produced by each formula.
(a) =AVERAGE(B2:B6)
(b) =SUM(B2:B6)
(c) =MIN(C2:C6)
| Row (A) | B: Week 1 | C: Week 2 |
|---|---|---|
| 2: Pears | 19 | 15 |
| 3: Grapes | 20 | 4 |
| 4: Cherries | 3 | 2 |
| 5: Lemons | 6 | 14 |
| 6: Melons | 10 | 7 |
Work out the value produced by each formula.
(a) =COUNTIF(B2:B6,">6")
(b) =B6*C6
(c) =MIN(C2:C6)
| Row (A) | B: Price (pounds) | C: Quantity |
|---|---|---|
| 2: Plums | 10 | 4 |
| 3: Cherries | 8 | 14 |
| 4: Grapes | 18 | 5 |
| 5: Melons | 10 | 11 |
| 6: Limes | 14 | 12 |
Work out the value produced by each formula.
(a) =MIN(C2:C6)
(b) =SUM(C2:C6)
(c) =MAX(B2:B6)-MIN(B2:B6)
| Row (A) | B: Mark 1 | C: Mark 2 |
|---|---|---|
| 2: Pears | 11 | 8 |
| 3: Apples | 11 | 8 |
| 4: Grapes | 7 | 5 |
| 5: Melons | 17 | 3 |
| 6: Cherries | 16 | 13 |
Work out the value produced by each formula.
(a) =B2*C2
(b) =MAX(C2:C6)
(c) =MIN(C2:C6)
| Row (A) | B: Price (pounds) | C: Quantity |
|---|---|---|
| 2: Cherries | 8 | 8 |
| 3: Lemons | 11 | 2 |
| 4: Plums | 20 | 8 |
| 5: Pears | 16 | 15 |
| 6: Limes | 5 | 4 |
Work out the value produced by each formula.
(a) =COUNTIF(B2:B6,">11")
(b) =SUM(B2:B6)
(c) =MIN(C2:C6)
Question 1
- (a) shows the spreadsheet that the entry is a formula (a calculation), not plain text or a numberB1
- (a) Answer: It shows the spreadsheet that this is a formula (a calculation), not plain text or a number typed into the cell.
- (b) add together (find the total of) the values in the given range of cellsB1
- (b) Answer: It tells the spreadsheet to add together (find the total of) the values in the range that follows.
- (c) the range of cells to use in the calculation, from cell B2 to cell B9 inclusiveB1
- (c) Answer: It tells the spreadsheet which range of cells to use in the calculation, from cell B2 to cell B9 inclusive.
Question 2
- (a) 6 caoB1
- (a) Answer: 6
- (b) C4 caoB1
- (b) Answer: C4
- (c) the average (mean) number of minutes Zara spent per visitB1
- (c) Answer: The average (mean) number of minutes Zara spent per visit.
- (d) 30 caoB1
- (d) Answer: 30
Question 3
- (i) False caoB1
- (i) Answer: False
- (ii) True caoB1
- (ii) Answer: True
Question 4
- (a) =B2*C2 oe (accept =C2*B2)B1
- (a) Answer: =B2*C2
- (b) 8.50 x 120, oeM1
- (b) 1020 or 1020.00 caoA1
- (b) Answer: 1020.00
- (c) the value in D2 updates/recalculates automatically (to 1080)B1
- (c) because the formula in D2 references cell B2, and a spreadsheet automatically recalculates any formula whenever a value it depends on changesB1
- (c) Answer: It updates automatically to 1080, because the formula in D2 refers to cell B2, and a spreadsheet recalculates a formula automatically whenever a value it references changes.
Question 5
- (a) AVERAGE used as a named function, e.g. =AVERAGE(...)B1
- (a) correct range B2:B8B1
- (a) Answer: =AVERAGE(B2:B8)
- (b) (18+22+15+30+21+19+25) / 7, oeM1
- (b) 21.4 awrtA1
- (b) Answer: 21.4
- (c) =MEDIAN(B2:B8) oeB1
- (c) Answer: =MEDIAN(B2:B8)
- (d) 21 caoB1
- (d) Answer: 21
Question 6
- (a) any valid advantage, e.g. it is much faster, oe it avoids the risk of mistyping one of the 500 individual formulasB1
- (a) Answer: It is much faster, and it avoids the risk of mistyping one of the 500 formulas individually.
- (b) recognises that both relative references shift down by the same number of rows as the copyB1
- (b) =B250-C250 caoB1
- (b) Answer: =B250-C250
Question 7
- (a) Dee caoB1
- (a) Answer: Dee
- (b) Gus caoB1
- (b) Answer: Gus
- (c) Bea and Gus identified (13.5 and 13.2, both category U17 and under 13.8 seconds)B1
- (c) Cai and Emi correctly excluded (14.2 and 13.9 are not under 13.8 seconds), with all category U15 athletes also excludedB1
- (c) Answer: Bea, Gus
Question 8
- (a) without the $ signs, the reference to B8 would shift down by one row for each row copied (e.g. to B9, then B10, and so on)B1
- (a) the mean is only stored once, in cell B8, so every copy of the formula must refer back to that same fixed cell to calculate each deviation correctlyB1
- (a) Answer: Without the dollar signs, the reference would shift down a row each time the formula is copied (to B9, then B10, and so on), but the mean is only stored in cell B8, so every copy must refer back to that one fixed cell for the calculation to work.
- (b) (198+202+196+204+200+200) / 6, oeM1
- (b) 200 caoA1
- (b) Answer: 200
- (c) (196-200)2, oe (using the value 196 from B4 and the mean 200 from B8)M1
- (c) 16 caoA1
- (c) Answer: 16
- (d) the standard deviation caoB1
- (d) Answer: The standard deviation
Question 9
- (a) Fail caoB1
- (a) Answer: Fail
- (b) Pass caoB1
- (b) Answer: Pass
- (c) COUNTIF used as a named function with a correct condition, e.g. =COUNTIF(...,"≥40")B1
- (c) correct range B2:B8B1
- (c) Answer: =COUNTIF(B2:B8,"≥40")
- (d) 5 caoB1
- (d) Answer: 5
Question 10
- (a) positive (correlation) caoB1
- (a) Answer: Positive correlation
- (b) any valid advantage, e.g. it is calculated by a fixed, consistent method, so it does not vary between people or between attempts, unlike a line drawn by eyeB1
- (b) Answer: It is calculated by a fixed method, so it gives the same precise line every time, unlike a line of best fit drawn by eye, which can vary from person to person.
- (c) 59 caoB1
- (c) Answer: 59
- (d) 4.5 x 20 + 32, oe (= 122)M1
- (d) not reliable, e.g. 20 hours is far beyond the range of the original data (extrapolation), and 122 is not even a possible test score out of 100B1
- (d) Answer: 122; this is not reliable, since 20 hours is far beyond the range of the original data (extrapolation), and a score of 122 is not even possible out of 100.
Question 11
- (a) COUNTIFS used as a named function with two correct conditions, e.g. =COUNTIFS(...,"≥170",...,"<190")B1
- (a) correct range B2:B41 used for both conditionsB1
- (a) Answer: =COUNTIFS(B2:B41,"≥170",B2:B41,"<190")
- (b) 40 - 8 - 10 - 7, oeM1
- (b) 15 caoA1
- (b) Answer: 15
Question 12
- (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 errorB1
- (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) 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 neededB1
- (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) a reason supporting the statement, e.g. ICT can handle far more data, far more quickly and consistently, than a person calculating by handB1
- (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 availableB1
- (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 usedB1
- (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 13
- (a) the range only covers B2:B9 (8 cells), missing B10, and the formula divides by 8, when it should divide by 9 (for 9 values)B1
- (a) Answer: The range should be B2:B10, to include all 9 weeks, and the formula should divide by 9, not 8.
- (b) AVERAGE used as a named function, e.g. =AVERAGE(...)B1
- (b) correct range B2:B10B1
- (b) Answer: =AVERAGE(B2:B10)
- (c) 46.75 x 8 = 374, so the sum of the values in B2:B9 is 374B1
- (c) no, it is not possible, since the value in B10 (the 9th week) is not known, so the total for all 9 weeks cannot be found from this information aloneB1
- (c) Answer: The sum of B2:B9 is 374 (46.75 x 8), but the value in B10 is still unknown, so the correct mean of all 9 weeks cannot be determined from this information alone.
Question 14
- (a) names a function such as RAND or RANDBETWEENB1
- (a) explains that this gives each student on the list a fair, unbiased chance of being chosen for the sampleB1
- (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) identifies that some students may not have reliable internet/email access, or may not check or respond to itB1
- (b) explains that this could bias the sample, as certain groups of students may be under-represented in the resultsB1
- (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) any valid use, e.g. a spreadsheet function instantly calculates a summary statistic, such as the mean or standard deviation, for all 15 000 responsesB1
- (c) Answer: A spreadsheet function can calculate the mean or standard deviation of all 15 000 responses in seconds.
- (d) recognises that the reliability of the results depends on the quality of the data (and the sampling method), not only on the calculations performedB1
- (d) explains that a spreadsheet will process incorrect, biased or poorly collected data without warning, so correct calculations alone do not guarantee reliable resultsB1
- (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 15
- the 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 softwareB1
- the 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 essentialB1
- a 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 checkedB1
- a clear overall conclusion, e.g. the best method depends on the scale (and nature) of the data, rather than one method always being betterB1
- 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 16
- 14 caoB1
- 42 caoB1
- 15 caoB1
- Answer: (a) 14; (b) 42; (c) 15
Question 17
- identifies the position of the median (35 items, cumulative frequencies used)M1
- 2 caoA1
- products of value and frequency formed (at least 3 correct)M1
- sum of products (80) divided by 35M1
- 2.29 caoA1
- 5 caoB1
- Answer: (a) 2; (b) 2.29; (c) 5
Question 18
- 3 caoB1
- 10 caoB1
- 40 caoB1
- Answer: (a) 3; (b) 10; (c) 40
Question 19
- 13 caoB1
- 11 caoB1
- 30 caoB1
- Answer: (a) 13; (b) 11; (c) 30
Question 20
- identifies the position of the median (32 items, cumulative frequencies used)M1
- 2 caoA1
- products of value and frequency formed (at least 3 correct)M1
- sum of products (63) divided by 32M1
- 1.97 caoA1
- 4 caoB1
- Answer: (a) 2; (b) 1.97; (c) 4
Question 21
- 171 caoB1
- 47 caoB1
- 9.6 caoB1
- Answer: (a) 171; (b) 47; (c) 9.6
Question 22
- 16 caoB1
- 22 caoB1
- 108 caoB1
- Answer: (a) 16; (b) 22; (c) 108
Question 23
- 0 caoB1
- identifies the position of the median (45 items, cumulative frequencies used)M1
- 3 caoA1
- products of value and frequency formed (at least 3 correct)M1
- sum of products (114) divided by 45M1
- 2.53 caoA1
- Answer: (a) 0; (b) 3; (c) 2.53
Question 24
- 9 caoB1
- 18 caoB1
- 15 caoB1
- Answer: (a) 9; (b) 18; (c) 15
Question 25
- 5 caoB1
- 24 caoB1
- 12.8 caoB1
- Answer: (a) 5; (b) 24; (c) 12.8
Question 26
- 33 caoB1
- identifies the position of the median (33 items, cumulative frequencies used)M1
- 2 caoA1
- products of value and frequency formed (at least 3 correct)M1
- sum of products (76) divided by 33M1
- 2.30 caoA1
- Answer: (a) 33; (b) 2; (c) 2.30
Question 27
- 29 caoB1
- 14.4 caoB1
- 15 caoB1
- Answer: (a) 29; (b) 14.4; (c) 15
Question 28
- 15 caoB1
- 45 caoB1
- 2 caoB1
- Answer: (a) 15; (b) 45; (c) 2
Question 29
- 29 caoB1
- 2 caoB1
- products of value and frequency formed (at least 3 correct)M1
- sum of products (51) divided by 29M1
- 1.76 caoA1
- Answer: (a) 29; (b) 2; (c) 1.76
Question 30
- 2 caoB1
- 3 caoB1
- 140 caoB1
- Answer: (a) 2; (b) 3; (c) 140
Question 31
- 9.2 caoB1
- 23 caoB1
- 46 caoB1
- Answer: (a) 9.2; (b) 23; (c) 46
Question 32
- identifies the position of the median (28 items, cumulative frequencies used)M1
- 3 caoA1
- products of value and frequency formed (at least 3 correct)M1
- sum of products (66) divided by 28M1
- 2.36 caoA1
- 4 caoB1
- Answer: (a) 3; (b) 2.36; (c) 4
Question 33
- 43 caoB1
- 10.2 caoB1
- 11 caoB1
- Answer: (a) 43; (b) 10.2; (c) 11
Question 34
- 4 caoB1
- 14 caoB1
- 98 caoB1
- Answer: (a) 4; (b) 14; (c) 98
Question 35
- identifies the position of the median (49 items, cumulative frequencies used)M1
- 2 caoA1
- products of value and frequency formed (at least 3 correct)M1
- sum of products (95) divided by 49M1
- 1.94 caoA1
- 4 caoB1
- Answer: (a) 2; (b) 1.94; (c) 4
Question 36
- 180 caoB1
- 1 caoB1
- 15 caoB1
- Answer: (a) 180; (b) 1; (c) 15
Question 37
- 17 caoB1
- 1 caoB1
- products of value and frequency formed (at least 3 correct)M1
- sum of products (37) divided by 17M1
- 2.18 caoA1
- Answer: (a) 17; (b) 1; (c) 2.18
Question 38
- 11 caoB1
- 70 caoB1
- 5 caoB1
- Answer: (a) 11; (b) 70; (c) 5
Question 39
- 5 caoB1
- identifies the position of the median (35 items, cumulative frequencies used)M1
- 3 caoA1
- products of value and frequency formed (at least 3 correct)M1
- sum of products (103) divided by 35M1
- 2.94 caoA1
- Answer: (a) 5; (b) 3; (c) 2.94
Question 40
- 144 caoB1
- 73 caoB1
- 14.6 caoB1
- Answer: (a) 144; (b) 73; (c) 14.6
Question 41
- 2 caoB1
- 18 caoB1
- 2 caoB1
- Answer: (a) 2; (b) 18; (c) 2
Question 42
- 35 caoB1
- 4 caoB1
- products of value and frequency formed (at least 3 correct)M1
- sum of products (121) divided by 35M1
- 3.46 caoA1
- Answer: (a) 35; (b) 4; (c) 3.46
Question 43
- 8 caoB1
- 96 caoB1
- 5 caoB1
- Answer: (a) 8; (b) 96; (c) 5
Question 44
- 3 caoB1
- 65 caoB1
- 140 caoB1
- Answer: (a) 3; (b) 65; (c) 140
Question 45
- 28 caoB1
- 4 caoB1
- products of value and frequency formed (at least 3 correct)M1
- sum of products (71) divided by 28M1
- 2.54 caoA1
- Answer: (a) 28; (b) 4; (c) 2.54
Question 46
- 10 caoB1
- 28 caoB1
- 8 caoB1
- Answer: (a) 10; (b) 28; (c) 8
Question 47
- 3 caoB1
- 5 caoB1
- 40 caoB1
- Answer: (a) 3; (b) 5; (c) 40
Question 48
- 54 caoB1
- 210 caoB1
- 76 caoB1
- Answer: (a) 54; (b) 210; (c) 76
Question 49
- 12.4 caoB1
- 62 caoB1
- 9 caoB1
- Answer: (a) 12.4; (b) 62; (c) 9
Question 50
- 3 caoB1
- 70 caoB1
- 2 caoB1
- Answer: (a) 3; (b) 70; (c) 2
Question 51
- 4 caoB1
- 46 caoB1
- 10 caoB1
- Answer: (a) 4; (b) 46; (c) 10
Question 52
- 88 caoB1
- 13 caoB1
- 3 caoB1
- Answer: (a) 88; (b) 13; (c) 3
Question 53
- 2 caoB1
- 60 caoB1
- 2 caoB1
- Answer: (a) 2; (b) 60; (c) 2
Mark your answers
Check answers without an account. Some answers can be checked automatically; use the mark scheme to mark the rest.