Problem $3-20($Algo$)$

An analyst must decide between two different forecasting techniques for weekly sales of roller blades: a linear trend equation and the naive approach. The linear trend equation is $F_t=124+2\mathrm{.}1t,$ and it was developed using data from periods $1$ through $10.$ Based on data for periods $11$ through $20$ as shown in the table, which of these two methods has the greater accuracy if MAD and MSE are used? Note: Round your intermediate calculations and final answers to $2$ decimal places.

$\backslash$table$[[t,$Units Sold$],[11,148],[12,149],[13,148],[14,145],[15,153],[16,152],[17,152],[18,159],[19,161],[20,165]]$

Click here for the Excel Data File

$\backslash$table$[[$MAD $($Naive$),],[$MAD $($Linear$),],[$MSE $($Naive$),],[$MSE $($Linear$),]]$

provides forecasts with less average error and less average squared error.