Question 1)

Find the best exponential smoothing model by evaluating the MSE for from 0.1 to 0.9 in increments of 0.1.

question 2)

What is the forecast for week 16, using a 2 (3)-period moving average?

question 3)

Find the optimal for MSE, MDA and MAPE

1. A electronic store wants to forecast its weekly sales. Historical data (in dollars) for fifteen weeks are shown below and can be found in the Excel worksheet Excel . 1. Use data to answer the following questions: Excel 1. 1. A electronic store wants to forecast its weekly sales. Historical data (in dollars) for fifteen weeks are shown below and can be found in the Excel worksheet Excel . 1. Use data to answer the following questions: Excel 1