Sheet1
| value | forecast | error | |error| | s | sqrd errors |
| 202 | 0 | ||||
| 191 | 202 | 11 | 11 | 121 | |
| 173 | 192 | 19 | 19 | 361 | |
| 169 | 181 | 12 | 12 | 144 | |
| 171 | 174 | 3 | 3 | 9 | |
| 175 | 172 | -3 | 3 | 9 | |
| 182 | 174 | -8 | 8 | 64 | |
| 196 | 179 | -17 | 17 | 289 | |
| 204 | 189 | -15 | 15 | 225 | |
| 219 | 198 | -21 | 21 | 441 | |
| 227 | 211 | -16 | 16 | 256 | |
| MAD | 12.5 | MSE | 191.9 |
Sheet1
| year | factory orders | 5MA | error | |error| | 5WMA | error | |error| |
| 1 | 2512.7 | ||||||
| 2 | 2739.2 | ||||||
| 3 | 2874.9 | ||||||
| 4 | 2934.1 | ||||||
| 5 | 2865.7 | ||||||
| 6 | 2978.5 | 2785.32 | -193.18 | 193.18 | 2852.3071428571 | -126.1928571429 | 126.193 |
| 7 | 3092.4 | 2878.48 | -213.92 | 213.92 | 2915.4357142857 | -176.9642857143 | 176.964 |
| 8 | 3052.6 | 2949.12 | -103.48 | 103.48 | 3000.6285714286 | -51.9714285714 | 51.971 |
| 9 | 3145.2 | 2984.66 | -160.54 | 160.54 | 3031.5714285714 | -113.6285714286 | 113.629 |
| 10 | 3114.1 | 3026.88 | -87.22 | 87.22 | 3079.3285714286 | -34.7714285714 | 34.771 |
| 11 | 3257.4 | 3076.56 | -180.84 | 180.84 | 3102.9642857143 | -154.4357142857 | 154.436 |
| 12 | 3654 | 3132.34 | -521.66 | 521.66 | 3174.0142857143 | -479.9857142857 | 479.986 |
| 13 | 3244.66 | 3384.2571428571 | |||||
| MAD | 208.6914285714 | MAD | 162.564 |
Unit 6 Assignment.html
Assignment Details
This assignment has two parts. Part 1 has questions about forecasting. You will submit your answers for the first part using the Unit 6 Assignment template for Part 1.
Part 2 requires you to analyze a case. For this, you will prepare a PowerPoint presentation to present your findings.
The data you need for Part 2 is provided in an Excel file in the course. Make sure to use that file. Do not type anything manually from the case or use other sources for the data.
View the assignment rubric for full assignment details.
Get help from top-rated tutors in any subject.
Efficiently complete your homework and academic assignments by getting help from the experts at homeworkarchive.com