Exercise Two: Given the date below for Chambers Electronics, and using your knowledge of Forecasting Time Series with Seasonal Indices, (a) find the Centered Moving Average as shown in class (use the same weights as shown in class, and they must add up to 4), (b) compute the Seasonal Ratio, (c) find the Seasonal Index, (d) calculate the Deseasonalized Values, (e) compute the Deseasonalized Forecast for the given series, (f) tabulate the Actual Forecast for the given series, (g) find the Mean Absolute Deviation, the Mean Squared Error, and the Mean Absolute Percentage Error, (h) forecast the Deseasonalized Values for periods 21, 22, 23, and 24, (i) forecast the Actual values for periods 21, 22, 23, and 24, (k) as shown in class, use the GRG-Non Linear Solver to find the weights that minimize the Mean Absolute Percentage Error (MAPE). (5 points) 2018 (Given) Quarter 1 Quarter 2 Quarter 3 2016 205 184 174 215 2017 225 205 205 306 266 194 215 326 2019 286 255 235 387 2020 347 266 296 519 Quarter 4 Exercise Two: Given the date below for Chambers Electronics, and using your knowledge of Forecasting Time Series with Seasonal Indices, (a) find the Centered Moving Average as shown in class (use the same weights as shown in class, and they must add up to 4), (b) compute the Seasonal Ratio, (c) find the Seasonal Index, (d) calculate the Deseasonalized Values, (e) compute the Deseasonalized Forecast for the given series, (f) tabulate the Actual Forecast for the given series, (g) find the Mean Absolute Deviation, the Mean Squared Error, and the Mean Absolute Percentage Error, (h) forecast the Deseasonalized Values for periods 21, 22, 23, and 24, (i) forecast the Actual values for periods 21, 22, 23, and 24, (k) as shown in class, use the GRG-Non Linear Solver to find the weights that minimize the Mean Absolute Percentage Error (MAPE). (5 points) 2018 (Given) Quarter 1 Quarter 2 Quarter 3 2016 205 184 174 215 2017 225 205 205 306 266 194 215 326 2019 286 255 235 387 2020 347 266 296 519 Quarter 4