Question: For the data below, based on a 3 period moving average forecasting method calculate the following: Year Quarter Sales 1 1 154 2 130 3
For the data below, based on a 3 period moving average forecasting method calculate the following:
| Year | Quarter | Sales |
| 1 | 1 | 154 |
| 2 | 130 | |
| 3 | 186 | |
| 4 | 182 | |
| 2 | 1 | 145 |
| 2 | 118 | |
| 3 | 145 | |
| 4 | 120 | |
| 3 | 1 | 114 |
| 2 | 149 | |
| 3 | 183 | |
| 4 | 103 | |
| 4 | 1 | 132 |
| 2 | 186 | |
| 3 | 182 | |
| 4 | 105 | |
| 5 | 1 | 178 |
| 2 | 180 | |
| 3 | 153 | |
| 4 | 128 |
1) Calculate the mean absolute error. ANSWER TO 2 DECIMAL PLACES
2) Calculate the mean square error. ANSWER TO 2 DECIMAL PLACES
3) Calculate the absolute percentage error. ANSWER AS A PERCENT TO 2 DECIMAL PLACES...INCLUDE UNITS (I.E. THE PERCENT SIGN)
4) Predict the the number of sales for the first quarter of year 6. ANSWER TO 0 DECIMAL PLACES
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
