Skip to the worksheet
Revision Library
Choose a subject

Time Series - Worksheets, Questions and Revision

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

This topic is chapter 5 of GCSE Statistics Foundation Topic Workbook 5 and chapter 1 of GCSE Statistics Higher Topic Workbook 7.

Revision Library
revisionlibrary.co.uk
GCSE · Statistics

4.8 Time Series

EDEXCEL 1ST0 · Calculator allowed · about 230 minutes
Total Marks
Name: _______________________________    Date: ____ / ____ / ______
Answer ALL questions. Show all your working.
1
Statisticians use particular words to describe patterns in data recorded over time. For each statement, write down whether it is True or False.
(i)A time series is a set of data values recorded at successive points in time, usually at equal intervals such as every month or every quarter.(1)
(ii)In a time series, the trend describes the short pattern that repeats within each year, while seasonal variation describes the long-term direction of the data.(1)
(iii)A time series graph is drawn by plotting each value in time order along the horizontal axis and joining consecutive points with straight lines.(1)
(Total for Question 1 is 3 marks)
2
Northfell Dry Ski Slope records the number of ski and snowboard lessons it sells each quarter. The graph shows lesson bookings for Year 1 and Year 2.
020406080100Y1 Q1Y1 Q2Y1 Q3Y1 Q4Y2 Q1Y2 Q2Y2 Q3Y2 Q4QuarterLessons booked
(a)Write down the number of lessons booked in Year 2 Quarter 3.(1)
(b)Write down the quarter in which the fewest lessons were booked in both Year 1 and Year 2.(1)
(c)Describe, in one sentence, the pattern shown by the graph over the two years.(1)
(d)State whether the name for this repeating winter-high, summer-low pattern is the trend or the seasonal variation.(1)
(Total for Question 2 is 4 marks)
3
For each statement about time series and moving averages, write down whether it is True or False.
(i)A 4-point moving average is calculated by adding 4 consecutive data values and dividing the total by 4.(1)
(ii)A moving average removes the trend from a time series, leaving only the seasonal variation.(1)
(iii)Each 4-point moving average value should be plotted at the midpoint in time of the 4 values used to calculate it.(1)
(iv)A time series graph can only be used to show data that was collected once a year, never every month or every quarter.(1)
(Total for Question 3 is 4 marks)
4
The table shows quarterly figures for the number of customers at a garden centre each month, in hundreds.
QuarterValue
2019 Q163
2019 Q278
2019 Q395
2019 Q478
2020 Q171
2020 Q286
2020 Q3103
2020 Q486
2021 Q179
2021 Q294
2021 Q3111
2021 Q494

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2020 Q1 quarter.
(c) State the seasonal effect for 2020 Q1, that is the value minus the centred moving average.
(Total for Question 4 is 5 marks)
5
The table shows quarterly figures for the number of visitors, in hundreds, to a seaside cafe each day.
QuarterValue
2021 Q175
2021 Q285
2021 Q393
2021 Q481
2022 Q183
2022 Q293
2022 Q3101
2022 Q489
2023 Q191
2023 Q2101
2023 Q3109
2023 Q497

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2022 Q1 quarter.
(c) State the seasonal effect for 2022 Q1, that is the value minus the centred moving average.
(Total for Question 5 is 5 marks)
6
The table shows quarterly figures for the daily number of hot drinks sold at a kiosk.
QuarterValue
2021 Q158
2021 Q272
2021 Q380
2021 Q468
2022 Q166
2022 Q280
2022 Q388
2022 Q476
2023 Q174
2023 Q288
2023 Q396
2023 Q484

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2022 Q1 quarter.
(c) State the seasonal effect for 2022 Q1, that is the value minus the centred moving average.
(Total for Question 6 is 5 marks)
7
The table gives the number of visitors, in hundreds, to a seaside cafe each week.
TimeVisitors
week 139
week 249
week 349
week 450
week 558
week 659
week 756

Give decimal answers to 1 decimal place.
(a) Work out all the 3-point moving averages for this data.
(b) Describe the trend shown by the moving averages.
(c) Use the last two of these moving averages to estimate the next moving average, assuming the trend continues.
(Total for Question 7 is 5 marks)
8
The table shows quarterly figures for monthly sales, in thousands of pounds, at a shop.
QuarterValue
2021 Q145
2021 Q263
2021 Q370
2021 Q456
2022 Q157
2022 Q275
2022 Q382
2022 Q468
2023 Q169
2023 Q287
2023 Q394
2023 Q480

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2021 Q4 quarter.
(c) State the seasonal effect for 2021 Q4, that is the value minus the centred moving average.
(Total for Question 8 is 5 marks)
9
The table shows quarterly figures for the number of customers at a garden centre each month, in hundreds.
QuarterValue
2020 Q147
2020 Q261
2020 Q371
2020 Q457
2021 Q155
2021 Q269
2021 Q379
2021 Q465
2022 Q163
2022 Q277
2022 Q387
2022 Q473

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2020 Q4 quarter.
(c) State the seasonal effect for 2020 Q4, that is the value minus the centred moving average.
(Total for Question 9 is 5 marks)
10
The table gives the number of visitors, in hundreds, to a seaside cafe each week.
TimeVisitors
week 157
week 262
week 363
week 474
week 579
week 685
week 779

Give decimal answers to 1 decimal place.
(a) Work out all the 3-point moving averages for this data.
(b) Describe the trend shown by the moving averages.
(c) Use the last two of these moving averages to estimate the next moving average, assuming the trend continues.
(Total for Question 10 is 5 marks)
11
The table shows quarterly figures for monthly sales, in thousands of pounds, at a shop.
QuarterValue
2020 Q149
2020 Q266
2020 Q382
2020 Q463
2021 Q165
2021 Q282
2021 Q398
2021 Q479
2022 Q181
2022 Q298
2022 Q3114
2022 Q495

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2021 Q1 quarter.
(c) State the seasonal effect for 2021 Q1, that is the value minus the centred moving average.
(Total for Question 11 is 5 marks)
12
The table shows quarterly figures for the number of customers at a garden centre each month, in hundreds.
QuarterValue
2020 Q148
2020 Q261
2020 Q366
2020 Q456
2021 Q156
2021 Q269
2021 Q374
2021 Q464
2022 Q164
2022 Q277
2022 Q382
2022 Q472

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2020 Q3 quarter.
(c) State the seasonal effect for 2020 Q3, that is the value minus the centred moving average.
(Total for Question 12 is 5 marks)
13
The table gives the number of ice creams sold at a stall each week.
TimeIce creams
week 139
week 237
week 345
week 442
week 553
week 650
week 754

Give decimal answers to 1 decimal place.
(a) Work out all the 3-point moving averages for this data.
(b) Describe the trend shown by the moving averages.
(c) Use the last two of these moving averages to estimate the next moving average, assuming the trend continues.
(Total for Question 13 is 5 marks)
14
The table shows quarterly figures for the number of visitors, in hundreds, to a seaside cafe each day.
QuarterValue
2021 Q146
2021 Q260
2021 Q371
2021 Q462
2022 Q158
2022 Q272
2022 Q383
2022 Q474
2023 Q170
2023 Q284
2023 Q395
2023 Q486

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2021 Q3 quarter.
(c) State the seasonal effect for 2021 Q3, that is the value minus the centred moving average.
(Total for Question 14 is 5 marks)
15
The table shows quarterly figures for the daily number of hot drinks sold at a kiosk.
QuarterValue
2022 Q161
2022 Q272
2022 Q384
2022 Q469
2023 Q169
2023 Q280
2023 Q392
2023 Q477
2024 Q177
2024 Q288
2024 Q3100
2024 Q485

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2022 Q4 quarter.
(c) State the seasonal effect for 2022 Q4, that is the value minus the centred moving average.
(Total for Question 15 is 5 marks)
16
The table gives the number of ice creams sold at a stall each week.
TimeIce creams
week 158
week 258
week 354
week 466
week 562
week 665

Give decimal answers to 1 decimal place.
(a) Work out all the 3-point moving averages for this data.
(b) Describe the trend shown by the moving averages.
(c) Use the last two of these moving averages to estimate the next moving average, assuming the trend continues.
(Total for Question 16 is 5 marks)
17
The table shows quarterly figures for the number of visitors, in hundreds, to a seaside cafe each day.
QuarterValue
2019 Q169
2019 Q283
2019 Q392
2019 Q483
2020 Q177
2020 Q291
2020 Q3100
2020 Q491
2021 Q185
2021 Q299
2021 Q3108
2021 Q499

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2019 Q3 quarter.
(c) State the seasonal effect for 2019 Q3, that is the value minus the centred moving average.
(Total for Question 17 is 5 marks)
18
The table shows quarterly figures for the number of customers at a garden centre each month, in hundreds.
QuarterValue
2019 Q159
2019 Q277
2019 Q386
2019 Q477
2020 Q171
2020 Q289
2020 Q398
2020 Q489
2021 Q183
2021 Q2101
2021 Q3110
2021 Q4101

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2020 Q1 quarter.
(c) State the seasonal effect for 2020 Q1, that is the value minus the centred moving average.
(Total for Question 18 is 5 marks)
19
The table gives weekly sales, in thousands of pounds, at a shop.
TimeSales
week 141
week 233
week 327
week 430
week 534
week 629
week 728

Give decimal answers to 1 decimal place.
(a) Work out all the 3-point moving averages for this data.
(b) Describe the trend shown by the moving averages.
(c) Use the last two of these moving averages to estimate the next moving average, assuming the trend continues.
(Total for Question 19 is 5 marks)
20
Riverside Bike Hire records the number of bikes it hires out each quarter.
QuarterY1 Q1Y1 Q2Y1 Q3Y1 Q4Y2 Q1Y2 Q2Y2 Q3Y2 Q4
Bikes hired30709050408010060

On the grid provided, draw a time series graph to show this information. Plot each point and join them, in order, with straight lines.
020406080100Y1 Q1Y1 Q2Y1 Q3Y1 Q4Y2 Q1Y2 Q2Y2 Q3Y2 Q4QuarterBikes hired
(Total for Question 20 is 5 marks)
21
The table shows quarterly figures for the number of customers at a garden centre each month, in hundreds.
QuarterValue
2019 Q168
2019 Q280
2019 Q398
2019 Q480
2020 Q184
2020 Q296
2020 Q3114
2020 Q496
2021 Q1100
2021 Q2112
2021 Q3130
2021 Q4112

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2020 Q1 quarter.
(c) State the seasonal effect for 2020 Q1, that is the value minus the centred moving average.
(Total for Question 21 is 5 marks)
22
The table shows quarterly figures for the daily number of hot drinks sold at a kiosk.
QuarterValue
2021 Q150
2021 Q264
2021 Q378
2021 Q468
2022 Q162
2022 Q276
2022 Q390
2022 Q480
2023 Q174
2023 Q288
2023 Q3102
2023 Q492

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2021 Q4 quarter.
(c) State the seasonal effect for 2021 Q4, that is the value minus the centred moving average.
(Total for Question 22 is 5 marks)
23
The table gives weekly sales, in thousands of pounds, at a shop.
TimeSales
week 140
week 242
week 347
week 442
week 541
week 651
week 758
week 855

Give decimal answers to 1 decimal place.
(a) Work out all the 3-point moving averages for this data.
(b) Describe the trend shown by the moving averages.
(c) Use the last two of these moving averages to estimate the next moving average, assuming the trend continues.
(Total for Question 23 is 5 marks)
24
The table shows quarterly figures for the number of customers at a garden centre each month, in hundreds.
QuarterValue
2021 Q154
2021 Q275
2021 Q384
2021 Q471
2022 Q170
2022 Q291
2022 Q3100
2022 Q487
2023 Q186
2023 Q2107
2023 Q3116
2023 Q4103

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2022 Q1 quarter.
(c) State the seasonal effect for 2022 Q1, that is the value minus the centred moving average.
(Total for Question 24 is 5 marks)
25
The table shows quarterly figures for monthly sales, in thousands of pounds, at a shop.
QuarterValue
2021 Q141
2021 Q261
2021 Q375
2021 Q461
2022 Q153
2022 Q273
2022 Q387
2022 Q473
2023 Q165
2023 Q285
2023 Q399
2023 Q485

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2021 Q4 quarter.
(c) State the seasonal effect for 2021 Q4, that is the value minus the centred moving average.
(Total for Question 25 is 5 marks)
26
The table gives the number of customers at a garden centre each week, in hundreds.
TimeCustomers
week 137
week 238
week 330
week 427
week 529
week 618
week 726

Give decimal answers to 1 decimal place.
(a) Work out all the 3-point moving averages for this data.
(b) Describe the trend shown by the moving averages.
(c) Use the last two of these moving averages to estimate the next moving average, assuming the trend continues.
(Total for Question 26 is 5 marks)
27
The table shows quarterly figures for monthly sales, in thousands of pounds, at a shop.
QuarterValue
2019 Q156
2019 Q276
2019 Q388
2019 Q477
2020 Q168
2020 Q288
2020 Q3100
2020 Q489
2021 Q180
2021 Q2100
2021 Q3112
2021 Q4101

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2019 Q4 quarter.
(c) State the seasonal effect for 2019 Q4, that is the value minus the centred moving average.
(Total for Question 27 is 5 marks)
28
Riverside Bike Hire's quarterly data is shown again.
QuarterY1 Q1Y1 Q2Y1 Q3Y1 Q4Y2 Q1Y2 Q2
Bikes hired307090504080
(a)Calculate the first three 4-point moving averages for this data, giving each answer to 1 decimal place where needed.(4)
(b)What do these three moving averages tell you about the trend in bike hire over this period?(1)
(Total for Question 28 is 5 marks)
29
The table shows quarterly figures for monthly sales, in thousands of pounds, at a shop.
QuarterValue
2022 Q156
2022 Q270
2022 Q378
2022 Q467
2023 Q164
2023 Q278
2023 Q386
2023 Q475
2024 Q172
2024 Q286
2024 Q394
2024 Q483

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2022 Q4 quarter.
(c) State the seasonal effect for 2022 Q4, that is the value minus the centred moving average.
(Total for Question 29 is 5 marks)
30
The table gives the number of ice creams sold at a stall each day.
TimeIce creams
day 148
day 245
day 346
day 439
day 543
day 639
day 732

Give decimal answers to 1 decimal place.
(a) Work out all the 3-point moving averages for this data.
(b) Describe the trend shown by the moving averages.
(c) Use the last two of these moving averages to estimate the next moving average, assuming the trend continues.
(Total for Question 30 is 5 marks)
31
The table shows quarterly figures for the number of ice creams sold at a stall each week.
QuarterValue
2019 Q147
2019 Q260
2019 Q371
2019 Q458
2020 Q163
2020 Q276
2020 Q387
2020 Q474
2021 Q179
2021 Q292
2021 Q3103
2021 Q490

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2019 Q3 quarter.
(c) State the seasonal effect for 2019 Q3, that is the value minus the centred moving average.
(Total for Question 31 is 5 marks)
32
The table shows quarterly figures for monthly sales, in thousands of pounds, at a shop.
QuarterValue
2021 Q157
2021 Q272
2021 Q388
2021 Q468
2022 Q165
2022 Q280
2022 Q396
2022 Q476
2023 Q173
2023 Q288
2023 Q3104
2023 Q484

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2021 Q4 quarter.
(c) State the seasonal effect for 2021 Q4, that is the value minus the centred moving average.
(Total for Question 32 is 5 marks)
33
The table gives the weekly number of hot drinks sold at a kiosk.
TimeDrinks
week 126
week 233
week 330
week 420
week 514
week 616

Give decimal answers to 1 decimal place.
(a) Work out all the 3-point moving averages for this data.
(b) Describe the trend shown by the moving averages.
(c) Use the last two of these moving averages to estimate the next moving average, assuming the trend continues.
(Total for Question 33 is 5 marks)
34
The table shows quarterly figures for the number of customers at a garden centre each month, in hundreds.
QuarterValue
2020 Q155
2020 Q274
2020 Q393
2020 Q473
2021 Q167
2021 Q286
2021 Q3105
2021 Q485
2022 Q179
2022 Q298
2022 Q3117
2022 Q497

(a) Work out the 4-point moving average for the first four quarters.
(b) Work out the 4-point centred moving average for the 2020 Q3 quarter.
(c) State the seasonal effect for 2020 Q3, that is the value minus the centred moving average.
(Total for Question 34 is 5 marks)
35
Riverside Bike Hire's quarterly data (see Question 28) is smoothed using a 4-point moving average rather than a 3-point or 5-point moving average. Explain why a 4-point moving average is used for this data rather than a 3-point or 5-point moving average.
(Total for Question 35 is 2 marks)
36
Riverside Bike Hire's quarterly data is shown again.
QuarterY1 Q1Y1 Q2Y1 Q3Y1 Q4Y2 Q1Y2 Q2
Bikes hired307090504080
(a)Which of these calculations gives the second 4-point moving average for this data?(1)
  • A) (30 + 70 + 90 + 50) / 4
  • B) (70 + 90 + 50 + 40) / 4
  • C) (90 + 50 + 40 + 80) / 4
  • D) (30 + 70 + 90 + 50 + 40) / 5
(b)Hence write down the value of this moving average.(1)
(Total for Question 36 is 2 marks)
37
A different branch of the same company, Elm Grove Bike Hire, produces five successive 4-point moving averages, in order: 58, 61, 60, 64, 67.
(a)State whether the trend is increasing, decreasing, or roughly constant.(1)
(b)Give a reason for your answer, using values from the list.(1)
(c)A customer claims that, because the trend is increasing, Quarter 3 rentals must always be the highest quarter of the year at every branch. Is the customer correct? Write Yes or No, and give a brief reason.(2)
(Total for Question 37 is 4 marks)
38
Mill Lane Market Stall opens on Wednesday, Friday and Saturday each week. The table shows the stall's takings, in pounds, on each trading day.
DayWeek 1 WedWeek 1 FriWeek 1 SatWeek 2 Wed
Takings (£)120150210135
(a)Since the stall trades 3 times a week, calculate the first two 3-point moving averages for this data.(3)
(b)What do these two moving averages suggest about the trend in the stall's takings?(1)
(Total for Question 38 is 4 marks)
39
Riverside Bike Hire has now recorded 8 complete quarters of data (see Question 20).
(a)Calculate how many 4-point moving averages can be found from these 8 quarters of data. Show how you worked this out.(2)
(b)Explain why no moving average value can be plotted at Y1 Q1 or at Y2 Q4.(1)
(Total for Question 39 is 3 marks)
40
Elmwood Community Library wants to investigate whether the number of books borrowed each quarter shows both a repeating seasonal pattern and a long-term trend, to help decide how many staff to schedule on the enquiries desk each quarter.
(a)Plan: state an appropriate time interval over which to collect loan data, and explain why at least two full years of data should be collected before drawing any conclusion about seasonality.(2)
(b)Collect: state one advantage of using the library's own computerised loan-return records (a secondary data source) rather than carrying out a new survey of members.(1)
(c)Process: the table shows quarterly book loans, in hundreds, for two years.
QuarterY1 Q1Y1 Q2Y1 Q3Y1 Q4Y2 Q1Y2 Q2
Books borrowed (hundreds)423026504634

Calculate the first two 4-point moving averages for this data.
(3)
(d)Interpret: three further moving averages, continuing from part (c), are 39.5, 41 and 42.5. Using all five values, describe the trend, and suggest one staffing decision the library could make based on it, linking back to the original purpose of the investigation.(3)
(Total for Question 40 is 9 marks)
41
Riverside Bike Hire's 8 quarters of data (see Question 20) are shown again on the graph below.
020406080100Y1 Q1Y1 Q2Y1 Q3Y1 Q4Y2 Q1Y2 Q2Y2 Q3Y2 Q4QuarterBikes hired / moving average
(a)Calculate the 4th and 5th 4-point moving averages for this data (continuing on from the three you found in Question 28).(3)
(b)Plot all five moving averages (your three from Question 28, and these two) on the graph, marking each with a cross (X) at the correct point in time. Use the five dashed guide lines shown to help you.(2)
(Total for Question 41 is 5 marks)
42
The graph shows the moving-average trend lines for membership numbers at two branches of BrightFit Gym over the same 8 quarters.
020406080100Q1Q2Q3Q4Q5Q6Q7Q8QuarterMembership trendBrightFit NorthBrightFit South
(a)Identify which branch shows an increasing trend, and which branch shows a roughly constant (flat) trend.(2)
(b)The manager of BrightFit South says: 'Our trend line is flat, so our gym is never busier in some quarters than in others.' Comment on whether this is a fair conclusion.(2)
(Total for Question 42 is 4 marks)
43
Coastview Pier arcade records the number of tokens sold each quarter, along with the trend value (from a moving average) for that quarter.
QuarterY1 Q2Y1 Q3Y1 Q4Y2 Q1
Actual tokens sold (hundreds)70935144
Trend (from moving average)60636669
(a)Calculate the seasonal variation (actual value minus trend value) for each of the four quarters shown.(4)
(b)Seasonal variations for a full year should sum to (approximately) zero. Use this fact to check your answers to part (a).(2)
(c)State which quarter has the largest positive seasonal variation, and explain what this means in context.(2)
(Total for Question 43 is 8 marks)
44
Coastview Pier arcade's trend value at Y2 Q1 is 69 (see Question 43), and this trend is expected to keep increasing by 3 each quarter. The seasonal variation for Quarter 2 was found to be +10.
(a)Predict the trend value for Y2 Q2, assuming the trend keeps increasing by 3 each quarter.(2)
(b)Hence forecast the actual number of tokens (in hundreds) the arcade will sell in Y2 Q2, using the trend value from part (a) and the seasonal variation for Quarter 2.(2)
(c)Give one reason why this forecast might not turn out to be accurate.(2)
(Total for Question 44 is 6 marks)
45
Riverside Bike Hire (see Questions 20, 28 and 41) has now recorded three full years of quarterly data. The graph shows all 12 quarters of raw bike hire figures, together with all nine 4-point moving averages, already plotted as squares. The horizontal axis has been extended to include Year 4 Quarter 1 and Year 4 Quarter 2.
020406080100120Y1Q1Y1Q2Y1Q3Y1Q4Y2Q1Y2Q2Y2Q3Y2Q4Y3Q1Y3Q2Y3Q3Y3Q4Y4Q1Y4Q2QuarterBikes hired / moving averageActual quarterly rentals4-point moving average
(a)By eye, draw a single straight trend line through the nine moving-average points.(2)
(b)Use your trend line to estimate the trend value at Year 4 Quarter 2, by extending the line to that point on the graph.(2)
(c)Comment on the reliability of this prediction.(2)
(Total for Question 45 is 6 marks)
Mark scheme · 4.8 Time Series

Question 1

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

Question 2

  • (a) 20 caoB1
  • (a) Answer: 20
  • (b) Quarter 3 (Q3) caoB1
  • (b) Answer: Quarter 3
  • (c) identifies both the repeating seasonal pattern (high in Q4 and Q1, low in Q2 and Q3) and that Year 2 is higher than Year 1 overall, oeB1
  • (c) Answer: Bookings rise and fall in the same seasonal pattern each year (highest in Q4 and Q1, lowest in Q2 and Q3), and Year 2 bookings are higher than Year 1 in every matching quarter.
  • (d) Seasonal variation caoB1
  • (d) Answer: Seasonal variation

Question 3

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

Question 4

  • adds four consecutive values and divides by 4M1
  • 78.5 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 83.5 caoA1
  • -12.5 caoB1
  • Answer: (a) 78.5; (b) 83.5; (c) -12.5

Question 5

  • adds four consecutive values and divides by 4M1
  • 83.5 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 88.5 caoA1
  • -5.5 caoB1
  • Answer: (a) 83.5; (b) 88.5; (c) -5.5

Question 6

  • adds four consecutive values and divides by 4M1
  • 69.5 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 74.5 caoA1
  • -8.5 caoB1
  • Answer: (a) 69.5; (b) 74.5; (c) -8.5

Question 7

  • adds three consecutive values and divides by 3M1
  • all 5 moving averages 45.7, 49.3, 52.3, 55.7, 57.7 caoA1
  • trend is increasingB1
  • last moving average plus (last minus the one before)M1
  • 59.7 caoA1
  • Answer: (a) 45.7, 49.3, 52.3, 55.7, 57.7; (b) increasing; (c) 59.7

Question 8

  • adds four consecutive values and divides by 4M1
  • 58.5 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 63 caoA1
  • -7 caoB1
  • Answer: (a) 58.5; (b) 63; (c) -7

Question 9

  • adds four consecutive values and divides by 4M1
  • 59 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 62 caoA1
  • -5 caoB1
  • Answer: (a) 59; (b) 62; (c) -5

Question 10

  • adds three consecutive values and divides by 3M1
  • all 5 moving averages 60.7, 66.3, 72, 79.3, 81 caoA1
  • trend is increasingB1
  • last moving average plus (last minus the one before)M1
  • 82.7 caoA1
  • Answer: (a) 60.7, 66.3, 72, 79.3, 81; (b) increasing; (c) 82.7

Question 11

  • adds four consecutive values and divides by 4M1
  • 65 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 75 caoA1
  • -10 caoB1
  • Answer: (a) 65; (b) 75; (c) -10

Question 12

  • adds four consecutive values and divides by 4M1
  • 57.75 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 58.75 caoA1
  • 7.25 caoB1
  • Answer: (a) 57.75; (b) 58.75; (c) 7.25

Question 13

  • adds three consecutive values and divides by 3M1
  • all 5 moving averages 40.3, 41.3, 46.7, 48.3, 52.3 caoA1
  • trend is increasingB1
  • last moving average plus (last minus the one before)M1
  • 56.3 caoA1
  • Answer: (a) 40.3, 41.3, 46.7, 48.3, 52.3; (b) increasing; (c) 56.3

Question 14

  • adds four consecutive values and divides by 4M1
  • 59.75 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 61.25 caoA1
  • 9.75 caoB1
  • Answer: (a) 59.75; (b) 61.25; (c) 9.75

Question 15

  • adds four consecutive values and divides by 4M1
  • 71.5 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 74.5 caoA1
  • -5.5 caoB1
  • Answer: (a) 71.5; (b) 74.5; (c) -5.5

Question 16

  • adds three consecutive values and divides by 3M1
  • all 4 moving averages 56.7, 59.3, 60.7, 64.3 caoA1
  • trend is increasingB1
  • last moving average plus (last minus the one before)M1
  • 68 (accept 67.9, from moving averages rounded to 1 decimal place)A1
  • Answer: (a) 56.7, 59.3, 60.7, 64.3; (b) increasing; (c) 68

Question 17

  • adds four consecutive values and divides by 4M1
  • 81.75 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 82.75 caoA1
  • 9.25 caoB1
  • Answer: (a) 81.75; (b) 82.75; (c) 9.25

Question 18

  • adds four consecutive values and divides by 4M1
  • 74.75 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 82.25 caoA1
  • -11.25 caoB1
  • Answer: (a) 74.75; (b) 82.25; (c) -11.25

Question 19

  • adds three consecutive values and divides by 3M1
  • all 5 moving averages 33.7, 30, 30.3, 31, 30.3 caoA1
  • trend is generally decreasing (accept a description that notes the overall fall with a small dip or levelling)B1
  • last moving average plus (last minus the one before)M1
  • 29.7 (accept 29.6, from moving averages rounded to 1 decimal place)A1
  • Answer: (a) 33.7, 30, 30.3, 31, 30.3; (b) generally decreasing; (c) 29.7

Question 20

  • a suitable uniform scale chosen on the vertical axis, starting at 0B1
  • the first four points plotted correctly: 30, 70, 90, 50 (± half a small square)B1
  • the last four points plotted correctly: 40, 80, 100, 60 (± half a small square)B1
  • all 8 points joined, in time order, with straight line segmentsB1
  • graph fully labelled, with both axes labelledB1
  • Answer: Time series graph with points at 30, 70, 90, 50, 40, 80, 100, 60 joined in order.

Question 21

  • adds four consecutive values and divides by 4M1
  • 81.5 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 91.5 caoA1
  • -7.5 caoB1
  • Answer: (a) 81.5; (b) 91.5; (c) -7.5

Question 22

  • adds four consecutive values and divides by 4M1
  • 65 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 69.5 caoA1
  • -1.5 caoB1
  • Answer: (a) 65; (b) 69.5; (c) -1.5

Question 23

  • adds three consecutive values and divides by 3M1
  • all 6 moving averages 43, 43.7, 43.3, 44.7, 50, 54.7 caoA1
  • trend is generally increasing (accept a description that notes the overall rise with a small dip or levelling)B1
  • last moving average plus (last minus the one before)M1
  • 59.3 (accept 59.4, from moving averages rounded to 1 decimal place)A1
  • Answer: (a) 43, 43.7, 43.3, 44.7, 50, 54.7; (b) generally increasing; (c) 59.3

Question 24

  • adds four consecutive values and divides by 4M1
  • 71 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 81 caoA1
  • -11 caoB1
  • Answer: (a) 71; (b) 81; (c) -11

Question 25

  • adds four consecutive values and divides by 4M1
  • 59.5 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 64 caoA1
  • -3 caoB1
  • Answer: (a) 59.5; (b) 64; (c) -3

Question 26

  • adds three consecutive values and divides by 3M1
  • all 5 moving averages 35, 31.7, 28.7, 24.7, 24.3 caoA1
  • trend is decreasingB1
  • last moving average plus (last minus the one before)M1
  • 24 (accept 23.9, from moving averages rounded to 1 decimal place)A1
  • Answer: (a) 35, 31.7, 28.7, 24.7, 24.3; (b) decreasing; (c) 24

Question 27

  • adds four consecutive values and divides by 4M1
  • 74.25 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 78.75 caoA1
  • -1.75 caoB1
  • Answer: (a) 74.25; (b) 78.75; (c) -1.75

Question 28

  • (a) correct method shown for at least one moving average, e.g. (30+70+90+50)/4M1
  • (a) 60 caoA1
  • (a) 62.5 caoA1
  • (a) 65 caoA1
  • (a) Answer: 60, 62.5, 65
  • (b) the trend is increasing/rising, since the moving averages increase from 60 to 62.5 to 65, oeB1
  • (b) Answer: The trend is increasing.

Question 29

  • adds four consecutive values and divides by 4M1
  • 67.75 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 70.75 caoA1
  • -3.75 caoB1
  • Answer: (a) 67.75; (b) 70.75; (c) -3.75

Question 30

  • adds three consecutive values and divides by 3M1
  • all 5 moving averages 46.3, 43.3, 42.7, 40.3, 38 caoA1
  • trend is decreasingB1
  • last moving average plus (last minus the one before)M1
  • 35.7 caoA1
  • Answer: (a) 46.3, 43.3, 42.7, 40.3, 38; (b) decreasing; (c) 35.7

Question 31

  • adds four consecutive values and divides by 4M1
  • 59 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 61 caoA1
  • 10 caoB1
  • Answer: (a) 59; (b) 61; (c) 10

Question 32

  • adds four consecutive values and divides by 4M1
  • 71.25 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 74.25 caoA1
  • -6.25 caoB1
  • Answer: (a) 71.25; (b) 74.25; (c) -6.25

Question 33

  • adds three consecutive values and divides by 3M1
  • all 4 moving averages 29.7, 27.7, 21.3, 16.7 caoA1
  • trend is decreasingB1
  • last moving average plus (last minus the one before)M1
  • 12 (accept 12.1, from moving averages rounded to 1 decimal place)A1
  • Answer: (a) 29.7, 27.7, 21.3, 16.7; (b) decreasing; (c) 12

Question 34

  • adds four consecutive values and divides by 4M1
  • 73.75 caoA1
  • averages two consecutive 4-point moving averagesM1
  • 75.25 caoA1
  • 17.75 caoB1
  • Answer: (a) 73.75; (b) 75.25; (c) 17.75

Question 35

  • there are 4 quarters in a yearB1
  • so each group of 4 consecutive values includes exactly one value from each quarter/season, so the seasonal effect cancels out and only the trend remains, oeB1
  • Answer: A 4-point moving average is used because there are 4 quarters in a year, so every group of 4 consecutive values contains exactly one value from each season - this cancels out the seasonal variation and leaves only the trend.

Question 36

  • (a) B caoB1
  • (a) Answer: B) (70 + 90 + 50 + 40) / 4
  • (b) 62.5 caoB1
  • (b) Answer: 62.5

Question 37

  • (a) Increasing caoB1
  • (a) Answer: Increasing
  • (b) compares the first and last values (e.g. 67 is greater than 58), or notes the values generally rise overall, oeB1
  • (b) Answer: The final moving average (67) is higher than the first (58), and the values generally rise across the list.
  • (c) NoB1
  • (c) moving averages smooth out/remove the seasonal variation between quarters, so the trend on its own cannot show which individual quarter is highest within a year, oeB1
  • (c) Answer: No - the moving average removes the seasonal variation between quarters, so it cannot show which individual quarter has the highest raw rentals within a year.

Question 38

  • (a) correct method shown, e.g. (120+150+210)/3M1
  • (a) 160 caoA1
  • (a) 165 caoA1
  • (a) Answer: 160, 165
  • (b) the trend is increasing, since the moving average rises from 160 to 165, oeB1
  • (b) Answer: The trend is increasing.

Question 39

  • (a) correct method, e.g. 8 - 4 + 1, or lists the valid groups (quarters 1-4, 2-5, 3-6, 4-7, 5-8)M1
  • (a) 5 caoA1
  • (a) Answer: 5
  • (b) each moving average is plotted at the midpoint in time of the 4 values used; Y1 Q1 and Y2 Q4 are always at the very start or end of a group of 4, never at the middle, so no moving average is centred there, oeB1
  • (b) Answer: Y1 Q1 and Y2 Q4 can never be the midpoint of a group of 4 consecutive quarters, so no moving average is plotted there.

Question 40

  • (a) states a suitable interval, e.g. quarterly (or monthly)B1
  • (a) explains that at least two full cycles/years are needed to check that a pattern genuinely repeats, rather than being a one-off event in a single year, oeB1
  • (a) Answer: Record the number of books borrowed each quarter, for at least two full years, so any pattern can be checked for repeating rather than being a one-off.
  • (b) e.g. the data already exists / records every loan exactly / is quicker and cheaper than running a new survey, oeB1
  • (b) Answer: Loan-return records already exist and count every loan exactly, so they are quicker and cheaper to use than collecting new survey data.
  • (c) correct method shown, e.g. (42+30+26+50)/4M1
  • (c) 37 caoA1
  • (c) 38 caoA1
  • (c) Answer: 37, 38
  • (d) trend is increasing (book loans are rising from one year to the next), since 37, 38, 39.5, 41, 42.5 rises steadilyB1
  • (d) identifies from the raw data that Quarter 4 (and Quarter 1) tend to be busier within the year than Quarter 2 or Quarter 3 (e.g. Y1 Q4 = 50, Y1 Q1 = 42, compared with Q2 = 30 and Q3 = 26)B1
  • (d) gives a sensible staffing recommendation linked to the purpose, e.g. schedule extra enquiries-desk staff every Quarter 4 and Quarter 1, and gradually increase baseline staffing over time as the underlying trend rises, oeB1
  • (d) Answer: The trend is increasing; Quarter 4 and Quarter 1 are the busier quarters each year, so the library should schedule extra enquiries-desk staff in those quarters and gradually increase overall staffing as the rising trend continues.

Question 41

  • (a) correct method shown, e.g. (50+40+80+100)/4M1
  • (a) 67.5 caoA1
  • (a) 70 caoA1
  • (a) Answer: 67.5, 70
  • (b) first three moving averages (60, 62.5, 65) plotted at the correct guide lines, ± half a small squareB1
  • (b) next two moving averages (67.5, 70) plotted at the correct guide lines, ± half a small squareB1
  • (b) Answer: Points at (between Y1Q2/Y1Q3, 60), (between Y1Q3/Y1Q4, 62.5), (between Y1Q4/Y2Q1, 65), (between Y2Q1/Y2Q2, 67.5), (between Y2Q2/Y2Q3, 70).

Question 42

  • (a) BrightFit North - increasing trendB1
  • (a) BrightFit South - roughly constant/flat trendB1
  • (a) Answer: BrightFit North: increasing. BrightFit South: roughly constant.
  • (b) not fair/not correct - a flat trend only means the underlying long-term average is not rising or fallingB1
  • (b) the raw quarterly membership figures can still rise and fall with the season (e.g. a January new year rush) around a flat trend; the moving average simply smooths/removes that seasonal variation from view, oeB1
  • (b) Answer: Not a fair conclusion. A flat trend line only shows that the long-term average is not changing - BrightFit South's raw quarterly numbers could still rise and fall with the seasons (for example, a January rush); the moving average has simply smoothed that seasonal variation out of the graph.

Question 43

  • (a) Y1 Q2: +10 caoB1
  • (a) Y1 Q3: +30 caoB1
  • (a) Y1 Q4: -15 caoB1
  • (a) Y2 Q1: -25 caoB1
  • (a) Answer: +10, +30, -15, -25
  • (b) sums all four seasonal variations found: 10+30-15-25M1
  • (b) sum = 0, confirming the values in part (a) are consistent with the rule, oeA1
  • (b) Answer: 10 + 30 - 15 - 25 = 0, which confirms the seasonal variations are consistent.
  • (c) Y1 Q3B1
  • (c) token sales in Quarter 3 are typically about 30 (hundred) higher than the underlying trend, e.g. because it is the busiest (summer) season for a pier arcade, oeB1
  • (c) Answer: Y1 Q3, with seasonal variation +30 - arcade token sales in Quarter 3 are typically about 3000 above the trend, consistent with Quarter 3 (summer) being the busiest season for a seaside pier.

Question 44

  • (a) 69 + 3M1
  • (a) 72 caoA1
  • (a) Answer: 72
  • (b) 72 + 10M1
  • (b) 82 caoA1
  • (b) Answer: 82
  • (c) a valid reason that the trend or seasonal pattern might not continue as assumed, e.g. unusually poor weather that quarter, a new arcade opening nearby, a change in ticket prices, or any other sensible real-world factor, oeB2
  • (c) Answer: For example, unusually poor weather in Quarter 2 could reduce visitor numbers below the forecast, or a new arcade opening nearby could take away some customers, so the trend and seasonal pattern might not continue exactly as assumed.

Question 45

  • (a) a single straight line is drawn (a ruled line, not curved or joining every point exactly)B1
  • (a) the line follows the general increasing direction of the moving-average points, passing reasonably close to themB1
  • (a) Answer: A straight, rising line drawn through (or close to) the nine moving-average squares, from about 60 up to about 80.
  • (b) extends the ruled trend line beyond the plotted points as far as the Y4 Q2 guide lineM1
  • (b) a value consistent with the candidate's own trend line, accept 85 to 95 (ft)A1
  • (b) Answer: Approximately 88 to 89 (accept any value from 85 to 95 consistent with the candidate's own line).
  • (c) identifies that this is extrapolation - predicting beyond the range of the given data - which assumes the trend continues in exactly the same wayB1
  • (c) a suitable contextual limitation, e.g. bike hire demand depends on weather which varies year to year, a competitor bike scheme could open nearby, or the hire prices/opening hours could change, so the prediction may not be reliable, oeB1
  • (c) Answer: The prediction is an extrapolation beyond the data collected, and assumes the trend continues exactly as before. In reality, bike hire numbers depend heavily on the weather, which varies from year to year, and a new competing bike scheme could open nearby, so the prediction may not be reliable.

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

4 marks
Did your answer earn the marks?

Question 3

4 marks
Did your answer earn the marks?

Question 4

5 marks
Did your answer earn the marks?

Question 5

5 marks
Did your answer earn the marks?

Question 6

5 marks
Did your answer earn the marks?

Question 7

5 marks
Did your answer earn the marks?

Question 8

5 marks
Did your answer earn the marks?

Question 9

5 marks
Did your answer earn the marks?

Question 10

5 marks
Did your answer earn the marks?

Question 11

5 marks
Did your answer earn the marks?

Question 12

5 marks
Did your answer earn the marks?

Question 13

5 marks
Did your answer earn the marks?

Question 14

5 marks
Did your answer earn the marks?

Question 15

5 marks
Did your answer earn the marks?

Question 16

5 marks
Did your answer earn the marks?

Question 17

5 marks
Did your answer earn the marks?

Question 18

5 marks
Did your answer earn the marks?

Question 19

5 marks
Did your answer earn the marks?

Question 20

5 marks
Did your answer earn the marks?

Question 21

5 marks
Did your answer earn the marks?

Question 22

5 marks
Did your answer earn the marks?

Question 23

5 marks
Did your answer earn the marks?

Question 24

5 marks
Did your answer earn the marks?

Question 25

5 marks
Did your answer earn the marks?

Question 26

5 marks
Did your answer earn the marks?

Question 27

5 marks
Did your answer earn the marks?

Question 28

5 marks
Did your answer earn the marks?

Question 29

5 marks
Did your answer earn the marks?

Question 30

5 marks
Did your answer earn the marks?

Question 31

5 marks
Did your answer earn the marks?

Question 32

5 marks
Did your answer earn the marks?

Question 33

5 marks
Did your answer earn the marks?

Question 34

5 marks
Did your answer earn the marks?

Question 35

2 marks
Did your answer earn the marks?

Question 36(a)

1 mark
Choose an answer

Question 36(b)

1 mark

Question 37

4 marks
Did your answer earn the marks?

Question 38

4 marks
Did your answer earn the marks?

Question 39

3 marks
Did your answer earn the marks?

Question 40

9 marks
Did your answer earn the marks?

Question 41

5 marks
Did your answer earn the marks?

Question 42

4 marks
Did your answer earn the marks?

Question 43

8 marks
Did your answer earn the marks?

Question 44

6 marks
Did your answer earn the marks?

Question 45

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

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