1. Identify a relevant time series for household final consumption expenditure on household appliances at current prices for the Australian state that you have been designated in iLearn. The series should begin in September 1983, and end in December 2019. Briefly explain how you obtained the relevant time series and provide a reference here. Data should be available through the Australian Bureau of Statistics (ABS). Provide a line chart of the relevant time series. Identify any structural breaks if any. 2. Comment in general on the characteristics of the time series line chart. What systematic components are evident in the time series? By referring to the time series plot, explain your answer. (Please note Question 4 before you answer this question). 3. Using a corellogram, confirm the presence of the systematic components of the time series. . Explain your answer. 4. Outline the economic and environmental factors or circumstances which are likely to have influenced the characteristics or components of the time series. Will these factors or circumstances apply to the relevant forecasting period? Explain your answer. 5. Use (multiplicative) Winters’ Exponential Smoothing in Excel to smooth (remove randomness) the chosen time series for just the last 4 years of data to help further identify the relevant systematic components. Explain what you have done. 6. From the results of the above smoothing, provide a 4-year time series line chart comparing the original time series with the generated smoothed values. Comment on your smoothing. Include the forecasts from question #10 as part of your line chart above – which would create a 5-year timeseries line chart. 7. Perform the appropriate tests for whether your model has captured all the systematic components and/or whether the errors are random. Explain your answer. 8. Using mathematical notation, write out all the equations that represent the systematic components of your Winters’ Exponential Smoothing model.
#Sales Offer!| Get upto 25% Off: