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=127+1\mathrm{.}8t,$ and it was developed using data from periods $1$ through $10.$ Based of 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?

$($Round your intermediate calculations and final answers to $2$ decimal places.$)$

$\backslash$table$[[t,$Units Sold$],[11,147],[12,149],[13,151],[14,142],[15,154],[16,151],[17,154],[18,155],[19,161],[20,163]]$

Click here for the Excel Data File

Answer is complete but not entirely correct.

$\backslash$table$[[$MAD$,4\mathrm{.}44],[\backslash$table$[[($Naive$)]],],[\backslash$table$[[$MAD$],[($Linear$)]],2\mathrm{.}44],[\backslash$table$[[$MSE$],[($Naive$)]],4\mathrm{.}44],[\backslash$table$[[$MSE$],[($Linear$)]],2\mathrm{.}44]]$

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

Please help find bottom MSE $($Native$)$ and MSE $($Linear$).$ Show clear steps with clear computation