Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.)WeekTime SeriesValueForecast118211316410 Incorrect: Your answer is incorrect.517 Incorrect: Your answer is incorrect.615 Incorrect: Your answer is incorrect.Compute MSE. (Round your answer to two decimal places.)MSE

Three-week moving average forecast

Step-by-step explanation:

Given

Solving (a): Three-week moving average forecast

This is calculated as:

Since it is three-week, we start from t = 3

For t = 3; we consider months 1, 2 and 3

For t = 4; we consider months 2, 3 and 4

For t = 5; we consider months 3, 4 and 5

So, the forecast are:

Solving (b): MSE

To do this, we simply calculate the square of the forecast error

The forecast error (E) is:

So, we have:

Forecast error                                                     The square

∠A=53, and AB=13.7734922397

Step-by-step explanation:

Angles in a triangle add up to 180.

∠A+∠B+∠C=180

∠A+37+90=180

∠A=53

Use sine rule:

x/sinX=y/sinY

AB/sin∠C = CB/sin∠A

AB/sin90 = 11/sin53

AB/1=11/0.79863551004

AB=13.7734922397