Question: Utilizing these concepts how would you answer the following using Excel QM - the Error Analysis model. The following table shows the number of pies
Utilizing these concepts how would you answer the following using Excel QM - the Error Analysis model.
The following table shows the number of pies consumed by the deans' suite during a monthly pie-eating contest.
| Month | Forecast # Pies | Actual # Pies |
| January | 18 | 15 |
| February | 20 | 18 |
| March | 23 | 26 |
| April | 29 | 31 |
| May | 37 | 34 |
| June | 44 | 39 |
| July | 50 | 45 |
What is the forecast MAD?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
