Transcribed Image Text
Problem 15-05 (Algorithmic)Consider the following time series data.Week123456Value161318111514Develop a three-week moving average for this time series.Compute MSE and a forecast for week 7. Round your answers to twodecimal places.WeekTime SeriesValueForecast116213318411515614MSE: ——————The forecast for week 7: ————————Use  = 0.2 to compute the exponential smoothingvalues for the time series. Compute MSE and a forecast for week 7.Round your answers to two decimal places.WeekTime SeriesValueForecast116213318411515614MSE: ————————The forecast for week 7: ——————Use trial and error to find a value of the exponentialsmoothing coefficient  that results in a smaller MSE thanwhat you calculated for  = 0.2. Find a valueof  for the smallest MSE. Round your answer to threedecimal places.alpha = ——————————