Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the StatTools Deseasonalize option and then forecast the deseasonalized data for each month of the next year using a moving average method with a
Use the StatTools Deseasonalize option and then forecast the deseasonalized data for each month of the next year using a moving average method with a span of 3. (Round your answers to one decimal place.)
Jul-2015 | |
Aug-2015 | |
Sep-2015 | |
Oct-2015 | |
Nov-2015 | |
Dec-2015 | |
Jan-2016 | |
Feb-2016 | |
Mar-2016 | |
Apr-2016 | |
May-2016 | |
Jun-2016 |
Month | Total Sales |
Jan-1992 | 1519 |
Feb-1992 | 1551 |
Mar-1992 | 1606 |
Apr-1992 | 1686 |
May-1992 | 1834 |
Jun-1992 | 1786 |
Jul-1992 | 1924 |
Aug-1992 | 1874 |
Sep-1992 | 1781 |
Oct-1992 | 1894 |
Nov-1992 | 1843 |
Dec-1992 | 2527 |
Jan-1993 | 1623 |
Feb-1993 | 1539 |
Mar-1993 | 1688 |
Apr-1993 | 1725 |
May-1993 | 1807 |
Jun-1993 | 1804 |
Jul-1993 | 1962 |
Aug-1993 | 1788 |
Sep-1993 | 1717 |
Oct-1993 | 1769 |
Nov-1993 | 1794 |
Dec-1993 | 2459 |
Jan-1994 | 1557 |
Feb-1994 | 1514 |
Mar-1994 | 1724 |
Apr-1994 | 1769 |
May-1994 | 1842 |
Jun-1994 | 1869 |
Jul-1994 | 1994 |
Aug-1994 | 1870 |
Sep-1994 | 1834 |
Oct-1994 | 1817 |
Nov-1994 | 1857 |
Dec-1994 | 2593 |
Jan-1995 | 1565 |
Feb-1995 | 1510 |
Mar-1995 | 1736 |
Apr-1995 | 1709 |
May-1995 | 1818 |
Jun-1995 | 1873 |
Jul-1995 | 1898 |
Aug-1995 | 1872 |
Sep-1995 | 1856 |
Oct-1995 | 1800 |
Nov-1995 | 1892 |
Dec-1995 | 2616 |
Jan-1996 | 1690 |
Feb-1996 | 1662 |
Mar-1996 | 1849 |
Apr-1996 | 1810 |
May-1996 | 1970 |
Jun-1996 | 1971 |
Jul-1996 | 2047 |
Aug-1996 | 2075 |
Sep-1996 | 1791 |
Oct-1996 | 1870 |
Nov-1996 | 2003 |
Dec-1996 | 2562 |
Jan-1997 | 1716 |
Feb-1997 | 1629 |
Mar-1997 | 1862 |
Apr-1997 | 1826 |
May-1997 | 2071 |
Jun-1997 | 2012 |
Jul-1997 | 2109 |
Aug-1997 | 2092 |
Sep-1997 | 1904 |
Oct-1997 | 2063 |
Nov-1997 | 2096 |
Dec-1997 | 2842 |
Jan-1998 | 1859 |
Feb-1998 | 1780 |
Mar-1998 | 1906 |
Apr-1998 | 1976 |
May-1998 | 2153 |
Jun-1998 | 2072 |
Jul-1998 | 2222 |
Aug-1998 | 2130 |
Sep-1998 | 2041 |
Oct-1998 | 2174 |
Nov-1998 | 2166 |
Dec-1998 | 3054 |
Jan-1999 | 1877 |
Feb-1999 | 1818 |
Mar-1999 | 1998 |
Apr-1999 | 2111 |
May-1999 | 2224 |
Jun-1999 | 2159 |
Jul-1999 | 2353 |
Aug-1999 | 2153 |
Sep-1999 | 2139 |
Oct-1999 | 2232 |
Nov-1999 | 2287 |
Dec-1999 | 3284 |
Jan-2000 | 1931 |
Feb-2000 | 1987 |
Mar-2000 | 2203 |
Apr-2000 | 2144 |
May-2000 | 2371 |
Jun-2000 | 2427 |
Jul-2000 | 2477 |
Aug-2000 | 2435 |
Sep-2000 | 2371 |
Oct-2000 | 2365 |
Nov-2000 | 2562 |
Dec-2000 | 3395 |
Jan-2001 | 2121 |
Feb-2001 | 2063 |
Mar-2001 | 2340 |
Apr-2001 | 2244 |
May-2001 | 2484 |
Jun-2001 | 2540 |
Jul-2001 | 2496 |
Aug-2001 | 2532 |
Sep-2001 | 2329 |
Oct-2001 | 2423 |
Nov-2001 | 2652 |
Dec-2001 | 3559 |
Jan-2002 | 2125 |
Feb-2002 | 2121 |
Mar-2002 | 2379 |
Apr-2002 | 2312 |
May-2002 | 2583 |
Jun-2002 | 2500 |
Jul-2002 | 2582 |
Aug-2002 | 2610 |
Sep-2002 | 2310 |
Oct-2002 | 2415 |
Nov-2002 | 2617 |
Dec-2002 | 3507 |
Jan-2003 | 2134 |
Feb-2003 | 2059 |
Mar-2003 | 2289 |
Apr-2003 | 2348 |
May-2003 | 2593 |
Jun-2003 | 2450 |
Jul-2003 | 2629 |
Aug-2003 | 2678 |
Sep-2003 | 2478 |
Oct-2003 | 2659 |
Nov-2003 | 2678 |
Dec-2003 | 3681 |
Jan-2004 | 2308 |
Feb-2004 | 2232 |
Mar-2004 | 2411 |
Apr-2004 | 2567 |
May-2004 | 2702 |
Jun-2004 | 2660 |
Jul-2004 | 2886 |
Aug-2004 | 2641 |
Sep-2004 | 2639 |
Oct-2004 | 2753 |
Nov-2004 | 2792 |
Dec-2004 | 3843 |
Jan-2005 | 2241 |
Feb-2005 | 2337 |
Mar-2005 | 2553 |
Apr-2005 | 2663 |
May-2005 | 2734 |
Jun-2005 | 2808 |
Jul-2005 | 2951 |
Aug-2005 | 2819 |
Sep-2005 | 2813 |
Oct-2005 | 2832 |
Nov-2005 | 2968 |
Dec-2005 | 4186 |
Jan-2006 | 2462 |
Feb-2006 | 2560 |
Mar-2006 | 2799 |
Apr-2006 | 2840 |
May-2006 | 3072 |
Jun-2006 | 3112 |
Jul-2006 | 3176 |
Aug-2006 | 3082 |
Sep-2006 | 3059 |
Oct-2006 | 2965 |
Nov-2006 | 3192 |
Dec-2006 | 4354 |
Jan-2007 | 2610 |
Feb-2007 | 2641 |
Mar-2007 | 3049 |
Apr-2007 | 2911 |
May-2007 | 3312 |
Jun-2007 | 3422 |
Jul-2007 | 3383 |
Aug-2007 | 3357 |
Sep-2007 | 3123 |
Oct-2007 | 3158 |
Nov-2007 | 3374 |
Dec-2007 | 4508 |
Jan-2008 | 2767 |
Feb-2008 | 2910 |
Mar-2008 | 3106 |
Apr-2008 | 3126 |
May-2008 | 3574 |
Jun-2008 | 3438 |
Jul-2008 | 3691 |
Aug-2008 | 3647 |
Sep-2008 | 3303 |
Oct-2008 | 3516 |
Nov-2008 | 3548 |
Dec-2008 | 4660 |
Jan-2009 | 3036 |
Feb-2009 | 2897 |
Mar-2009 | 3140 |
Apr-2009 | 3256 |
May-2009 | 3606 |
Jun-2009 | 3437 |
Jul-2009 | 3692 |
Aug-2009 | 3524 |
Sep-2009 | 3376 |
Oct-2009 | 3536 |
Nov-2009 | 3455 |
Dec-2009 | 4720 |
Jan-2010 | 2879 |
Feb-2010 | 2917 |
Mar-2010 | 3215 |
Apr-2010 | 3311 |
May-2010 | 3468 |
Jun-2010 | 3440 |
Jul-2010 | 3661 |
Aug-2010 | 3459 |
Sep-2010 | 3372 |
Oct-2010 | 3505 |
Nov-2010 | 3535 |
Dec-2010 | 4698 |
Jan-2011 | 2896 |
Feb-2011 | 2993 |
Mar-2011 | 3258 |
Apr-2011 | 3371 |
May-2011 | 3479 |
Jun-2011 | 3558 |
Jul-2011 | 3748 |
Aug-2011 | 3582 |
Sep-2011 | 3522 |
Oct-2011 | 3519 |
Nov-2011 | 3650 |
Dec-2011 | 4897 |
Jan-2012 | 2995 |
Feb-2012 | 3202 |
Mar-2012 | 3551 |
Apr-2012 | 3411 |
May-2012 | 3789 |
Jun-2012 | 3823 |
Jul-2012 | 3745 |
Aug-2012 | 3768 |
Sep-2012 | 3525 |
Oct-2012 | 3654 |
Nov-2012 | 3905 |
Dec-2012 | 5181 |
Jan-2013 | 3211 |
Feb-2013 | 3292 |
Mar-2013 | 3700 |
Apr-2013 | 3543 |
May-2013 | 4067 |
Jun-2013 | 3912 |
Jul-2013 | 4113 |
Aug-2013 | 4184 |
Sep-2013 | 3740 |
Oct-2013 | 3901 |
Nov-2013 | 4149 |
Dec-2013 | 5371 |
Jan-2014 | 3452 |
Feb-2014 | 3428 |
Mar-2014 | 3758 |
Apr-2014 | 3775 |
May-2014 | 4272 |
Jun-2014 | 4098 |
Jul-2014 | 4249 |
Aug-2014 | 4293 |
Sep-2014 | 3925 |
Oct-2014 | 4159 |
Nov-2014 | 4188 |
Dec-2014 | 5610 |
Jan-2015 | 3578 |
Feb-2015 | 3519 |
Mar-2015 | 3882 |
Apr-2015 | 3867 |
May-2015 | 4371 |
Jun-2015 | 4239 |
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