A retail store tracks its quarterly sales over two years. The table shows the sales data (in thousands of dollars) and the calculated seasonal indices using the average percentage method. Determine the deseasonalised sales value for Quarter 2, Year 2022.
General Mathematics · Unit 3 · Time series analysis · Analysing time series data
Deseasonalise a time series by calculating the seasonal indices using the average percentage method, including the use of spreadsheets.
Practise this objective
AI-marked practice questions tied to QCAA mark schemes for this exact LO. Free to start.
Start free practicePractice questions for this objective
Full questions, answers and worked solutions unlock when you start a free practice session.
A café records its coffee sales (in hundreds of cups) over two years. The table shows the sales for each season. Calculate the seasonal indices using the average percentage method and determine the deseasonalised sales for Summer 2024.
A furniture retailer records sales revenue (in $1,000s) for each quarter over two years. The data is shown in the table below. Calculate the seasonal indices using the average percentage method and determine the deseasonalised sales revenue for 2024 Quarter 3.
A craft brewery records its beer sales (in kilolitres) each quarter for two consecutive years. The data is shown in the table below. Calculate the seasonal indices for each quarter using the average percentage method with the mean.
The table shows the quarterly electricity consumption (in megawatt hours, MWh) for a regional shopping centre over two years. Deseasonalise the data and determine the deseasonalised electricity consumption for Quarter 3 of 2025.
A café records the average number of customers per quarter over two years. The table shows the actual customer counts and the seasonal indices calculated using the average percentage method with the mean. Determine the deseasonalised customer count for Q3 in Year 2.