$1-$ Please submit an Excel file on the Blackboard. You must sign into MS$-$Excel using your student email so it$$s possible to see your name on the top of the screen.

Question $1$: Please use $$UnitedDairies$$ data set and apply the following:

$1-$ Compute forecasts for all of the $12$ weeks, using two of the following methods: the na$$ve forecasting method, the average of past values, moving average $($k $=4),$ or the exponential smoothing.

$2-$ For the two forecasts methods, measure the forecast accuracy using Mean Absolute Error $($MAE$)$

$3-$ For the two forecasts methods, measure the Mean Absolute Percentage Error $($MAPE$)$

$4-$ Compare the accuracy of the two forecasting methods by comparing the values of MAE and MAPE for each method.