Two different forecasting techniques $($F$1$ and F$2)$ were used to forecast demand for cases of bottled water. Actual demand and the two appears to be more accurate.

b$.$ Compute the MSE for each set of forecasts. Given your results, which forecast appears to be more accurate?

Note: Round your answers to $2$ decimal places. Either one might already be in use, familiar to users, and have past values for comparison. If

are used, MSE would be natural; if

are used, Mt

d$.$ Compute MAPE for each data set. Which forecast appears to be more accurate?

Note: Round your intermediate calculations and final answers to $2$ decimal places.

appears to be more accurate.

sets of forecasts are as follows:

Click here for the Excel Data File

a$.$ Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate?

Note: Round your answers to $1$ decimal place.