Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Questions Obtain the ABS statistics for Building Approvals, Australia - 8731006 - available at: https://www.abs.gov.au/statistics/industry/building-and-construction/building-approvals- australia/jun-2022 Download Table 6. For the purposes of this report
Questions Obtain the ABS statistics for Building Approvals, Australia - 8731006 - available at: https://www.abs.gov.au/statistics/industry/building-and-construction/building-approvals- australia/jun-2022 Download Table 6. For the purposes of this report you are to consider the Total number of dwelling units building approvals data. There are three series in Table 6: Original, Seasonally-adjusted, and Trend (please choose carefully throughout this report!)Exercise 1 - Application (10 marks) For the purposes of this report, only consider the data from July 2012 to June 2021 as the sample of data that is available to you - that is, ignore any recent observations. This means that the first actual observation in your Excel file is from July 2012 and your last actual observation in your Excel file is from June 2021. For the Seasonally-adjusted data for the Total number of dwelling units (Series ID: A418431A) available in Table 6: Forecast the out-of-sample values for every month in the period July 2021-June 2022 (both months inclusive) using Holt's Exponential Smoothing with the following parameters: alpha = 0.15 and beta = 0.15. For the seed of the level use the first observation, Y1. For the seed of the trend use [(Y2 - Y1) + (Y3 - Y2)/2] Before you begin Exercise 1, let's check that you have the right data! The average should be 9756.3! Once you perform Holt's Exponential Smoothing with parameters alpha and beta, what are the following numerical values: 1. The within-sample forecast for March 2021. 2. The out-of-sample forecast for September 2021. 3. The out-of-sample forecast for June 2022. 4. The MAE. 5. The MSE. Critically think for a way to optimise alpha and beta via the MSE, and report the following values after your optimisation: 6. Alpha. 7. Beta. 8. The MSE. 9. The out-of-sample forecast for September 2021. 10. The out-of-sample forecast for June 2022
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started