Excel Forecasting Homework Problem

Method: Exponential Smoothing with initial alpha = = 0.20. F(1) is not given.

The data for this problem is shown in the table below. Note: changes from the original problem dataset table are highlighted in yellow with bold font.

Excel Forecasting Homework Problem

Method: Exponential Smoothing with initial alpha = = 0.20. F(1) is not given.

The data for this problem is shown in the table below. Note: changes from the original problem dataset table are highlighted in yellow with bold font.

Time (t)	Actual A(t)
1	576.5
2	582.3
3	561.2
4	574.8
5	573.7
6	552.2
7	581.9
8	556.8
9	563.2
10	588.3
11	don't have yet

What is the Forecast for Time Period 11 using this method? ["541.489", "572.053", "558.490", "573.533", "538.300", "576.500", "554.496", "588.300"]

What is the value for Mean Absolute Error (MAE) using this method? ["11.040", "15.328", "12.800", "11.270", "10.622", "9.828", "11.110", "13.100"]

What is the value for Mean Square Error (MSE) using this method? ["157.859", "212.858", "202.038", "180.716", "158.836", "173.154", "132.534", "147.995"]

What is the value for Mean Absolute Percent Error (MAPE) using this method? ["1.903%", "2.289%", "1.951%", "1.745%", "2.283%", "2.006%", "1.762%", "2.019%"]

What is the Forecast for Time Period 11 using this method? ["541.489", "572.053", "558.490", "573.533", "538.300", "576.500", "554.496", "588.300"]

What is the value for Mean Absolute Error (MAE) using this method? ["11.040", "15.328", "12.800", "11.270", "10.622", "9.828", "11.110", "13.100"]

What is the value for Mean Square Error (MSE) using this method?

What is the value for Mean Absolute Percent Error (MAPE) using this method? [] ["1.903%", "2.289%", "1.951%", "1.745%", "2.283%", "2.006%", "1.762%", "2.019%"]