X

Calibri $($Body$)$

$11$

$*A$

A

$A^{**}$

Wrap Text $v$

Number

Insert

Merge & Center

$ $\%$

$\%$

$9$

$00$

Conditional Format

Formatting as Table

Cell

Delete

$$

Format

sort $8$

Office Update To keep up$-$to$-$date with security updates, fixes, and improvements, choose Check for Updates.A$.$ Click Submit to complete this assessment.

Question $5$

Question $5$

$10$ points

Save Answe

Given the following demand, please generate forecasts by arithmetic mean, last period value, MA $(3),$ MA $(5),$ ES $(0\mathrm{.}1),$ ES $(0\mathrm{.}4),$ and ES $(0\mathrm{.}9).$ Please calculate MAD for each forecasting method. Which forecasting method performs the best, the worst?

Please USE excel to solve this problem, and submit vour aveal file $($You will see the excel submission link below this homework link$)$

MacBook Air

cops lock

D

F

H

J

shift

Help me step by step on how to do this on excel please.