Question
Suppose the data in the table below represents total revenues (in $ millions) for one real estate agency in the GTA. Fill in the Moving
Suppose the data in the table below represents total revenues (in $ millions) for one real estate agency in the GTA. Fill in the Moving Averages, Weighted Moving Averages (with weights 8,3,2 starting from the most recent time period), and the Exponential Forecast values in the table below:
Round your answers in part (a) to 2 decimal places.
YearRevenue3-Year Moving AveragesWeighted Moving AveragesExponential Smoothing
=
0.15
=0.15
20148.420155.62016620177.420188.920197.82020 Forecast
Round your answers in part (b) to 2 decimal places, and round the MAD/MAE to 3 decimal places.
(b) Calculate the MAD (mean absolute deviation), also known as the MAE (mean absolute error), for 3-year moving averages for 2017-2019 (use results from the previous problem).
YearRevenue3-Year Moving AveragesAbsolute Error20148.420155.62016620177.420188.920197.8MAD/MAE =
Round your answers in part (c) to 2 decimal places, and round the MAD/MAE to 3 decimal places.
(c) Calculate the MAD (mean absolute deviation), also known as the MAE (mean absolute error), for weighted moving averages for 2017-2019 (use results from the previous problem with weights 4,2,1 starting from the most recent time period).
YearRevenueWeighted Moving AveragesAbsolute Error20148.420155.62016620177.420188.920197.8MAD/MAE =
(d) Which method provides a better forecast of the revenue for 2017-2019? Round MAD/MAE to three decimal places.
- 3-Year Moving Averages, since the MAD/MAE for 3-Year Moving Averages is less than the MAD/MAE for Weighted Moving Averages.
- Weighted Moving Averages, since the MAD/MAE for Weighted Moving Averages is less than the MAD/MAE for 3-Year Moving Averages.
- 3-Year Moving Averages, since the MAD/MAE for 3-Year Moving Averages is greater than the MAD/MAE for Weighted Moving Averages.
- Weighted Moving Averages, since the MAD/MAE for Weighted Moving Averages is greater than the MAD/MAE for 3-Year Moving Averages.
- None of the above.
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