Question: NOTE: Show and use excel formulas for each and all calculations and round to two decimals Q 2 For each of the forecasts and demand
| NOTE: Show and use excel formulas for each and all calculations and round to two decimals | ||||||
| Q 2 | For each of the forecasts and demand below, calculate the Mean Absolute Deviation, | |||||
| Mean Squared Error and Mean Absolute Percent Error. | ||||||
| Use the ABS formula for Absolute Value. (3 marks) | ||||||
| week | Demand | Forecast | Error (e) | Abs e | e^2 | Abs e/A*100% |
| 1 | 85 | 77 | ||||
| 2 | 76 | 82 | ||||
| 3 | 81 | 56 | ||||
| 4 | 68 | 72 | ||||
| 5 | 75 | 80 | ||||
| 6 | 83 | 75 | ||||
| MAD = | ||||||
| MSE = | ||||||
| MAPE = | ||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
