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.
Time Series and Moving Averages revision guideMore GCSE Statistics practiceMock exams
This topic is chapter 3 of GCSE Statistics Foundation Topic Workbook 5 and chapter 6 of GCSE Statistics Higher Topic Workbook 6.
4.6 Time Series and Moving Averages
A 4-point moving average value is plotted at the same time point as the last of the 4 values used to calculate it.
Seasonal variation repeats in exactly the same way, with no exceptions, in every single year.
| Time | Customers |
|---|---|
| week 1 | 56 |
| week 2 | 55 |
| week 3 | 59 |
| week 4 | 53 |
| week 5 | 59 |
| week 6 | 61 |
| week 7 | 60 |
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.
| Quarter | Value |
|---|---|
| 2022 Q1 | 59 |
| 2022 Q2 | 76 |
| 2022 Q3 | 87 |
| 2022 Q4 | 79 |
| 2023 Q1 | 75 |
| 2023 Q2 | 92 |
| 2023 Q3 | 103 |
| 2023 Q4 | 95 |
| 2024 Q1 | 91 |
| 2024 Q2 | 108 |
| 2024 Q3 | 119 |
| 2024 Q4 | 111 |
(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.
| Time | Drinks |
|---|---|
| week 1 | 39 |
| week 2 | 38 |
| week 3 | 46 |
| week 4 | 53 |
| week 5 | 58 |
| week 6 | 60 |
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.
| Quarter | Value |
|---|---|
| 2019 Q1 | 54 |
| 2019 Q2 | 72 |
| 2019 Q3 | 79 |
| 2019 Q4 | 69 |
| 2020 Q1 | 66 |
| 2020 Q2 | 84 |
| 2020 Q3 | 91 |
| 2020 Q4 | 81 |
| 2021 Q1 | 78 |
| 2021 Q2 | 96 |
| 2021 Q3 | 103 |
| 2021 Q4 | 93 |
(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.
| Time | Sales |
|---|---|
| week 1 | 50 |
| week 2 | 49 |
| week 3 | 56 |
| week 4 | 56 |
| week 5 | 54 |
| week 6 | 57 |
| week 7 | 64 |
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.
| Quarter | Value |
|---|---|
| 2020 Q1 | 64 |
| 2020 Q2 | 76 |
| 2020 Q3 | 86 |
| 2020 Q4 | 75 |
| 2021 Q1 | 72 |
| 2021 Q2 | 84 |
| 2021 Q3 | 94 |
| 2021 Q4 | 83 |
| 2022 Q1 | 80 |
| 2022 Q2 | 92 |
| 2022 Q3 | 102 |
| 2022 Q4 | 91 |
(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.
| Time | Ice creams |
|---|---|
| week 1 | 49 |
| week 2 | 52 |
| week 3 | 54 |
| week 4 | 65 |
| week 5 | 57 |
| week 6 | 61 |
| week 7 | 75 |
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.
| Time | Customers |
|---|---|
| week 1 | 56 |
| week 2 | 46 |
| week 3 | 47 |
| week 4 | 44 |
| week 5 | 40 |
| week 6 | 39 |
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.
| Quarter | Value |
|---|---|
| 2022 Q1 | 60 |
| 2022 Q2 | 79 |
| 2022 Q3 | 93 |
| 2022 Q4 | 79 |
| 2023 Q1 | 72 |
| 2023 Q2 | 91 |
| 2023 Q3 | 105 |
| 2023 Q4 | 91 |
| 2024 Q1 | 84 |
| 2024 Q2 | 103 |
| 2024 Q3 | 117 |
| 2024 Q4 | 103 |
(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.
| Time | Ice creams |
|---|---|
| week 1 | 22 |
| week 2 | 30 |
| week 3 | 25 |
| week 4 | 35 |
| week 5 | 34 |
| week 6 | 32 |
| week 7 | 37 |
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.
| Time | Sales |
|---|---|
| week 1 | 47 |
| week 2 | 51 |
| week 3 | 52 |
| week 4 | 59 |
| week 5 | 58 |
| week 6 | 64 |
| week 7 | 61 |
| week 8 | 66 |
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.
| Quarter | Value |
|---|---|
| 2021 Q1 | 46 |
| 2021 Q2 | 63 |
| 2021 Q3 | 77 |
| 2021 Q4 | 64 |
| 2022 Q1 | 58 |
| 2022 Q2 | 75 |
| 2022 Q3 | 89 |
| 2022 Q4 | 76 |
| 2023 Q1 | 70 |
| 2023 Q2 | 87 |
| 2023 Q3 | 101 |
| 2023 Q4 | 88 |
(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.
| Time | Customers |
|---|---|
| week 1 | 50 |
| week 2 | 51 |
| week 3 | 44 |
| week 4 | 46 |
| week 5 | 39 |
| week 6 | 39 |
| week 7 | 37 |
| week 8 | 37 |
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.
| Time | Drinks |
|---|---|
| day 1 | 60 |
| day 2 | 62 |
| day 3 | 65 |
| day 4 | 56 |
| day 5 | 58 |
| day 6 | 60 |
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.
| Quarter | Value |
|---|---|
| 2021 Q1 | 53 |
| 2021 Q2 | 70 |
| 2021 Q3 | 79 |
| 2021 Q4 | 67 |
| 2022 Q1 | 61 |
| 2022 Q2 | 78 |
| 2022 Q3 | 87 |
| 2022 Q4 | 75 |
| 2023 Q1 | 69 |
| 2023 Q2 | 86 |
| 2023 Q3 | 95 |
| 2023 Q4 | 83 |
(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.
| Time | Sales |
|---|---|
| day 1 | 49 |
| day 2 | 40 |
| day 3 | 48 |
| day 4 | 55 |
| day 5 | 52 |
| day 6 | 49 |
| day 7 | 59 |
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.
| Quarter | Value |
|---|---|
| 2019 Q1 | 43 |
| 2019 Q2 | 57 |
| 2019 Q3 | 70 |
| 2019 Q4 | 59 |
| 2020 Q1 | 51 |
| 2020 Q2 | 65 |
| 2020 Q3 | 78 |
| 2020 Q4 | 67 |
| 2021 Q1 | 59 |
| 2021 Q2 | 73 |
| 2021 Q3 | 86 |
| 2021 Q4 | 75 |
(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.
| Time | Customers |
|---|---|
| day 1 | 35 |
| day 2 | 34 |
| day 3 | 45 |
| day 4 | 47 |
| day 5 | 53 |
| day 6 | 54 |
| day 7 | 59 |
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.
| Quarter | Value |
|---|---|
| 2019 Q1 | 73 |
| 2019 Q2 | 86 |
| 2019 Q3 | 104 |
| 2019 Q4 | 89 |
| 2020 Q1 | 85 |
| 2020 Q2 | 98 |
| 2020 Q3 | 116 |
| 2020 Q4 | 101 |
| 2021 Q1 | 97 |
| 2021 Q2 | 110 |
| 2021 Q3 | 128 |
| 2021 Q4 | 113 |
(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.
| Time | Ice creams |
|---|---|
| day 1 | 52 |
| day 2 | 58 |
| day 3 | 65 |
| day 4 | 69 |
| day 5 | 64 |
| day 6 | 65 |
| day 7 | 75 |
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.
| Quarter | Y1 Q1 | Y1 Q2 | Y1 Q3 | Y1 Q4 | Y2 Q1 | Y2 Q2 | Y2 Q3 | Y2 Q4 |
|---|---|---|---|---|---|---|---|---|
| Bottles sold | 10 | 40 | 70 | 20 | 20 | 50 | 80 | 30 |
On the grid provided, draw a time series graph to show this information. Plot each point and join them, in order, with straight lines.
| Time | Drinks |
|---|---|
| week 1 | 51 |
| week 2 | 55 |
| week 3 | 61 |
| week 4 | 56 |
| week 5 | 58 |
| week 6 | 67 |
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.
| Quarter | Value |
|---|---|
| 2022 Q1 | 62 |
| 2022 Q2 | 80 |
| 2022 Q3 | 98 |
| 2022 Q4 | 84 |
| 2023 Q1 | 74 |
| 2023 Q2 | 92 |
| 2023 Q3 | 110 |
| 2023 Q4 | 96 |
| 2024 Q1 | 86 |
| 2024 Q2 | 104 |
| 2024 Q3 | 122 |
| 2024 Q4 | 108 |
(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.
| Time | Ice creams |
|---|---|
| day 1 | 57 |
| day 2 | 58 |
| day 3 | 57 |
| day 4 | 61 |
| day 5 | 75 |
| day 6 | 73 |
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.
| Time | Customers |
|---|---|
| week 1 | 55 |
| week 2 | 62 |
| week 3 | 58 |
| week 4 | 64 |
| week 5 | 65 |
| week 6 | 75 |
| week 7 | 77 |
| week 8 | 75 |
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.
| Quarter | Value |
|---|---|
| 2020 Q1 | 56 |
| 2020 Q2 | 72 |
| 2020 Q3 | 90 |
| 2020 Q4 | 75 |
| 2021 Q1 | 68 |
| 2021 Q2 | 84 |
| 2021 Q3 | 102 |
| 2021 Q4 | 87 |
| 2022 Q1 | 80 |
| 2022 Q2 | 96 |
| 2022 Q3 | 114 |
| 2022 Q4 | 99 |
(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.
| Time | Visitors |
|---|---|
| day 1 | 58 |
| day 2 | 50 |
| day 3 | 45 |
| day 4 | 47 |
| day 5 | 49 |
| day 6 | 46 |
| day 7 | 38 |
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.
| Time | Sales |
|---|---|
| week 1 | 44 |
| week 2 | 40 |
| week 3 | 35 |
| week 4 | 43 |
| week 5 | 34 |
| week 6 | 30 |
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.
| Quarter | Y1 Q1 | Y1 Q2 | Y1 Q3 | Y1 Q4 | Y2 Q1 | Y2 Q2 |
|---|---|---|---|---|---|---|
| Bags of compost sold | 54 | 88 | 112 | 46 | 58 | 94 |
| Quarter | Y1 Q1 | Y1 Q2 | Y1 Q3 | Y1 Q4 | Y2 Q1 | Y2 Q2 |
|---|---|---|---|---|---|---|
| Bags of compost sold | 54 | 88 | 112 | 46 | 58 | 94 |
- 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
| Quarter | Y1 Q1 | Y1 Q2 | Y1 Q3 | Y1 Q4 | Y2 Q1 | Y2 Q2 | Y2 Q3 | Y2 Q4 |
|---|---|---|---|---|---|---|---|---|
| Visitors (thousands) | 8 | 22 | 35 | 12 | 10 | 25 | 39 | 14 |
Calculate the first two 4-point moving averages for this data.(3)
| Quarter | Y1 Q1 | Y1 Q2 | Y1 Q3 | Y1 Q4 | Y2 Q1 | Y2 Q2 | Y2 Q3 | Y2 Q4 | Y3 Q1 | Y3 Q2 | Y3 Q3 | Y3 Q4 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Ice creams sold | 20 | 50 | 80 | 30 | 30 | 60 | 90 | 40 | 30 | 70 | 100 | 40 |
The graph shows this data plotted as a time series.
| Quarter | Y1 Q2 | Y1 Q3 | Y1 Q4 | Y2 Q1 |
|---|---|---|---|---|
| Actual hanging baskets sold | 64 | 78 | 38 | 32 |
| Trend (from moving average) | 50 | 52 | 54 | 56 |
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.