Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Numerical Algebra Matrix Theory Differential Algebraic Equations And Control Theory

Authors: Peter Benner, Matthias Bollhöfer, Daniel Kressner, Christian Mehl, Tatjana Stykel

1st Edition

3319152602, 9783319152608

More Books

Students also viewed these Mathematics questions

Question

1. Where do they go or look to buy the product or service?

Answered: 1 week ago

Question

Explain the process of Human Resource Planning.

Answered: 1 week ago