$3$ Connect Assignment i

Saved

Help

Save & Exit

Check my wo

Two different forecasting techniques $($F$1$ and F$2)$ were used to forecast demand for cases of bottled water. Actual demand and the two sets of forecasts are as follows:

$\backslash$table$[[,,$PREDICTED$],[$Period$,$Demand,F$1,$F$2],[1,68,61,60],[2,75,67,66],[3,70,75,70],[4,74,69,67],[5,69,74,72],[6,72,67,78],[7,80,74,78],[8,78,76,80]]$

Click here for the Excel Data File

Compute MAPE for each data set. Which forecast appears to be more accurate? $($Round your intermediate calculations to $2$ decimal places and and final answers to $2$ decimal places.$)$

$\backslash$table$[[,,],[$MAPE F$1,,\%$