Question: 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
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 2. 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).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
