New Exercise Bank Content Qu$.04-17$

Ben Swanson, owner and manager of Swanson's Department Store, has decided to use statistical forecasting to get a better handle on the demand for his major products. However, Ben now needs to decide which forecasting method is most appropriate for each category of product. One category is major household appliances, such as washing machines, which have a relatively stable sales level. Monthly sales of washing machines last year are shown below.

$\backslash$table$[[$Month$,$Sales$],[$January$,23],[$February$,24],[$March$,22],[$April$,28],[$May$,22],[$June$,27],[$July$,20],[$August$,26],[$September$,21],[$October$,29],[$November$,23],[$December$,28]]$

Click here for the Excel Data File

a$.$ Use the last$-$value method retrospectively to determine what the forecasts would have been for the last $11$ months of last year. What are MAD and MSE?

Note: Round your answers to $1$ decimal place.

$\backslash$table$[[$MAD$,],[$MSE$,]]$