The table given below indicates Small Holding Ltd.’s quarterly profits in 2019 and 2020. Time Period Profit (Thousands Of Rands) 2019 Q1 250 2019 Q2 210 2019 Q3 165 2019 Q4 195 2020 Q1 265 2020 Q2 218 2020 Q3 178 2020 Q4 204 Q.6.3.1 Determine the trend regression function for this data set. In order to obtain full marks for this question, you must complete the relevant table (template provided below) and then apply the appropriate time series formulae in the formulae sheet. Q.6.3.2 Given that the typical seasonal index for Q3 is 87.3, use this information and the trend regression function obtained in Q.6.3.1 to determine the seasonally adjusted trend estimate for profits in Q3 of 2022.
The table given below indicates Small Holding Ltd.’s quarterly profits in 2019 and 2020.
Time Period Profit (Thousands Of Rands)
2019 Q1 250
2019 Q2 210
2019 Q3 165
2019 Q4 195
2020 Q1 265
2020 Q2 218
2020 Q3 178
2020 Q4 204
Q.6.3.1 Determine the trend regression
table (template provided below) and then apply the appropriate time
series formulae in the formulae sheet.
Q.6.3.2 Given that the typical seasonal index for Q3 is 87.3, use this information
and the trend regression function obtained in Q.6.3.1 to determine the
seasonally adjusted trend estimate for profits in Q3 of 2022.
Step by step
Solved in 2 steps
