1. For this, Use a three-week weighted moving average to calculate the mean squared error. Be sure to Use the weights of 40% for the most recent data, 35% for the second most recent data, and 25% for the oldest data. Squared Forecast Forecast Error Error Week Forecast 1 2 3 Time Series Value 18 13 16 11 15 13 4 5 6 A. For calculating the Mean squared error, there is really no reason to forecast the future, but here is an example of how to calculate a forecast for period 7 solely just to demonstrate how the weighted average calculation is completed. (show detail work) Example: 11(-25) + 15(.35) + 13(.45) = period 7's forecast (again, period 7's forecast is not used in calculating the MSE for this problem) B. Using the same table above to calculate the mean squared error, using the exponential smoothing method with a smoothing constant of 0.3... (show detail work) (Reminder: Period 1's forecast is the same as period 1's actual and this forecast is not used in calculating the MSE when using exponential smoothing) C. Tell me Which of the two forecasting methods above fits the data the best according to your mean squared error calculations? (show detail work)