Average Forecasting

Open the same file CE excel, "average" sheet.

Use average forecasting to calculate the forecast value in column C$.$ The forecast value of week $12$ is

$112\mathrm{.}73$

$.$

Then calculate the forecast error value in column E$.$ The forecast error of week $12$ is

$[$ Select $]$

$.$

Then calculate the absolute forecast error value in column G$.$ The MAE is

$[$ Select $]$

$.$

Then calculate the squared forecast error value in column I. The MSE is

$[$ Select $]$

$.$

Then calculate the percentage forecast error value in column K and absolute percentage forecast error value in column M$.$ The MAPE is

$[$ Select $]$

$.$