ECO FORECASTING

profileMaryTemi
variables.xlsx
Home>Business & Finance homework help>Economics homework help>ECO FORECASTING

Sheet1

1972 01 158.7443
1972 02 162·8406
1972 03 165·2191
1972 04 166·2669
1972 05 168.0168
1972 06 166·4096
1972 07 165.9741
1972 08 165·7474
1972 09 166.178
1972 10 165·7365
1972 11 164·7750
1972 12 163·1879
1973 01 160.3667
1973 02 164·1606
1973 03 162.162
1973 04 162·4721
1973 05 161·9365
1973 06 161.0542
1973 07 161.1462
1973 08 160·3289
1973 09 158.5761
1973 10 161·2958
1973 11 160·2187
1973 12 158.5315
1974 01 156.2785
1974 02 159.8709
1974 03 156·8749
1974 04 156·6694
1974 05 155·8879
1974 06 153·6400
1974 07 153.6171
1974 08 152.186
1974 09 149·9181
1974 10 150·7093
1974 11 149.978
1974 12 149.2543
1975 01 147.9968
1975 02 150.3171
1975 03 148.6766
1975 04 148.0239
1975 05 146.6621
1975 06 147.3516999999
1975 07 145·8805
1975 08 144·3865
1975 09 144·9174
1975 10 145·6905
1975 11 144.8879
1975 12 144.4735
1976 01 144·0893
1976 02 144.0734
1976 03 144·0848
1976 04 141.413
1976 05 142.2269
1976 06 141·6784
1976 07 4142·2427
1976 08 141·9319
1976 09 142.5936
1976 10 141·1014
1976 11 141.3372
1976 12 140.9838
1977 01 137.3857
1977 02 142·3259
1977 03 141.46
1977 04 142.4052
1977 05 141.1786
1977 06 141.581
1977 07 141.5752
1977 08 144·9426
1977 09 147·8194
1977 10 149.4415
1977 11 149.5223
1977 12 147.9216
1978 01 145.6607
1978 02 145·9635
1978 03 151·6977
1978 04 153·2382
1978 05 153.3617
1978 06 153.4451
1978 07 152.0998
1978 08 152.0915
1978 09 152·8306
1978 10 153·1397
1978 11 151·7318
1978 12 150.3508
1979 01 147.0354
1979 02 148.0603
1979 03 149·2714
1979 04 148·4123
1979 05 149·2501
1979 06 146·4007
1979 07 144·9715
1979 08 148.1553
1979 09 147·7219
1979 10 149·3628
1979 11 151·5929
1979 12 149·1646
1980 01 150·0691
1980 02 150.5629
1980 03 150.4206
1980 04 150·1000
1980 05 149·3044
1980 06 147·8611
1980 07 147.7561
1980 08 145.357
1980 09 148.9901
1980 10 147.4873
1980 11 146.8522
1980 12 148·7383
1981 01 147.5423
1981 02 148·6522
1981 03 148.8157
1981 04 147·8094
1981 05 146.7972
1981 06 148.9034
1981 07 146·6517
1981 08 148.1393
1981 09 148·4973
1981 10 147.7784
1981 11 148·1054
1981 12 148·0803
1982 01 146.4898
1982 02 149.9224
1982 03 149·3795
1982 04 147·9897
1982 05 149·5943
1982 06 149.0208
1982 07 149·0753
1982 08 148.6548
1982 09 149·8404
1982 10 149·8327
1982 11 149·8673
1982 12 148.0985
1983 01 149.7214
1983 02 150·8442
1983 03 149.8064
1983 04 151·1060
1983 05 148·6313
1983 06 149·2256
1983 07 148.6437
1983 08 149.3528
1983 09 151·1556
1983 10 150·9105
1983 11 150.946
1983 12 144.3528
1984 01 152.6574
1984 02 152·6873
1984 03 149·3471
1984 04 152.3901
1984 05 153.9922
1984 06 152.2304
1984 07 152·7714
1984 08 151·5506
1984 09 154·5783
1984 10 153.1063
1984 11 154·3619
1984 12 152.9655
1985 01 150·2606
1985 02 155·1738
1985 03 156·2941
1985 04 155.5855
1985 05 156.943
1985 06 155.0865
1985 07 153.7954
1985 08 151·4800
1985 09 153.9995
1985 10 154·2954
1985 11 153·2238
1985 12 155.259
1986 01 179.3726
1986 02 180.1333
1986 03 177.0527
1986 04 174.0273
1986 05 173.819
1986 06 169.8291
1986 07 170·2961
1986 08 164·7543
1986 09 163.7461
1986 10 165.9276
1986 11 165.6103
1986 12 164·2555
1987 01 167·1209
1987 02 165·1146
1987 03 166.6979
1987 04 167·3469
1987 05 164·1641
1987 06 163·0407
1987 07 162.5114
1987 08 161·6864
1987 09 161·6198
1987 10 164·7081
1987 11 165·3250
1987 12 163·7629
1988 01 162·4350
1988 02 164.8889
1988 03 164.885
1988 04 163·2004
1988 05 162·0441
1988 06 160·8931
1988 07 158.3332
1988 08 159.1189
1988 09 155·5071
1988 10 158.0125
1988 11 158·0219
1988 12 156·4093
1989 01 156.3196
1989 02 153·3893
1989 03 149·1765
1989 04 153·0495
1989 05 153.9275
1989 06 150.148
1989 07 146·5969
1989 08 148·5712
1989 09 148·6387
1989 10 146·7653
1989 11 148·4061
1989 12 144.4817
1990 01 148.6052
1990 02 147.6428
1990 03 146·3855
1990 04 145·8703
1990 05 144.319
1990 06 139.9352
1990 07 141·2651
1990 08 143·4982
1990 09 142·2618
1990 10 148·5282
1990 11 145·4675
1990 12 144.5034
1991 01 147·7005
1991 02 150·3994
1991 03 148·6072
1991 04 147·8674
1991 05 145.9014
1991 06 144·1607
1991 07 144.6849
1991 08 144·0780
1991 09 145·0917
1991 10 146·4642
1991 11 144·3066
1991 12 143·7386
1992 01 144.9528
1992 02 145·5044
1992 03 144·7117
1992 04 143·6124
1992 05 141·1728
1992 06 141·1471
1992 07 140.4342
1992 08 136·3120
1992 09 138.4459
1992 10 140.329
1992 11 138·3279
1992 12 139·8856
1993 01 137·0847
1993 02 136·7226
1993 03 137.3434
1993 04 135.5157
1993 05 134.8389
1993 06 133·8117
1993 07 131·7173
1993 08 133.0835
1993 09 132.1737
1993 10 134·6773
1993 11 136·1108
1993 12 135.046
1994 01 134·2427
1994 02 133·3290
1994 03 132.8426
1994 04 130.2139
1994 05 131·7114
1994 06 130.1844
1994 07 128.0231
1994 08 128·8762
1994 09 130·1494
1994 10 131·1168
1994 11 130·5344
1994 12 133·1195
1995 01 131·5950
1995 02 133.8072
1995 03 129.9855
1995 04 130.0504
1995 05 130.5553
1995 06 129·5575
1995 07 127.0008
1995 08 126·9579
1995 09 126.3584
1995 10 126·4516
1995 11 129.6891
1995 12 128·5979
1996 01 127.9162
1996 02 129·5214
1996 03 129·4166
1996 04 126·9084
1996 05 125.9212
1996 06 127.1856
1996 07 124.8198
1996 08 125.2585
1996 09 127.6557
1996 10 127·6375
1996 11 127.532
1996 12 128·1314
1997 01 126·0857
1997 02 128·2953
1997 03 127.0698
1997 04 126.8585
1997 05 127·5078
1997 06 126·8674
1997 07 126.2306
1997 08 125·0100
1997 09 127·7375
1997 10 127.3706
1997 11 127·2159
1997 12 128·6310
1998 01 128.8179
1998 02 127·5429
1998 03 126·2028
1998 04 127.6823
1998 05 125.006
1998 06 123.4383
1998 07 122.0001
1998 08 122·1640
1998 09 114·0106
1998 10 120·9755
1998 11 120·9233
1998 12 119·0234
1999 01 117.4405
1999 02 117.4929
1999 03 115.8502
1999 04 115.9591
1999 05 115.7104
1999 06 113·4735
1999 07 114·2129
1999 08 113.8599
1999 09 114.3337
1999 10 117.1399
1999 11 117·4087
1999 12 117.3682
2000 01 113·9321
2000 02 115·2632
2000 03 116·5791 129.9855
2000 04 115.3144 129·5575
2000 05 115.1705 126.3584
2000 06 114.7095 128·5979
2000 07 113·0623 129·4166
2000 08 114·0381 127.1856
2000 09 113.427 127.6557
2000 10 114·4357 128·1314
2000 11 114·9013 127.0698
2000 12 115.3433 126·8674
2001 01 114·2369 127·7375
2001 02 113·8665 128·6310
2001 03 115·8387 126·2028
2001 04 115.4896 123.4383
2001 05 114·8312 114·0106
2001 06 113·5779 119·0234
2001 07 113.2403 115.8502
2001 08 112.7838 113·4735
2001 09 112·4551 114.3337
2001 10 113.1854 117.3682
2001 11 115.8539 116·5791
2001 12 115·9758 114.7095
2002 01 115.6986 113.427
2002 02 115.8462 115.3433
2002 03 115.9421 115·8387
2002 04 115.1269 113·5779
2002 05 116·3212 112·4551
2002 06 115.9143 115·9758
2002 07 113·2844 115.9421
2002 08 114·1707 115.9143
2002 09 106·5915 106·5915
2002 10 105·5464 112.71
2002 11 110.7756 114.2311
2002 12 112.71 111·3930
2003 01 113·2423 110·3883
2003 02 113·7797 109.6275
2003 03 114.2311 110·4990
2003 04 112.6964 106·3846
2003 05 111.4821 699.9901
2003 06 111·3930 108.4261
2003 07 108·2205 110.2382
2003 08 109.6957 107.674
2003 09 110·3883 183·1037
2003 10 110.4747 898·1872
2003 11 109·1446 399.0316
2003 12 109.6275 101.626
2004 01 109·8755 999.0671
2004 02 109.7014 102.1697
2004 03 110·4990 100.5181
2004 04 109.4122 399·9231
2004 05 109.3073 696.5547
2004 06 106·3846 100.651
2004 07 107·9235 102·2550
2004 08 104·7824 101.1351
2004 09 699.9901 378.3328
2004 10 101.745 100.6608
2004 11 106.707 102·7617
2004 12 108.4261 103·9622
2005 01 107.2923 109.5776
2005 02 108.3525 107·3879
2005 03 110.2382 108.6306
2005 04 109.5702 106·0780
2005 05 108·4478 110.5046
2005 06 107.674 110·6229
2005 07 103.406 110·5155
2005 08 102.8145 110.1665
2005 09 183·1037 110·3639
2005 10 389·7490 119·0100
2005 11 495.6144 124.4802
2005 12 898·1872 122.6986
2006 01 100·1933 129·0423
2006 02 499·1271 139.3937
2006 03 399.0316 141.2174
2006 04 100.0654 142.6543
2006 05 101·4384
2006 06 101.626
2006 07 100·3050
2006 08 199.2346
2006 09 999.0671
2006 10 100.5921
2006 11 399·7548
2006 12 102.1697
2007 01 100·5598
2007 02 101.026
2007 03 100.5181
2007 04 101·9347
2007 05 102.5324
2007 06 399·9231
2007 07 199·2265
2007 08 98.1938
2007 09 696.5547
2007 10 799.5633
2007 11 899·3165
2007 12 100.651
2008 01 100.6553
2008 02 101.5518
2008 03 102·2550
2008 04 101·5144
2008 05 101·3634
2008 06 101.1351
2008 07 102·0584
2008 08 698·6363
2008 09 378.3328
2008 10 493·3062
2008 11 100·1702
2008 12 100.6608
2009 01 101·2635
2009 02 103.2396
2009 03 102·7617
2009 04 104.1218
2009 05 106.051
2009 06 103·9622
2009 07 106·4049
2009 08 105.9027
2009 09 109.5776
2009 10 108·7229
2009 11 106.1331
2009 12 107·3879
2010 01 106·3811
2010 02 109.2884
2010 03 108.6306
2010 04 105.9579
2010 05 106.3669
2010 06 106·0780
2010 07 104.6905
2010 08 107.2767
2010 09 110.5046
2010 10 110.2677
2010 11 109.5186
2010 12 110·6229
2011 01 108·4349
2011 02 106·3567
2011 03 110·5155
2011 04 109.5454
2011 05 110·8943
2011 06 110.1665
2011 07 106·7416
2011 08 111.4188
2011 09 110·3639
2011 10 116.1695
2011 11 118·5566
2011 12 119·0100
2012 01 120·9395
2012 02 122.5868
2012 03 124.4802
2012 04 123.7064
2012 05 124.1697
2012 06 122.6986
2012 07 125·7920
2012 08 124.1225
2012 09 129·0423
2012 10 136·4889
2012 11 138.9199
2012 12 139.3937
2013 01 138.5229
2013 02 140.2559
2013 03 141.2174
2013 04 144·5181
2013 05 143·7289
2013 06 142.6543
2013 07 147·9645
2013 08 147.7475
2013 09 153·4540
2013 10 152·9212

Sheet4

Anova: Single Factor
SUMMARY
Groups Count Sum Average Variance
Column 1 15 79928.0999 5328.5399933333 1105973.22986101
Column 2 15 413293 27552.8666666667 20078634.6952381
ANOVA
Source of Variation SS df MS F P-value F crit
Between Groups 3704405220.62277 1 3704405220.62277 349.7261062107 2.34310189399229E-17 4.1959718186
Within Groups 296584510.951387 28 10592303.9625496
Total 4000989731.57415 29

Sheet2

Date CostCo Revenue Walmart Revenue Exports IPIC
3/31/1995 4307.3218 20440 64349 129.9855 4307.3218
6/30/1995 3896.238 22723 64855 129.5575 3896.238
9/29/1995 6013.8032 22913 68943 126.3584 6013.8032
12/29/1995 4383.564 27551 69071 128.5979 4383.564
3/29/1996 4688.6948 22772 69797 129.4166
6/28/1996 4311.4878 25587 71056 127.1856
9/30/1996 6182.709 25644 70553 127.6557
12/31/1996 4883.4082 30856 72842 128.1314
3/31/1997 5238.8931 25409 77050 127.0698
6/30/1997 4836.229 28386 78889 126.8674
9/30/1997 6915.874 28777 79287 127.7375
12/31/1997 5429.7632 35386 79038 128.631
3/31/1998 5795.0059 29819 78812 126.2028
6/30/1998 5338.0859 33521 76961 123.4383
9/30/1998 7707.022 33509 77179 114.0106
12/31/1998 5998.0781 40785 78382 119.0234
3/31/1999 6592.3579 34717 78243 115.8502
6/30/1999 6053.8198 38470 79070 113.4735
9/30/1999 8811.775 40432 82718 114.3337
12/31/1999 6943.5122 51394 84983 117.3682
3/31/2000 7736.9868 42985 87277 116.5791
6/30/2000 6894.6079 46112 90549 114.7095
9/29/2000 10589.189 45676 91981 113.427
12/29/2000 7637.2778 56556 90260 115.3433
3/30/2001 8306.3086 48052 88714 115.8387
6/29/2001 7718.895 52799 85265 113.5779
9/28/2001 11134.5498 52738 77286 112.4551
12/31/2001 8466.5527 64210 78180 115.9758
3/29/2002 9382.8516 52126 79613 115.9421
6/28/2002 8616.7471 56271 82705 115.9143
9/30/2002 12296.347 55241 82893 106.5915
12/31/2002 9198.585 66400 81686 112.71
3/31/2003 10114.1699 56718 82944 114.2311
6/30/2003 9543.0713 62637 84810 111.393
9/30/2003 13689.7305 62480 86399 110.3883
12/31/2003 10521.4805 74494 90699 109.6275
3/31/2004 11548.9697 64763 96472 110.499
6/30/2004 10897.2402 69722 94993 106.3846
9/30/2004 15139.302 68520 98543 699.9901
12/31/2004 11578 82217 102571 108.4261
3/31/2005 12658.077 71680 104752 110.2382
6/30/2005 11996.9 76697 106652 107.674
9/30/2005 16709.936 75397 107166 183.1037
12/30/2005 12933.346 88418 113482 898.1872
3/31/2006 14054.576 79676 118875 399.0316
6/30/2006 13273.175 85430 122446 101.626
9/29/2006 19875.221 84467 123774 999.0671
12/29/2006 14151.624 99078 128544 102.1697
3/30/2007 15112.016 86410 132823 100.5181
6/29/2007 14659.255 92999 136453 399.9231
9/28/2007 20477.26 91865 141627 696.5547
12/31/2007 15809.53 20477.26 147152 100.651
3/31/2008 16959.886 17209.849 151927 102.255
6/30/2008 16613.717 17034.8749 163317 101.1351
9/30/2008 23099.887 16740.06437 153641 378.3328
12/31/2008 16395 21191.940211 132012 100.6608
3/31/2009 16843 17834.0820633 125990 102.7617
6/30/2009 15806 17140.32461899 128456 103.9622
9/30/2009 22378 16206.297385697 135643 109.5776
12/31/2009 17299 20526.4892157091 144001 107.3879
3/31/2010 18742 18267.2467647127 148646 108.6306
6/30/2010 17780 18599.5740294138 151418 106.078
9/30/2010 24125 18025.8722088241 156049 110.5046
12/31/2010 19239 22295.2616626472 166177 110.6229
3/31/2011 20875 20155.8784987942 174342 110.5155
6/30/2011 20623 20659.2635496382 173180 110
9/30/2011 28178 20633.8790648915 181172 110.3639
12/30/2011 21628 25914.7637194674 179118 119.01
3/30/2012 22967 22914.0291158402 186505 124.4802
6/29/2012 22324 22951.1087347521 185218 122.6986
9/28/2012 32218 22512.1326204256 186829 129.0423
12/31/2012 23715 29306.2397861277 188686 139.3937
3/29/2013 24871 25392.3719358383 184578 141.2174
6/28/2013 24083 25027.4115807515 190528 142.6543