QCAA General Mathematics Time series analysis
11 sample questions with marking guides and sample answers
The second smoothed value for the 3-point moving average is
| Day | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Value | 5 | 10 | 18 | 32 | 52 | 70 | 90 |
32
25
20
18
Reveal Answer
32
This is the raw data value for Day 4, not the calculated moving average.
25
This value is incorrect; the average of the second window of data points (10, 18, and 32) is 20, not 25.
20
The second smoothed value is calculated by averaging the second set of three data points (Days 2, 3, and 4): .
18
This is the raw data value for Day 3, not the calculated moving average.
The seasonal index for the number of meat pie sales in winter is 1.75
To correct for seasonality, the actual number of meat pie sales for winter should be reduced, to the nearest whole percentage, by
25%
43%
57%
75%
Reveal Answer
25%
Incorrect. A 25% reduction would mean multiplying the actual sales by 0.75, which does not match the required deseasonalizing factor of .
43%
Correct. To correct for seasonality, you divide the actual sales by the seasonal index (). This means the deseasonalized value is about 57% of the actual value, requiring a reduction of .
57%
Incorrect. This is the percentage that the deseasonalized sales represent of the actual sales (), rather than the percentage by which the actual sales must be reduced.
75%
Incorrect. While a seasonal index of 1.75 means sales are 75% above the seasonal average, reversing this increase requires dividing by 1.75, not subtracting 75%.
The table shows Darwin’s actual rainfall (mm) each season for two years.
| 2022 | 2023 | |
|---|---|---|
| Autumn | 410 | 390 |
| Winter | 30 | 20 |
| Spring | 205 | 150 |
| Summer | 1135 | 1100 |
Calculate the seasonal index for each season in Darwin.
Reveal Answer
2022 mean rainfall
2023 mean rainfall
| 2022 | 2023 | |
|---|---|---|
| Autumn | ||
| Winter | ||
| Spring | ||
| Summer |
| Seasonal index | |
|---|---|
| Autumn | |
| Winter | |
| Spring | |
| Summer |
| Descriptor | Marks |
|---|---|
correctly calculates the 2022 mean rainfall and 2023 mean rainfall | 1 |
calculates seasonal ratios for 2022 and 2023 | 1 |
calculates seasonal index for each season | 1 |
This table shows Hobart’s actual rainfall (mm) each season for 2023 and the long-term seasonal indices.
| Autumn | Winter | Spring | Summer | |
|---|---|---|---|---|
| 2023 rainfall (mm) | 130 | 145 | 155 | 132 |
| Seasonal index | 0.92 | 1.02 | 1.12 | 0.94 |
Deseasonalise the Hobart rainfall data to identify the 2023 season with the highest seasonally adjusted rainfall.
Reveal Answer
| Autumn | Winter | Spring | Summer | |
|---|---|---|---|---|
| Deseasonalised rainfall |
Winter has the highest seasonally adjusted rainfall.
| Descriptor | Marks |
|---|---|
correctly calculates the deseasonalised rainfall for each season | 1 |
identifies season with highest seasonally adjusted rainfall | 1 |
The table shows the maximum daily temperature (°C) for a week.
| Mon | Tue | Wed | Thu | Fri | Sat | Sun |
|---|---|---|---|---|---|---|
| 24.4 | 25.2 | 24.6 | 25.2 | 25.6 | 25.7 | 25.9 |
If the simple 5-point moving average for Wednesday is 25.0 °C, what is the simple 5-point moving average (°C) for Friday?
25.4
25.5
25.6
26.0
Reveal Answer
25.4
The 5-point moving average for Wednesday was calculated using the 5 days centered on it (Mon–Fri). Similarly, the average for Friday uses the 5 days centered on Friday (Wed–Sun): .
25.5
This is incorrect. The sum of the temperatures from Wednesday to Sunday is , which results in an average of , not .
25.6
This is the actual temperature recorded on Friday (), rather than the calculated 5-point moving average.
26.0
This value is incorrect. It is significantly higher than the actual average of the temperatures from Wednesday to Sunday.
Annual sales data and related quarterly indices are shown. The quarterly indices were calculated by applying the average percentage method using the mean.
| Quarter | Q1 | Q2 | Q3 | Q4 |
|---|---|---|---|---|
| Sales | 160 | 128 | 200 | |
| Index | 1.0 | 0.95 | 1.25 |
Determine the values for and .
122 | 0.8
122 | 3.2
152 | 0.8
152 | 3.2
Reveal Answer
122 | 0.8
While the value for (0.8) is correct, the value for is incorrect. The average quarterly sales is 160 (calculated as ), so should be .
122 | 3.2
Both values are incorrect. The sum of quarterly indices must equal 4, making , and the sales value is calculated by multiplying the average sales (160) by the index (0.95).
152 | 0.8
The sum of quarterly indices is 4, so . The deseasonalized average sales is 160 (derived from ), so .
152 | 3.2
The value for (152) is correct, but is incorrect. The sum of the indices must equal 4, not the partial sum of the other indices (3.2).
The table lists the number of books sold per month by an online bookstore. If the simple 3-point moving average in October is 54, what is the simple 3-point moving average in May?
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 45 | 52 | 68 | 65 | 89 | 65 | 53 | 33 | 40 | 45 | 77 | 92 |
69
73
74
89
Reveal Answer
69
This value represents the centered moving average for June (calculated as ), rather than May.
73
The context provided for October () indicates a centered moving average. For May, the calculation uses the values from April, May, and June: .
74
This result comes from using a trailing moving average (March, April, May: ), but the problem context establishes that a centered moving average is used.
89
This is the actual number of books sold in May, not the 3-point moving average.
The table shows time series data for a company's quarterly sales.
| Quarter | 1 | 2 | 3 | 4 |
|---|---|---|---|---|
| Sales ($) | 2700 | 3600 | 4500 | 7200 |
| Seasonal index | 0.6 | 0.8 | 1.0 | — |
Determine the seasonally adjusted sales ($) for the fourth quarter.
4500
6000
8640
11 520
Reveal Answer
4500
The sum of seasonal indices for four quarters must equal 4. The Q4 index is . Seasonally adjusted sales are calculated by dividing actual sales by the index: .
6000
This assumes the seasonal index follows a linear pattern (0.6, 0.8, 1.0, 1.2) and divides sales by 1.2. However, seasonal indices must sum to the number of periods (4), making the correct Q4 index 1.6.
8640
This result likely comes from estimating the index incorrectly as 1.2 (based on a pattern) and multiplying it by the sales, rather than dividing by the correct index.
11 520
This is the result of multiplying the actual sales by the seasonal index (). To deseasonalize data (find seasonally adjusted sales), you must divide the actual sales by the seasonal index.
The number of visitors each month to a zoo is seasonal.
To correct the number of visitors in January for seasonality, the actual number of visitors, to the nearest percent, is increased by 35%.
The seasonal index for that month is closest to
0.61
0.65
0.69
0.74
0.77
Reveal Answer
0.61
Incorrect. This is the result of calculating , which would correspond to a 65% increase rather than a 35% increase.
0.65
Incorrect. This incorrectly assumes the seasonal index is found by simply subtracting the percentage increase from 1 ().
0.69
Incorrect. This is a miscalculation. The correct seasonal index is found by solving .
0.74
Correct. Increasing the actual value by 35% means multiplying by 1.35. Since the deseasonalised value equals the actual value divided by the seasonal index, the seasonal index is .
0.77
Incorrect. This value would be the seasonal index if the actual number of visitors was increased by about 30% (), not 35%.
Buffalo fly bites cause skin wounds on cattle. The table shows the average number of skin wounds per animal in a herd for two years.
| Autumn | Winter | Spring | Summer | |
|---|---|---|---|---|
| 2021 | 285 | 28 | 195 | 460 |
| 2022 | 276 | 22 | 170 | 392 |
Deseasonalise the data.
Reveal Answer
| Year | Season | Number of skin wounds | Yearly average | Number / Yearly average | Seasonal indices | Deseasonalised number |
|---|---|---|---|---|---|---|
| 2021 | Autumn | 285 | 242 | 1.1776... | 1.2307... | 232 |
| Winter | 28 | 0.1157... | 0.1090... | 257 | ||
| Spring | 195 | 0.8057... | 0.7982... | 244 | ||
| Summer | 460 | 1.9008... | 1.8620... | 247 | ||
| 2022 | Autumn | 276 | 215 | 1.2837... | 1.2307... | 224 |
| Winter | 22 | 0.1023... | 0.1090... | 202 | ||
| Spring | 170 | 0.7906... | 0.7982... | 213 | ||
| Summer | 392 | 1.8232... | 1.8620... | 211 |
| Descriptor | Marks |
|---|---|
correctly determines the yearly averages | 1 |
determines number/yearly average values | 1 |
determines seasonal indices | 1 |
determines deseasonalised numbers | 1 |
The table shows a swimwear company’s seasonally adjusted swimsuit sales (in thousands).
| Spring | Summer | Autumn | Winter | |
|---|---|---|---|---|
| Seasonally adjusted swimsuit sales (in thousands) | 33.3 | 34.8 | 36.4 | 35.8 |
The long-term seasonal indices for spring, summer and winter are 1.11, 1.42 and 0.62 respectively.
Determine the actual swimsuit sales for autumn.
Reveal Answer
Let autumn's seasonal index
Total of seasonal indices:
Actual value for autumn
In autumn they had actual sales of 30 940 swimsuits.
| Descriptor | Marks |
|---|---|
correctly identifies the sum of all the seasonal indices | 1 |
correctly determines autumn's seasonal index | 1 |
uses an appropriate method for determining actual value | 1 |
determines actual sales for autumn | 1 |
The table shows the profit made each year (in thousands of dollars) by a small business.
| Year | Profit ($'000s) |
|---|---|
| 2015 | 42.1 |
| 2016 | 36.9 |
| 2017 | 48.4 |
| 2018 | 52.3 |
| 2019 | 56.1 |
| 2020 | 59.8 |
Use a mathematical model to determine the equation of the least-squares line to fit this data.
Reveal Answer
Let the number of years since 2014
Let the business's annual profit (in $'000s)
| Descriptor | Marks |
|---|---|
correctly defines the variables | 1 |
correctly determines the equation of the least-squares line | 1 |
Use the least-squares line to forecast the profit in 2021, to the nearest hundred dollars.
Reveal Answer
For 2021,
The business will make $64 300.
| Descriptor | Marks |
|---|---|
correctly determines the value | 1 |
determines profit | 1 |