Question $10(5$ points$)$

$($a$)$ Forecast from $3-$week moving average is $\_\_\_\_\_($round to $2$ decimal places, e$.$g$.,0\mathrm{.}62)$

Your Answer:

Question $10$ options:

Answer

Question $11(5$ points$)$

$($a$)$ MSE from $3-$week moving average $($round to $2$ decimal places, e$.$g$.,0\mathrm{.}62)$

Your Answer:

Question $11$ options:

Answer

Question $12(8$ points$)$

Question $12$ options:

$($b$)$ After filling in column F for the exponential smoothing forecasts, copy and paste here the exact Excel formulas you have in cell F$7(2$nd week forecast$)$ and cell F$8(3$rd week forecast$).($The answer should include the $=$ sign and no spaces. $ signs should be included as appropriate. Examples of acceptable formats: $=$E$8,=$$G$$6*(1-$$G$$6)/$F$27))$

Cell F$7$:

Cell F$8$:

Question $13(5$ points$)$

$($b$)$ MSE from exponential smoothing with alpha$=0\mathrm{.}4($round to $2$ decimal places, e$.$g$.,0\mathrm{.}62)$

Your Answer:

Question $13$ options:

Answer

Question $14(5$ points$)$

$($c$)$ Best alpha is$?$

Your Answer:

Question $14$ options:

Answer

Question $15(5$ points$)$

$($c$)$ The MSE of the better forecasting method is$?($round to $2$ decimal places, e$.$g$.,0\mathrm{.}62)$

Your Answer:

Question $15$ options:

Answer