Skip to the worksheet
Revision Library
Choose a subject

Time Series and Moving Averages - Worksheets, Questions and Revision

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

This topic is chapter 3 of GCSE Statistics Foundation Topic Workbook 5 and chapter 6 of GCSE Statistics Higher Topic Workbook 6.

Revision Library
revisionlibrary.co.uk
GCSE · Statistics

4.6 Time Series and Moving Averages

EDEXCEL 1ST0 · Calculator allowed · about 230 minutes
Total Marks
Name: _______________________________    Date: ____ / ____ / ______
Answer ALL questions. Show all your working.
1
Statisticians use special words to describe patterns in data collected over time.
(a)State the name given to the smooth, general direction of change shown by a moving average, once the ups and downs within each year have been smoothed out.(1)
(b)State the name given to the regular rise and fall in a time series that repeats in the same way each year, such as ice cream sales rising every summer.(1)
(Total for Question 1 is 2 marks)
2
State the name given to a pattern that rises and falls in the same way at the same point in every year, such as ice lolly sales rising every summer.
(Total for Question 2 is 1 mark)
3
Write down whether this statement is True or False.
A 4-point moving average value is plotted at the same time point as the last of the 4 values used to calculate it.
(Total for Question 3 is 1 mark)
4
The Bay View Ice Cream Kiosk records the number of ice creams it sells each quarter. The time series graph shows sales for Year 1 and Year 2.
020406080100Y1 Q1Y1 Q2Y1 Q3Y1 Q4Y2 Q1Y2 Q2Y2 Q3Y2 Q4QuarterIce creams sold
(a)Write down the number of ice creams sold in Year 2 Quarter 3.(1)
(b)Write down the quarter in which sales are lowest in both Year 1 and Year 2.(1)
(c)Describe, in one sentence, the pattern shown by the graph over the two years.(1)
(Total for Question 4 is 3 marks)
5
For each statement about time series and moving averages, write down whether it is True or False.
(i)A time series is a set of observations recorded at successive points in time, usually at equal intervals.(1)
(ii)A 4-point moving average is found by adding 4 consecutive data values and dividing the total by 4.(1)
(iii)Each 4-point moving average value is plotted at the same time point as the last of the 4 values used to calculate it.(1)
(iv)The trend is the underlying long-term pattern that remains once a moving average has smoothed out seasonal variation.(1)
(Total for Question 5 is 4 marks)
6
Write down whether this statement is True or False.
Seasonal variation repeats in exactly the same way, with no exceptions, in every single year.
(Total for Question 6 is 1 mark)
7
The total of four consecutive quarterly sales figures is 150. Work out the 4-point moving average for this data.
(Total for Question 7 is 1 mark)
8
The first three 4-point moving averages for a cafe's quarterly sales are 40, 42, 44. State whether the trend is increasing, decreasing, or roughly constant.
(Total for Question 8 is 1 mark)
9
The table gives the number of customers at a garden centre each week, in hundreds.
TimeCustomers
week 156
week 255
week 359
week 453
week 559
week 661
week 760

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 9 is 5 marks)
10
The table shows quarterly figures for the number of visitors, in hundreds, to a seaside cafe each day.
QuarterValue
2022 Q159
2022 Q276
2022 Q387
2022 Q479
2023 Q175
2023 Q292
2023 Q3103
2023 Q495
2024 Q191
2024 Q2108
2024 Q3119
2024 Q4111

(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 Q3 quarter.
(c) State the seasonal effect for 2022 Q3, that is the value minus the centred moving average.
(Total for Question 10 is 5 marks)
11
The table gives the weekly number of hot drinks sold at a kiosk.
TimeDrinks
week 139
week 238
week 346
week 453
week 558
week 660

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 11 is 5 marks)
12
The table shows quarterly figures for the number of customers at a garden centre each month, in hundreds.
QuarterValue
2019 Q154
2019 Q272
2019 Q379
2019 Q469
2020 Q166
2020 Q284
2020 Q391
2020 Q481
2021 Q178
2021 Q296
2021 Q3103
2021 Q493

(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 12 is 5 marks)
13
The table gives weekly sales, in thousands of pounds, at a shop.
TimeSales
week 150
week 249
week 356
week 456
week 554
week 657
week 764

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 daily number of hot drinks sold at a kiosk.
QuarterValue
2020 Q164
2020 Q276
2020 Q386
2020 Q475
2021 Q172
2021 Q284
2021 Q394
2021 Q483
2022 Q180
2022 Q292
2022 Q3102
2022 Q491

(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 14 is 5 marks)
15
The table gives the number of ice creams sold at a stall each week.
TimeIce creams
week 149
week 252
week 354
week 465
week 557
week 661
week 775

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 15 is 5 marks)
16
The table gives the number of customers at a garden centre each week, in hundreds.
TimeCustomers
week 156
week 246
week 347
week 444
week 540
week 639

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 customers at a garden centre each month, in hundreds.
QuarterValue
2022 Q160
2022 Q279
2022 Q393
2022 Q479
2023 Q172
2023 Q291
2023 Q3105
2023 Q491
2024 Q184
2024 Q2103
2024 Q3117
2024 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 Q4 quarter.
(c) State the seasonal effect for 2022 Q4, that is the value minus the centred moving average.
(Total for Question 17 is 5 marks)
18
The table gives the number of ice creams sold at a stall each week.
TimeIce creams
week 122
week 230
week 325
week 435
week 534
week 632
week 737

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 18 is 5 marks)
19
The table gives weekly sales, in thousands of pounds, at a shop.
TimeSales
week 147
week 251
week 352
week 459
week 558
week 664
week 761
week 866

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
The table shows quarterly figures for the number of visitors, in hundreds, to a seaside cafe each day.
QuarterValue
2021 Q146
2021 Q263
2021 Q377
2021 Q464
2022 Q158
2022 Q275
2022 Q389
2022 Q476
2023 Q170
2023 Q287
2023 Q3101
2023 Q488

(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 20 is 5 marks)
21
The table gives the number of customers at a garden centre each week, in hundreds.
TimeCustomers
week 150
week 251
week 344
week 446
week 539
week 639
week 737
week 837

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 21 is 5 marks)
22
The table gives the daily number of hot drinks sold at a kiosk.
TimeDrinks
day 160
day 262
day 365
day 456
day 558
day 660

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 22 is 5 marks)
23
The table shows quarterly figures for the number of ice creams sold at a stall each week.
QuarterValue
2021 Q153
2021 Q270
2021 Q379
2021 Q467
2022 Q161
2022 Q278
2022 Q387
2022 Q475
2023 Q169
2023 Q286
2023 Q395
2023 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 Q1 quarter.
(c) State the seasonal effect for 2022 Q1, that is the value minus the centred moving average.
(Total for Question 23 is 5 marks)
24
The table gives daily sales, in thousands of pounds, at a shop.
TimeSales
day 149
day 240
day 348
day 455
day 552
day 649
day 759

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 24 is 5 marks)
25
The table shows quarterly figures for the number of customers at a garden centre each month, in hundreds.
QuarterValue
2019 Q143
2019 Q257
2019 Q370
2019 Q459
2020 Q151
2020 Q265
2020 Q378
2020 Q467
2021 Q159
2021 Q273
2021 Q386
2021 Q475

(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 25 is 5 marks)
26
The table gives the number of customers at a garden centre each day, in hundreds.
TimeCustomers
day 135
day 234
day 345
day 447
day 553
day 654
day 759

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 the number of ice creams sold at a stall each week.
QuarterValue
2019 Q173
2019 Q286
2019 Q3104
2019 Q489
2020 Q185
2020 Q298
2020 Q3116
2020 Q4101
2021 Q197
2021 Q2110
2021 Q3128
2021 Q4113

(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 27 is 5 marks)
28
The table gives the number of ice creams sold at a stall each day.
TimeIce creams
day 152
day 258
day 365
day 469
day 564
day 665
day 775

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 28 is 5 marks)
29
A pharmacy records the number of bottles of sun cream it sells each quarter.
QuarterY1 Q1Y1 Q2Y1 Q3Y1 Q4Y2 Q1Y2 Q2Y2 Q3Y2 Q4
Bottles sold1040702020508030

On the grid provided, draw a time series graph to show this information. Plot each point and join them, in order, with straight lines.
01020304050607080Y1 Q1Y1 Q2Y1 Q3Y1 Q4Y2 Q1Y2 Q2Y2 Q3Y2 Q4QuarterBottles of sun cream sold
(Total for Question 29 is 5 marks)
30
The table gives the weekly number of hot drinks sold at a kiosk.
TimeDrinks
week 151
week 255
week 361
week 456
week 558
week 667

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
2022 Q162
2022 Q280
2022 Q398
2022 Q484
2023 Q174
2023 Q292
2023 Q3110
2023 Q496
2024 Q186
2024 Q2104
2024 Q3122
2024 Q4108

(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 Q3 quarter.
(c) State the seasonal effect for 2022 Q3, that is the value minus the centred moving average.
(Total for Question 31 is 5 marks)
32
The table gives the number of ice creams sold at a stall each day.
TimeIce creams
day 157
day 258
day 357
day 461
day 575
day 673

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 32 is 5 marks)
33
The table gives the number of customers at a garden centre each week, in hundreds.
TimeCustomers
week 155
week 262
week 358
week 464
week 565
week 675
week 777
week 875

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 Q156
2020 Q272
2020 Q390
2020 Q475
2021 Q168
2021 Q284
2021 Q3102
2021 Q487
2022 Q180
2022 Q296
2022 Q3114
2022 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 2021 Q1 quarter.
(c) State the seasonal effect for 2021 Q1, that is the value minus the centred moving average.
(Total for Question 34 is 5 marks)
35
The table gives the number of visitors, in hundreds, to a seaside cafe each day.
TimeVisitors
day 158
day 250
day 345
day 447
day 549
day 646
day 738

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 35 is 5 marks)
36
The table gives weekly sales, in thousands of pounds, at a shop.
TimeSales
week 144
week 240
week 335
week 443
week 534
week 630

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 36 is 5 marks)
37
A garden centre records the number of bags of compost it sells each quarter.
QuarterY1 Q1Y1 Q2Y1 Q3Y1 Q4Y2 Q1Y2 Q2
Bags of compost sold5488112465894
(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 compost sales over this period?(1)
(Total for Question 37 is 5 marks)
38
Quarterly data, like the compost sales in Question 37, is smoothed using a 4-point moving average rather than a 3-point or 5-point moving average.
(Total for Question 38 is 2 marks)
39
A garden centre's quarterly compost sales are shown again.
QuarterY1 Q1Y1 Q2Y1 Q3Y1 Q4Y2 Q1Y2 Q2
Bags of compost sold5488112465894
(a)Which of these calculations gives the second 4-point moving average for this data?(1)
  • A) (54 + 88 + 112 + 46) / 4
  • B) (88 + 112 + 46 + 58) / 4
  • C) (112 + 46 + 58 + 94) / 4
  • D) (54 + 88 + 112 + 46 + 58) / 5
(b)Hence write down the value of this moving average.(1)
(Total for Question 39 is 2 marks)
40
A pharmacy's quarterly sales of sun cream are 12, 46, 78, 24, 18. Work out the second 4-point moving average for this data (using the last four of these five values).
(Total for Question 40 is 2 marks)
41
A bakery has 10 quarters of sales data. Work out how many 4-point moving averages can be calculated from this data.
(Total for Question 41 is 2 marks)
42
The trend line for a cafe's sales has a value of 48 in one quarter, and increases by 3 each quarter after that. Work out the trend value two quarters later.
(Total for Question 42 is 2 marks)
43
A shop's quarterly sales are recorded for 2 complete years, giving 8 quarters of data in total.
(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 Quarter 1 or at Quarter 8.(1)
(Total for Question 43 is 3 marks)
44
A shop's quarterly sales produce the following five successive 4-point moving averages, in order: 120, 118, 121, 125, 130.
(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 student claims that, because the trend is increasing, Quarter 3 sales must always be the highest quarter of the year. Is the student correct? Write Yes or No, and give a brief reason.(2)
(Total for Question 44 is 4 marks)
45
A theme park manager wants to investigate whether monthly visitor numbers show a repeating seasonal pattern and a long-term trend, to help plan how many staff to employ each quarter.
(a)Plan: state an appropriate time interval over which to collect visitor number 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 park's own turnstile records (a secondary data source) rather than carrying out a new visitor survey.(1)
(c)Process: the table shows quarterly visitor numbers, in thousands, for two years.
QuarterY1 Q1Y1 Q2Y1 Q3Y1 Q4Y2 Q1Y2 Q2Y2 Q3Y2 Q4
Visitors (thousands)822351210253914

Calculate the first two 4-point moving averages for this data.
(3)
(d)Interpret: three further moving averages, continuing from part (c), are 20.5, 21.5 and 22. Using all five values, describe the trend, and suggest one staffing decision the manager could make based on it, linking back to the original purpose of the investigation.(3)
(Total for Question 45 is 9 marks)
46
The Bay View Ice Cream Kiosk (see Question 4) has now recorded three full years of quarterly sales.
QuarterY1 Q1Y1 Q2Y1 Q3Y1 Q4Y2 Q1Y2 Q2Y2 Q3Y2 Q4Y3 Q1Y3 Q2Y3 Q3Y3 Q4
Ice creams sold2050803030609040307010040

The graph shows this data plotted as a time series.
020406080100Y1Q1Y1Q2Y1Q3Y1Q4Y2Q1Y2Q2Y2Q3Y2Q4Y3Q1Y3Q2Y3Q3Y3Q4QuarterIce creams sold
(a)Calculate the first two 4-point moving averages for this data.(3)
(b)Two further moving averages have already been calculated: the third is 50 and the fourth is 52.5. Plot all four moving averages (your two values from part (a), and these two) on the graph, marking each with a cross (X) at the correct point in time. Use the four dashed guide lines shown to help you.(2)
(Total for Question 46 is 5 marks)
47
The graph shows the moving-average trend lines for ice cream sales in two different towns over the same 8 quarters.
020406080100Q1Q2Q3Q4Q5Q6Q7Q8QuarterSales trendTown A trendTown B trend
(a)Identify which town shows an increasing trend, and which town shows a roughly constant (flat) trend.(2)
(b)The manager of Town B says: 'Our trend line is flat, so our ice cream sales are never affected by the season.' Comment on whether this is a fair conclusion.(2)
(Total for Question 47 is 4 marks)
48
Four successive seasonal variations for a shop's quarterly sales are +12, +28, -15, and an unknown value for the fourth quarter. Seasonal variations for a full year should sum to (approximately) zero. Work out the missing seasonal variation, and state which of the four quarters has the largest positive seasonal variation.
(Total for Question 48 is 3 marks)
49
A garden centre sells hanging baskets. The table shows the actual number sold each quarter, alongside the trend value (from a moving average) for that quarter.
QuarterY1 Q2Y1 Q3Y1 Q4Y2 Q1
Actual hanging baskets sold64783832
Trend (from moving average)50525456
(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 49 is 8 marks)
50
The garden centre's hanging basket sales (see Question 49) have a trend value of 56 at Y2 Q1, and this trend is expected to keep increasing by 2 each quarter. The seasonal variation for Quarter 2 was found to be +14.
(a)Predict the trend value for Y2 Q2, assuming the trend keeps increasing by 2 each quarter.(2)
(b)Hence forecast the actual number of hanging baskets the garden centre 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 50 is 6 marks)
51
The graph shows the Bay View Ice Cream Kiosk's 12 quarters of raw sales data (from Question 46), 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.
020406080100Y1Q1Y1Q2Y1Q3Y1Q4Y2Q1Y2Q2Y2Q3Y2Q4Y3Q1Y3Q2Y3Q3Y3Q4Y4Q1Y4Q2QuarterIce creams sold / moving averageActual quarterly sales4-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 51 is 6 marks)
Mark scheme · 4.6 Time Series and Moving Averages

Question 1

  • (a) Trend caoB1
  • (a) Answer: Trend
  • (b) Seasonal variation caoB1
  • (b) Answer: Seasonal variation

Question 2

  • Seasonal variation caoB1
  • Answer: Seasonal variation

Question 3

  • False caoB1
  • Answer: False

Question 4

  • (a) 90 caoB1
  • (a) Answer: 90
  • (b) Quarter 1 (Q1) caoB1
  • (b) Answer: Quarter 1
  • (c) identifies both the repeating seasonal pattern (low in Q1, high in Q3) and that Year 2 is higher than Year 1 overall, oeB1
  • (c) Answer: Sales rise and fall in the same seasonal pattern each year (lowest in Q1, highest in Q3), and Year 2 sales are higher than Year 1 in every matching quarter.

Question 5

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

Question 6

  • False caoB1
  • Answer: False

Question 7

  • 37.5 caoB1
  • Answer: 37.5

Question 8

  • Increasing caoB1
  • Answer: Increasing

Question 9

  • adds three consecutive values and divides by 3M1
  • all 5 moving averages 56.7, 55.7, 57, 57.7, 60 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
  • 62.3 caoA1
  • Answer: (a) 56.7, 55.7, 57, 57.7, 60; (b) generally increasing; (c) 62.3

Question 10

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

Question 11

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

Question 12

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

Question 13

  • adds three consecutive values and divides by 3M1
  • all 5 moving averages 51.7, 53.7, 55.3, 55.7, 58.3 caoA1
  • trend is increasingB1
  • last moving average plus (last minus the one before)M1
  • 61 (accept 60.9, from moving averages rounded to 1 decimal place)A1
  • Answer: (a) 51.7, 53.7, 55.3, 55.7, 58.3; (b) increasing; (c) 61

Question 14

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

Question 15

  • adds three consecutive values and divides by 3M1
  • all 5 moving averages 51.7, 57, 58.7, 61, 64.3 caoA1
  • trend is increasingB1
  • last moving average plus (last minus the one before)M1
  • 67.7 (accept 67.6, from moving averages rounded to 1 decimal place)A1
  • Answer: (a) 51.7, 57, 58.7, 61, 64.3; (b) increasing; (c) 67.7

Question 16

  • adds three consecutive values and divides by 3M1
  • all 4 moving averages 49.7, 45.7, 43.7, 41 caoA1
  • trend is decreasingB1
  • last moving average plus (last minus the one before)M1
  • 38.3 caoA1
  • Answer: (a) 49.7, 45.7, 43.7, 41; (b) decreasing; (c) 38.3

Question 17

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

Question 18

  • adds three consecutive values and divides by 3M1
  • all 5 moving averages 25.7, 30, 31.3, 33.7, 34.3 caoA1
  • trend is increasingB1
  • last moving average plus (last minus the one before)M1
  • 35 (accept 34.9, from moving averages rounded to 1 decimal place)A1
  • Answer: (a) 25.7, 30, 31.3, 33.7, 34.3; (b) increasing; (c) 35

Question 19

  • adds three consecutive values and divides by 3M1
  • all 6 moving averages 50, 54, 56.3, 60.3, 61, 63.7 caoA1
  • trend is increasingB1
  • last moving average plus (last minus the one before)M1
  • 66.3 (accept 66.4, from moving averages rounded to 1 decimal place)A1
  • Answer: (a) 50, 54, 56.3, 60.3, 61, 63.7; (b) increasing; (c) 66.3

Question 20

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

Question 21

  • adds three consecutive values and divides by 3M1
  • all 6 moving averages 48.3, 47, 43, 41.3, 38.3, 37.7 caoA1
  • trend is decreasingB1
  • last moving average plus (last minus the one before)M1
  • 37 (accept 37.1, from moving averages rounded to 1 decimal place)A1
  • Answer: (a) 48.3, 47, 43, 41.3, 38.3, 37.7; (b) decreasing; (c) 37

Question 22

  • adds three consecutive values and divides by 3M1
  • all 4 moving averages 62.3, 61, 59.7, 58 caoA1
  • trend is decreasingB1
  • last moving average plus (last minus the one before)M1
  • 56.3 caoA1
  • Answer: (a) 62.3, 61, 59.7, 58; (b) decreasing; (c) 56.3

Question 23

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

Question 24

  • adds three consecutive values and divides by 3M1
  • all 5 moving averages 45.7, 47.7, 51.7, 52, 53.3 caoA1
  • trend is increasingB1
  • last moving average plus (last minus the one before)M1
  • 54.7 (accept 54.6, from moving averages rounded to 1 decimal place)A1
  • Answer: (a) 45.7, 47.7, 51.7, 52, 53.3; (b) increasing; (c) 54.7

Question 25

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

Question 26

  • adds three consecutive values and divides by 3M1
  • all 5 moving averages 38, 42, 48.3, 51.3, 55.3 caoA1
  • trend is increasingB1
  • last moving average plus (last minus the one before)M1
  • 59.3 caoA1
  • Answer: (a) 38, 42, 48.3, 51.3, 55.3; (b) increasing; (c) 59.3

Question 27

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

Question 28

  • adds three consecutive values and divides by 3M1
  • all 5 moving averages 58.3, 64, 66, 66, 68 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
  • 70 caoA1
  • Answer: (a) 58.3, 64, 66, 66, 68; (b) generally increasing; (c) 70

Question 29

  • a suitable uniform scale chosen on the vertical axis, starting at 0B1
  • the first four points plotted correctly: 10, 40, 70, 20 (± half a small square)B1
  • the last four points plotted correctly: 20, 50, 80, 30 (± 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 10, 40, 70, 20, 20, 50, 80, 30 joined in order.

Question 30

  • adds three consecutive values and divides by 3M1
  • all 4 moving averages 55.7, 57.3, 58.3, 60.3 caoA1
  • trend is increasingB1
  • last moving average plus (last minus the one before)M1
  • 62.3 caoA1
  • Answer: (a) 55.7, 57.3, 58.3, 60.3; (b) increasing; (c) 62.3

Question 31

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

Question 32

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

Question 33

  • adds three consecutive values and divides by 3M1
  • all 6 moving averages 58.3, 61.3, 62.3, 68, 72.3, 75.7 caoA1
  • trend is increasingB1
  • last moving average plus (last minus the one before)M1
  • 79 (accept 79.1, from moving averages rounded to 1 decimal place)A1
  • Answer: (a) 58.3, 61.3, 62.3, 68, 72.3, 75.7; (b) increasing; (c) 79

Question 34

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

Question 35

  • adds three consecutive values and divides by 3M1
  • all 5 moving averages 51, 47.3, 47, 47.3, 44.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
  • 41.3 caoA1
  • Answer: (a) 51, 47.3, 47, 47.3, 44.3; (b) generally decreasing; (c) 41.3

Question 36

  • adds three consecutive values and divides by 3M1
  • all 4 moving averages 39.7, 39.3, 37.3, 35.7 caoA1
  • trend is decreasingB1
  • last moving average plus (last minus the one before)M1
  • 34 (accept 34.1, from moving averages rounded to 1 decimal place)A1
  • Answer: (a) 39.7, 39.3, 37.3, 35.7; (b) decreasing; (c) 34

Question 37

  • (a) correct method shown for at least one moving average, e.g. (54+88+112+46)/4M1
  • (a) 75 caoA1
  • (a) 76 caoA1
  • (a) 77.5 caoA1
  • (a) Answer: 75, 76, 77.5
  • (b) the trend is increasing/rising, since the moving averages increase from 75 to 76 to 77.5, oeB1
  • (b) Answer: The trend is increasing.

Question 38

  • 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 39

  • (a) B caoB1
  • (a) Answer: B) (88 + 112 + 46 + 58) / 4
  • (b) 76 caoB1
  • (b) Answer: 76

Question 40

  • 46 + 78 + 24 + 18, oe (=166)M1
  • 41.5 caoA1
  • Answer: 41.5

Question 41

  • 10 - 4 + 1, oeM1
  • 7 caoA1
  • Answer: 7

Question 42

  • 48 + 3 + 3, oeM1
  • 54 caoA1
  • Answer: 54

Question 43

  • (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; quarter 1 and quarter 8 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: Quarter 1 and Quarter 8 can never be the midpoint of a group of 4 consecutive quarters, so no moving average is plotted there.

Question 44

  • (a) Increasing caoB1
  • (a) Answer: Increasing
  • (b) compares the first and last values (e.g. 130 is greater than 120), or notes the values generally rise overall, oeB1
  • (b) Answer: The final moving average (130) is higher than the first (120), 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 sales within a year.

Question 45

  • (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: Collect visitor numbers 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 visitor exactly / is quicker and cheaper than running a new survey, oeB1
  • (b) Answer: Turnstile records already exist and count every visitor exactly, so they are quicker and cheaper to use than collecting new survey data.
  • (c) correct method shown, e.g. (8+22+35+12)/4M1
  • (c) 19.25 caoA1
  • (c) 19.75 caoA1
  • (c) Answer: 19.25, 19.75
  • (d) trend is increasing (visitor numbers are rising from one year to the next), since 19.25, 19.75, 20.5, 21.5, 22 rises steadilyB1
  • (d) identifies that Quarter 3 remains the seasonal peak each year (raw data 35 then 39)B1
  • (d) gives a sensible staffing recommendation linked to the purpose, e.g. schedule extra staff every Quarter 3, and gradually increase baseline staffing over time as the underlying trend rises, oeB1
  • (d) Answer: The trend is increasing; Quarter 3 is the seasonal peak each year, so the manager should schedule extra staff every Quarter 3 and gradually increase overall staffing as the rising trend continues.

Question 46

  • (a) correct method shown, e.g. (20+50+80+30)/4M1
  • (a) 45 caoA1
  • (a) 47.5 caoA1
  • (a) Answer: 45, 47.5
  • (b) first two moving averages (45, 47.5) plotted at the correct guide lines, ± half a small squareB1
  • (b) next two moving averages (50, 52.5) plotted at the correct guide lines, ± half a small squareB1
  • (b) Answer: Points at (between Y1Q2/Y1Q3, 45), (between Y1Q3/Y1Q4, 47.5), (between Y1Q4/Y2Q1, 50), (between Y2Q1/Y2Q2, 52.5).

Question 47

  • (a) Town A - increasing trendB1
  • (a) Town B - roughly constant/flat trendB1
  • (a) Answer: Town A: increasing. Town B: 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 sales can still rise and fall with the season 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 - the raw quarterly sales in Town B could still rise and fall with the seasons; the moving average has simply smoothed that seasonal variation out of the graph.

Question 48

  • 12 + 28 - 15, oe (=25)M1
  • -25 caoA1
  • the quarter with +28 identified as the largest positive seasonal variation, ftA1
  • Answer: Missing seasonal variation = -25; the quarter with +28 has the largest positive seasonal variation.

Question 49

  • (a) Y1 Q2: +14 caoB1
  • (a) Y1 Q3: +26 caoB1
  • (a) Y1 Q4: -16 caoB1
  • (a) Y2 Q1: -24 caoB1
  • (a) Answer: +14, +26, -16, -24
  • (b) sums all four seasonal variations found: 14+26-16-24M1
  • (b) sum = 0, confirming the values in part (a) are consistent with the rule, oeA1
  • (b) Answer: 14 + 26 - 16 - 24 = 0, which confirms the seasonal variations are consistent.
  • (c) Y1 Q3B1
  • (c) sales in Quarter 3 are typically about 26 higher than the underlying trend, e.g. because it is the busiest (summer) season for hanging baskets, oeB1
  • (c) Answer: Y1 Q3, with seasonal variation +26 - hanging basket sales in Quarter 3 are typically about 26 above the trend, consistent with Quarter 3 (summer) being the busiest season for garden sales.

Question 50

  • (a) 56 + 2M1
  • (a) 58 caoA1
  • (a) Answer: 58
  • (b) 58 + 14M1
  • (b) 72 caoA1
  • (b) Answer: 72
  • (c) a valid reason that the trend or seasonal pattern might not continue as assumed, e.g. unusual weather that quarter, a new garden centre opening nearby, a change in prices, or any other sensible real-world factor, oeB2
  • (c) Answer: For example, unusually poor weather in Quarter 2 could reduce sales below the forecast, or a new competing garden centre opening nearby could take away some customers, so the trend and seasonal pattern might not continue exactly as assumed.

Question 51

  • (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 45 up to about 60.
  • (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 60 to 75 (ft)A1
  • (b) Answer: Approximately 66-68 (accept any value from 60 to 75 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. ice cream sales depend on weather which varies year to year, a competitor kiosk could open nearby, or the kiosk's opening hours/location 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, ice cream sales depend heavily on the weather, which varies from year to year, and a new competitor 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

2 marks
Did your answer earn the marks?

Question 2

1 mark

Question 3

1 mark

Question 4

3 marks
Did your answer earn the marks?

Question 5

4 marks
Did your answer earn the marks?

Question 6

1 mark

Question 7

1 mark

Question 8

1 mark

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

5 marks
Did your answer earn the marks?

Question 36

5 marks
Did your answer earn the marks?

Question 37

5 marks
Did your answer earn the marks?

Question 38

2 marks
Did your answer earn the marks?

Question 39(a)

1 mark
Choose an answer

Question 39(b)

1 mark

Question 40

2 marks

Question 41

2 marks

Question 42

2 marks

Question 43

3 marks
Did your answer earn the marks?

Question 44

4 marks
Did your answer earn the marks?

Question 45

9 marks
Did your answer earn the marks?

Question 46

5 marks
Did your answer earn the marks?

Question 47

4 marks
Did your answer earn the marks?

Question 48

3 marks
Did your answer earn the marks?

Question 49

8 marks
Did your answer earn the marks?

Question 50

6 marks
Did your answer earn the marks?

Question 51

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

Keep going

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