Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Find MAD, MSE, RMSE, and MAPE for the two ES forecasts. Make a summary table of the error metrics for task 1. Using the data
Find MAD, MSE, RMSE, and MAPE for the two ES forecasts. Make a summary table of the error metrics for task 1. Using the data below
=0.3 and 0.9
Month | Sales (A) | Forcast =0.3 | Forcast =0.9 |
Jan-12 | 1,592 | 1,592 | #N/A |
Feb-12 | 1,711 | 1,592 | 1592 |
Mar-12 | 1,810 | 1,711 | 1699 |
Apr-12 | 1,867 | 1,810 | 1799 |
May-12 | 1,779 | 1,867 | 1860 |
Jun-12 | 1,740 | 1,779 | 1787 |
Jul-12 | 1,826 | 1,740 | 1745 |
Aug-12 | 1,695 | 1,826 | 1818 |
Sep-12 | 1,681 | 1,695 | 1707 |
Oct-12 | 1,663 | 1,681 | 1684 |
Nov-12 | 1,825 | 1,663 | 1665 |
Dec-12 | 1,720 | 1,825 | 1809 |
Jan-13 | 1,761 | 1,720 | 1729 |
Feb-13 | 2,035 | 1,761 | 1758 |
Mar-13 | 2,142 | 2,035 | 2007 |
Apr-13 | 2,340 | 2,142 | 2129 |
May-13 | 2,280 | 2,340 | 2319 |
Jun-13 | 2,271 | 2,280 | 2284 |
Jul-13 | 2,154 | 2,271 | 2272 |
Aug-13 | 2,146 | 2,154 | 2166 |
Sep-13 | 2,085 | 2,146 | 2148 |
Oct-13 | 1,970 | 2,085 | 2091 |
Nov-13 | 1,936 | 1,970 | 1982 |
Dec-13 | 1,850 | 1,936 | 1941 |
Jan-14 | 2,000 | 1,850 | 1859 |
Feb-14 | 2,324 | 2,000 | 1986 |
Mar-14 | 2,510 | 2,324 | 2290 |
Apr-14 | 2,672 | 2,510 | 2488 |
May-14 | 2,780 | 2,672 | 2654 |
Jun-14 | 2,813 | 2,780 | 2767 |
Jul-14 | 2,716 | 2,813 | 2808 |
Aug-14 | 2,581 | 2,716 | 2725 |
Sep-14 | 2,476 | 2,581 | 2595 |
Oct-14 | 2,317 | 2,476 | 2488 |
Nov-14 | 2,324 | 2,317 | 2334 |
Dec-14 | 2,080 | 2,324 | 2325 |
Jan-15 | 2,202 | 2,080 | 2105 |
Feb-15 | 2,540 | 2,202 | 2192 |
Mar-15 | 2,867 | 2,540 | 2505 |
Apr-15 | 3,348 | 2,867 | 2831 |
May-15 | 3,550 | 3,348 | 3296 |
Jun-15 | 3,432 | 3,550 | 3525 |
Jul-15 | 3,400 | 3,432 | 3441 |
Aug-15 | 3,261 | 3,400 | 3404 |
Sep-15 | 3,209 | 3,261 | 3275 |
Oct-15 | 3,132 | 3,209 | 3216 |
Nov-15 | 3,027 | 3,132 | 3140 |
Dec-15 | 2,777 | 3,027 | 3038 |
Jan-16 | 2,821 | 2,777 | 2803 |
Feb-16 | 3,209 | 2,821 | 2819 |
Mar-16 | 3,553 | 3,209 | 3170 |
Apr-16 | 3,820 | 3,553 | 3515 |
May-16 | 4,133 | 3,820 | 3789 |
Jun-16 | 4,476 | 4,133 | 4099 |
Jul-16 | 4,436 | 4,476 | 4438 |
Aug-16 | 4,256 | 4,436 | 4436 |
Sep-16 | 4,067 | 4,256 | 4274 |
Oct-16 | 3,890 | 4,067 | 4088 |
Nov-16 | 3,816 | 3,890 | 3910 |
Dec-16 | 3,717 | 3,816 | 3825 |
Jan-17 | 3,717 | 3728 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started