Time Series - Worksheets, Questions and Revision
45 original exam-style questions - 42 pages of questions with a full mark scheme - free printable PDF.
Time Series revision guideMore GCSE Statistics practiceMock exams
This topic is chapter 5 of GCSE Statistics Foundation Topic Workbook 5 and chapter 1 of GCSE Statistics Higher Topic Workbook 7.
4.8 Time Series
| Quarter | Value |
|---|---|
| 2019 Q1 | 63 |
| 2019 Q2 | 78 |
| 2019 Q3 | 95 |
| 2019 Q4 | 78 |
| 2020 Q1 | 71 |
| 2020 Q2 | 86 |
| 2020 Q3 | 103 |
| 2020 Q4 | 86 |
| 2021 Q1 | 79 |
| 2021 Q2 | 94 |
| 2021 Q3 | 111 |
| 2021 Q4 | 94 |
(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.
| Quarter | Value |
|---|---|
| 2021 Q1 | 75 |
| 2021 Q2 | 85 |
| 2021 Q3 | 93 |
| 2021 Q4 | 81 |
| 2022 Q1 | 83 |
| 2022 Q2 | 93 |
| 2022 Q3 | 101 |
| 2022 Q4 | 89 |
| 2023 Q1 | 91 |
| 2023 Q2 | 101 |
| 2023 Q3 | 109 |
| 2023 Q4 | 97 |
(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.
| Quarter | Value |
|---|---|
| 2021 Q1 | 58 |
| 2021 Q2 | 72 |
| 2021 Q3 | 80 |
| 2021 Q4 | 68 |
| 2022 Q1 | 66 |
| 2022 Q2 | 80 |
| 2022 Q3 | 88 |
| 2022 Q4 | 76 |
| 2023 Q1 | 74 |
| 2023 Q2 | 88 |
| 2023 Q3 | 96 |
| 2023 Q4 | 84 |
(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 | Visitors |
|---|---|
| week 1 | 39 |
| week 2 | 49 |
| week 3 | 49 |
| week 4 | 50 |
| week 5 | 58 |
| week 6 | 59 |
| week 7 | 56 |
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 | 45 |
| 2021 Q2 | 63 |
| 2021 Q3 | 70 |
| 2021 Q4 | 56 |
| 2022 Q1 | 57 |
| 2022 Q2 | 75 |
| 2022 Q3 | 82 |
| 2022 Q4 | 68 |
| 2023 Q1 | 69 |
| 2023 Q2 | 87 |
| 2023 Q3 | 94 |
| 2023 Q4 | 80 |
(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.
| Quarter | Value |
|---|---|
| 2020 Q1 | 47 |
| 2020 Q2 | 61 |
| 2020 Q3 | 71 |
| 2020 Q4 | 57 |
| 2021 Q1 | 55 |
| 2021 Q2 | 69 |
| 2021 Q3 | 79 |
| 2021 Q4 | 65 |
| 2022 Q1 | 63 |
| 2022 Q2 | 77 |
| 2022 Q3 | 87 |
| 2022 Q4 | 73 |
(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.
| Time | Visitors |
|---|---|
| week 1 | 57 |
| week 2 | 62 |
| week 3 | 63 |
| week 4 | 74 |
| week 5 | 79 |
| week 6 | 85 |
| week 7 | 79 |
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 | 49 |
| 2020 Q2 | 66 |
| 2020 Q3 | 82 |
| 2020 Q4 | 63 |
| 2021 Q1 | 65 |
| 2021 Q2 | 82 |
| 2021 Q3 | 98 |
| 2021 Q4 | 79 |
| 2022 Q1 | 81 |
| 2022 Q2 | 98 |
| 2022 Q3 | 114 |
| 2022 Q4 | 95 |
(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.
| Quarter | Value |
|---|---|
| 2020 Q1 | 48 |
| 2020 Q2 | 61 |
| 2020 Q3 | 66 |
| 2020 Q4 | 56 |
| 2021 Q1 | 56 |
| 2021 Q2 | 69 |
| 2021 Q3 | 74 |
| 2021 Q4 | 64 |
| 2022 Q1 | 64 |
| 2022 Q2 | 77 |
| 2022 Q3 | 82 |
| 2022 Q4 | 72 |
(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.
| Time | Ice creams |
|---|---|
| week 1 | 39 |
| week 2 | 37 |
| week 3 | 45 |
| week 4 | 42 |
| week 5 | 53 |
| week 6 | 50 |
| week 7 | 54 |
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 | 60 |
| 2021 Q3 | 71 |
| 2021 Q4 | 62 |
| 2022 Q1 | 58 |
| 2022 Q2 | 72 |
| 2022 Q3 | 83 |
| 2022 Q4 | 74 |
| 2023 Q1 | 70 |
| 2023 Q2 | 84 |
| 2023 Q3 | 95 |
| 2023 Q4 | 86 |
(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.
| Quarter | Value |
|---|---|
| 2022 Q1 | 61 |
| 2022 Q2 | 72 |
| 2022 Q3 | 84 |
| 2022 Q4 | 69 |
| 2023 Q1 | 69 |
| 2023 Q2 | 80 |
| 2023 Q3 | 92 |
| 2023 Q4 | 77 |
| 2024 Q1 | 77 |
| 2024 Q2 | 88 |
| 2024 Q3 | 100 |
| 2024 Q4 | 85 |
(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 | 58 |
| week 2 | 58 |
| week 3 | 54 |
| week 4 | 66 |
| week 5 | 62 |
| week 6 | 65 |
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 | 69 |
| 2019 Q2 | 83 |
| 2019 Q3 | 92 |
| 2019 Q4 | 83 |
| 2020 Q1 | 77 |
| 2020 Q2 | 91 |
| 2020 Q3 | 100 |
| 2020 Q4 | 91 |
| 2021 Q1 | 85 |
| 2021 Q2 | 99 |
| 2021 Q3 | 108 |
| 2021 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 2019 Q3 quarter.
(c) State the seasonal effect for 2019 Q3, that is the value minus the centred moving average.
| Quarter | Value |
|---|---|
| 2019 Q1 | 59 |
| 2019 Q2 | 77 |
| 2019 Q3 | 86 |
| 2019 Q4 | 77 |
| 2020 Q1 | 71 |
| 2020 Q2 | 89 |
| 2020 Q3 | 98 |
| 2020 Q4 | 89 |
| 2021 Q1 | 83 |
| 2021 Q2 | 101 |
| 2021 Q3 | 110 |
| 2021 Q4 | 101 |
(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 | 41 |
| week 2 | 33 |
| week 3 | 27 |
| week 4 | 30 |
| week 5 | 34 |
| week 6 | 29 |
| week 7 | 28 |
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 |
|---|---|---|---|---|---|---|---|---|
| Bikes hired | 30 | 70 | 90 | 50 | 40 | 80 | 100 | 60 |
On the grid provided, draw a time series graph to show this information. Plot each point and join them, in order, with straight lines.
| Quarter | Value |
|---|---|
| 2019 Q1 | 68 |
| 2019 Q2 | 80 |
| 2019 Q3 | 98 |
| 2019 Q4 | 80 |
| 2020 Q1 | 84 |
| 2020 Q2 | 96 |
| 2020 Q3 | 114 |
| 2020 Q4 | 96 |
| 2021 Q1 | 100 |
| 2021 Q2 | 112 |
| 2021 Q3 | 130 |
| 2021 Q4 | 112 |
(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.
| Quarter | Value |
|---|---|
| 2021 Q1 | 50 |
| 2021 Q2 | 64 |
| 2021 Q3 | 78 |
| 2021 Q4 | 68 |
| 2022 Q1 | 62 |
| 2022 Q2 | 76 |
| 2022 Q3 | 90 |
| 2022 Q4 | 80 |
| 2023 Q1 | 74 |
| 2023 Q2 | 88 |
| 2023 Q3 | 102 |
| 2023 Q4 | 92 |
(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.
| Time | Sales |
|---|---|
| week 1 | 40 |
| week 2 | 42 |
| week 3 | 47 |
| week 4 | 42 |
| week 5 | 41 |
| week 6 | 51 |
| week 7 | 58 |
| week 8 | 55 |
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 | 54 |
| 2021 Q2 | 75 |
| 2021 Q3 | 84 |
| 2021 Q4 | 71 |
| 2022 Q1 | 70 |
| 2022 Q2 | 91 |
| 2022 Q3 | 100 |
| 2022 Q4 | 87 |
| 2023 Q1 | 86 |
| 2023 Q2 | 107 |
| 2023 Q3 | 116 |
| 2023 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 Q1 quarter.
(c) State the seasonal effect for 2022 Q1, that is the value minus the centred moving average.
| Quarter | Value |
|---|---|
| 2021 Q1 | 41 |
| 2021 Q2 | 61 |
| 2021 Q3 | 75 |
| 2021 Q4 | 61 |
| 2022 Q1 | 53 |
| 2022 Q2 | 73 |
| 2022 Q3 | 87 |
| 2022 Q4 | 73 |
| 2023 Q1 | 65 |
| 2023 Q2 | 85 |
| 2023 Q3 | 99 |
| 2023 Q4 | 85 |
(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.
| Time | Customers |
|---|---|
| week 1 | 37 |
| week 2 | 38 |
| week 3 | 30 |
| week 4 | 27 |
| week 5 | 29 |
| week 6 | 18 |
| week 7 | 26 |
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 | 56 |
| 2019 Q2 | 76 |
| 2019 Q3 | 88 |
| 2019 Q4 | 77 |
| 2020 Q1 | 68 |
| 2020 Q2 | 88 |
| 2020 Q3 | 100 |
| 2020 Q4 | 89 |
| 2021 Q1 | 80 |
| 2021 Q2 | 100 |
| 2021 Q3 | 112 |
| 2021 Q4 | 101 |
(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.
| Quarter | Y1 Q1 | Y1 Q2 | Y1 Q3 | Y1 Q4 | Y2 Q1 | Y2 Q2 |
|---|---|---|---|---|---|---|
| Bikes hired | 30 | 70 | 90 | 50 | 40 | 80 |
| Quarter | Value |
|---|---|
| 2022 Q1 | 56 |
| 2022 Q2 | 70 |
| 2022 Q3 | 78 |
| 2022 Q4 | 67 |
| 2023 Q1 | 64 |
| 2023 Q2 | 78 |
| 2023 Q3 | 86 |
| 2023 Q4 | 75 |
| 2024 Q1 | 72 |
| 2024 Q2 | 86 |
| 2024 Q3 | 94 |
| 2024 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 Q4 quarter.
(c) State the seasonal effect for 2022 Q4, that is the value minus the centred moving average.
| Time | Ice creams |
|---|---|
| day 1 | 48 |
| day 2 | 45 |
| day 3 | 46 |
| day 4 | 39 |
| day 5 | 43 |
| day 6 | 39 |
| day 7 | 32 |
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 | 47 |
| 2019 Q2 | 60 |
| 2019 Q3 | 71 |
| 2019 Q4 | 58 |
| 2020 Q1 | 63 |
| 2020 Q2 | 76 |
| 2020 Q3 | 87 |
| 2020 Q4 | 74 |
| 2021 Q1 | 79 |
| 2021 Q2 | 92 |
| 2021 Q3 | 103 |
| 2021 Q4 | 90 |
(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.
| Quarter | Value |
|---|---|
| 2021 Q1 | 57 |
| 2021 Q2 | 72 |
| 2021 Q3 | 88 |
| 2021 Q4 | 68 |
| 2022 Q1 | 65 |
| 2022 Q2 | 80 |
| 2022 Q3 | 96 |
| 2022 Q4 | 76 |
| 2023 Q1 | 73 |
| 2023 Q2 | 88 |
| 2023 Q3 | 104 |
| 2023 Q4 | 84 |
(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.
| Time | Drinks |
|---|---|
| week 1 | 26 |
| week 2 | 33 |
| week 3 | 30 |
| week 4 | 20 |
| week 5 | 14 |
| week 6 | 16 |
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 | 55 |
| 2020 Q2 | 74 |
| 2020 Q3 | 93 |
| 2020 Q4 | 73 |
| 2021 Q1 | 67 |
| 2021 Q2 | 86 |
| 2021 Q3 | 105 |
| 2021 Q4 | 85 |
| 2022 Q1 | 79 |
| 2022 Q2 | 98 |
| 2022 Q3 | 117 |
| 2022 Q4 | 97 |
(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.
| Quarter | Y1 Q1 | Y1 Q2 | Y1 Q3 | Y1 Q4 | Y2 Q1 | Y2 Q2 |
|---|---|---|---|---|---|---|
| Bikes hired | 30 | 70 | 90 | 50 | 40 | 80 |
- 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
| Day | Week 1 Wed | Week 1 Fri | Week 1 Sat | Week 2 Wed |
|---|---|---|---|---|
| Takings (£) | 120 | 150 | 210 | 135 |
| Quarter | Y1 Q1 | Y1 Q2 | Y1 Q3 | Y1 Q4 | Y2 Q1 | Y2 Q2 |
|---|---|---|---|---|---|---|
| Books borrowed (hundreds) | 42 | 30 | 26 | 50 | 46 | 34 |
Calculate the first two 4-point moving averages for this data.(3)
| Quarter | Y1 Q2 | Y1 Q3 | Y1 Q4 | Y2 Q1 |
|---|---|---|---|---|
| Actual tokens sold (hundreds) | 70 | 93 | 51 | 44 |
| Trend (from moving average) | 60 | 63 | 66 | 69 |
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.