Year (iv) Use the forecast equation to obtain the projected rates for the quarters of 2021. Provide a table with your output variables. Period Forecast Seasonal Index Quarter CPI Seasonal rate Forecast Seasonalized Forecast (v) Compute the MSE, MAD and MAPE for the seasonalized forecast for 2019 manually (Show ALL workings). [ (F-A) (F-A)² (i) Using the MSE, MAD and MAPE, compare the forecasted data to the actual data for 2021 and comment on the accuracy of the forecasts obtained. (F-A)/A
Year (iv) Use the forecast equation to obtain the projected rates for the quarters of 2021. Provide a table with your output variables. Period Forecast Seasonal Index Quarter CPI Seasonal rate Forecast Seasonalized Forecast (v) Compute the MSE, MAD and MAPE for the seasonalized forecast for 2019 manually (Show ALL workings). [ (F-A) (F-A)² (i) Using the MSE, MAD and MAPE, compare the forecasted data to the actual data for 2021 and comment on the accuracy of the forecasts obtained. (F-A)/A
Chapter4: Linear Functions
Section4.3: Fitting Linear Models To Data
Problem 24SE: Table 6 shows the year and the number ofpeople unemployed in a particular city for several years....
Related questions
Question
Year | Consumer price index |
2001 | 0.9576707944 |
2001 | 1.043445267 |
2001 | 0.1314307172 |
2001 | -0.2812675892 |
2002 | 0.3572771719 |
2002 | 1.086752857 |
2002 | 0.4263206673 |
2002 | 0.3137689184 |
2003 | 1.011959522 |
2003 | 0.364298725 |
2003 | 0.4900181488 |
2003 | 0.01806032147 |
2004 | 0.9028530155 |
2004 | 1.431639227 |
2004 | 0.352858151 |
2004 | 0.5977496484 |
2005 | 0.6291506466 |
2005 | 1.337269885 |
2005 | 1.216795201 |
2005 | 0.5079580088 |
2006 | 0.539083558 |
2006 | 1.692359249 |
2006 | 0.5602240896 |
2006 | -0.8520399803 |
2007 | 1.019170385 |
2007 | 1.917329089 |
2007 | 0.2759287112 |
2007 | 1.711214555 |
2008 | 1.136773642 |
2008 | 2.195344656 |
2008 | 1.163055346 |
2008 | -2.828529429 |
2009 | -0.497633075 |
2009 | 1.060302337 |
2009 | 0.6790719816 |
2009 | 0.2011885888 |
2010 | 0.4014150536 |
2010 | 0.4750721517 |
2010 | 0.09325049836 |
2010 | 0.2949163207 |
2011 | 1.264822375 |
2011 | 1.743310892 |
2011 | 0.4085179843 |
2011 | -0.1520557705 |
2012 | 0.7956386559 |
2012 | 0.8275317381 |
2012 | 0.219328148 |
2012 | 0.03604046954 |
2013 | 0.5903298758 |
2013 | 0.5409806119 |
2013 | 0.3779793413 |
2013 | -0.2790676461 |
2014 | 0.7612225297 |
2014 | 1.180867814 |
2014 | 0.1146758445 |
2014 | -0.8033517566 |
2015 | -0.5431990017 |
2015 | 1.205595644 |
2015 | 0.2626773738 |
2015 | -0.4498436877 |
2016 | 0.06463406581 |
2016 | 1.172350557 |
2016 | 0.3326819411 |
2016 | 0.2225741972 |
2017 | 0.790736963 |
2017 | 0.5435177058 |
2017 | 0.3966156914 |
2017 | 0.3706296363 |
2018 | 0.8861183798 |
2018 | 1.033075567 |
2018 | 0.3272675678 |
2018 | -0.05749473626 |
2019 | 0.3351160343 |
2019 | 1.198513227 |
2019 | 0.2741660078 |
2019 | 0.2130179974 |
2020 | 0.4194274219 |
2020 | -0.5400354172 |
2020 | 1.131485375 |
2020 | 0.2299502502 |
Using this information provided above please provide solutions for the questions in screen shot.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 10 images
Recommended textbooks for you