$1$

Using simple exponential smoothing, and the following time series data, respond to each of the items.

$\backslash$table$[[33],[$points$],[$Sklpped$],[$eBook$],[$Print$],[$References$]]$

$\backslash$table$[[$Period$,$Demand$],[1,118],[2,146],[3,157],[4,151],[5,160],[6,164],[7,115],[8,140],[9,130],[10,129]]$

Cllck here for the Excel Data File

b$.$ Compute all possible forecasts using a smoothing coefficient $($a$)$ of $0\mathrm{.}3.($Negative amounts should be indicated by a minus sign. Round your answers to $1$ decimal place.$)$

$\backslash$table$[[$Poriod$,$Demand,$\backslash$table$[[$Exponentlal$],[$Smooth$]],$Error,Absoluto Error$],[1,118,,,],[2,146,,,],[3,157,,,],[4,151,,$

$,],[5,160,,,],[6,164,,,]]$

C$.$ Conpute the MAD $($two decinal places$)$

D$.$ What is the forecast demand for period $11?($Rohnd to $1$ decimal place$)$

E$.$ What is the error associated with peeiod $11\text{'}$s forecast $($ round to two decimal places$)$