It appears that you have a forecasting assignment utilizing the Excel "UnitedDairies" dataset. You will have to use a variety of forecasting techniques and calculate the Mean Absolute Error $($MAE$)$ and Mean Absolute Percentage Error $($MAPE$)$ to gauge how accurate your predictions are. Here's how to handle this work in Excel step$-$by$-$step:

Open MS Excel after logging up with your student email.

The "UnitedDairies" dataset should load.

Utilize weeks $1$ through $12\text{'}$s sales data that is supplied.

From the list of available forecasting techniques, select two: na$$ve$,$ average of previous values, moving average with k $=4,$ or exponential smoothing.

Make projections for each of the $12$ weeks utilizing the chosen techniques.

Calculate the mean absolute difference $($MAE$)$ between the predicted and actual values for every forecasting method.

Use the formula:

where Fi$$ is the forecasted value and Ai$$ is the actual value.

Explanation:

Use the formula:

where Fi$$ is the forecasted value and Ai$$ is the actual valu