$4$

Exerclse $10\mathrm{.}3$ Static

$1\mathrm{.}66$ peints

eBoom The owner of a corvenience store near Salt Lake City in Utah hos been tobulating weekly sales at the store, excluding gas. The occomponying data fle contains the soles for $30$ weeks.

Click here for the Excel Dato Fils

a$.$ Use the $3-$period moving averoge to forecast soles for the $3$ ist week.

Note: Do not round intermediate calculations. Round final answer to $2$ decimal places.

$9p^2$

b$.$ Use simple exponentiol smoothing with $a=0\mathrm{.}3$ to forecost soles for the $31$s: week.

Note: Do not round intermedlate calculations. Round final answer to $2$ decimal places.

${}_t=$

c$-1.$ Report the performance meosures for the techniques in ports a and $b.$

Note: Do not round intermediate calculations. Round final answers to $2$ decimal places.

$\backslash$table$[[$Technique$,$USE,MAD,MAPE $($Y$)],[$Maving average,,,$],[$Exporertial smopthing,,,$]]$

c$.2$ Which is the preferred technique for moking the forecost?

out of $3$ perfornance measures