Question: Please include excel file with working. Here is the excel file link: https://docs.google.com/spreadsheets/d/1iW8cRV1zAGCXRprAMpj5cK1AxwlJDChwgB1vc7idalA/edit?usp=drivesdk For this question, you will use the dataset on quarterly Australian GDP
Please include excel file with working. Here is the excel file link: https://docs.google.com/spreadsheets/d/1iW8cRV1zAGCXRprAMpj5cK1AxwlJDChwgB1vc7idalA/edit?usp=drivesdk

For this question, you will use the dataset on quarterly Australian GDP from 1972 to 1997: Australian GDP.Xlsx- You will generate forecasts for 1998 Quarter 1 using four methods. For simple linear regression, remember that you will need to nd the intercept and slope, then calculate a predicted value. Forecast for 1998 Quarter 1 Forecasting (Answer to two method decimal places as needed. Do not use any separators, i.e.: "," or space.) Mean/average method Naive method Drift method Simple linear regression (SLR)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
