oft Excel Activity #6: Forecast Accuracy Comparison x 3. What is the MAD, the MSE, the MAPE, the RSFE, and the tracking signal for each forecasting method? Do not round intermediate calculations. Round your answers to two decimal places. Use the minus sign to enter negative values, if any. RSFE MAD MSE MAPE Forecast 1 % % Forecast 2 Forecast 1 Tracking Signal: Forecast 2 Tracking Signal: 4. What can be concluded about the quality of the forecasts 12 Assume that the controllimit for the tracking signal is +3 The results indicate of +3 In the forecasts 1, and that the tracking signal within the control limits 5. What can be concluded about the quality of the forecasts 2? Assume that the controllimit for the tracking signal is +3 The results indicate in the forecasts 2, and that the tracking signal within the control limits of 3 Check My Work Reset Problem Next 00 H E 000 1 D4 AA A B D E F G 3 Period Sales Forecast Error Absolute Error Error 2 Abs. % Error iCloud 4 1 273 280 5 2 285 268 id 6 3 290 288 7 4 283 287 8 5 273 270 D 9 6 268 269 10 7 262 261 Tags 11 8 274 268 R 12 13 Total g 14 15 Average 16 RSFE MAD MSE MAPE 17 18 Tracking Signal 19 20 Forecast 2 21 Period Sales Forecast Error Absolute Error Error2 Abs. % Error 22 1 270 23 2 285 288 24 3 290 293 25 4 283 296 26 5 273 272 27 6 268 272 28 7 262 261 29 8 274 275 30 31 Total 22 E B Sheet1 + Er 273 Calculation Mode: Automatic Workbook Statistics