please use excel and show formulas!

Moving Average and Simple Exponential Smoothing 1. (2 points) Compute the moving-average forecast for the data in forecast data. x ls x, with a 3-day window. What is the forecast for 1/2/2016 ? 2. (2 points) What is the root mean squared error (RMSE) of the 3 -day moving average model? 3. (2 points) Compute the simple exponential smoothing forecast with smoothing constant a=0.6. What is the forecast for 1/2/2016 in this model? 4. (4 points) What is the optimal smoothing constant a (use increments of .05)? What is the RMSE when this a is used? Holt's Method 5. (2 points) Using Holt's method with a smoothing constant a=0.3 and a trend constant =0.6, what is the forecast for 1/2/2016 ? It's okay if your forecast goes negative at some points (although it shouldn't be negative for 1/2/2016 ). 6. ( 2 points) What is the RMSE if we use a smoothing constant a=0.3 and a trend constant =0.6? 7. (6 points) What are the optimal constants a and (use increments of .05 for each)? What is the RMSE when these optimal constants are used