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 alpha that results in a smaller MSE than whatyou calculated for alpha = 0.2. Find a value of alpha for thesmallest MSE. Round your answer to three decimal places.Alpha = ________Please solve for part C! Thank you !