Eco 309 economic forecasting

profileAlexxcmartinez
MacroeconomicData.xlsx

Sheet1

Date Price Index Employment percentage GDP in Billion$ Company Revenue
3/31/00 1.0592 74.3 10278.340
6/30/00 0.7958 73.9 10357.445
9/30/00 0.5392 74.0 10472.285
12/31/00 0.9577 73.9 10508.121
3/31/01 1.0434 73.4 10638.384
6/30/01 0.1314 72.8 10639.486
9/30/01 -0.2813 72.3 10701.317
12/31/01 0.3573 72.2 10834.445
3/31/02 1.0868 71.9 10934.752
6/30/02 0.4263 71.9 11037.057
9/30/02 0.3138 71.7 11103.834
12/31/02 1.0120 71.5 11230.078
3/31/03 0.3643 71.3 11370.653
6/30/03 0.4900 71.0 11625.137
9/30/03 0.0181 71.1 11816.827
12/31/03 0.9029 71.2 11988.403
3/31/04 1.4316 71.1 12181.398
6/30/04 0.3529 71.2 12367.744
9/30/04 0.5977 71.3 12562.163
12/31/04 0.6292 71.3 12813.729
3/31/05 1.3373 71.5 12974.083
6/30/05 1.2168 71.7 13205.445
9/30/05 0.5080 71.6 13381.629
12/31/05 0.5391 71.8 13648.904
3/31/06 1.6924 71.9 13799.794
6/30/06 0.5602 72.1 13908.498
9/30/06 -0.8520 72.2 14066.370
12/31/06 1.0192 72.0 14233.226
3/31/07 1.9173 71.7 14422.313
6/30/07 0.2759 71.7 14569.675
9/30/07 0.7112 71.6 14685.330
12/31/07 1.1368 71.5 14668.445
3/31/08 2.1953 71.2 14812.974
6/30/08 1.1631 70.7 14842.983
9/30/08 -2.8285 70.0 14549.949
12/31/08 -0.4976 68.7 14383.885
3/31/09 1.0603 67.9 14340.417
6/30/09 0.6791 67.3 14384.145
9/30/09 0.2012 66.6 14566.511
12/31/09 0.4014 66.8 14681.063
3/31/10 0.4751 66.8 14888.600
6/30/10 0.0933 66.7 15057.660
9/30/10 0.2949 66.5 15230.208
12/31/10 1.2648 66.7 15238.371
3/31/11 1.7433 66.5 15460.926
6/30/11 0.4085 66.6 15587.125
9/30/11 -0.1521 66.8 15785.312
12/31/11 0.7956 67.0 15973.881
3/31/12 0.8275 67.0 16121.851
6/30/12 0.2193 67.1 16227.939
9/30/12 0.0360 67.4 16297.349
12/31/12 0.5903 67.2 16475.440
3/31/13 0.5410 67.3 16541.390
6/30/13 0.3780 67.5 16749.349
9/30/13 -0.2791 67.4 16999.888
12/31/13 0.7612 67.8 17031.324
3/31/14 1.1809 68.0 17320.921
6/30/14 0.1147 68.2 17622.257
9/30/14 -0.8034 68.5 17735.933
12/31/14 -0.5432 68.5 17874.715
3/31/15 1.2000 68.7 18093.224
6/30/15 0.3000 68.7 18227.689
9/30/15 -0.4000 68.9 18287.226
12/31/15 0.1000 69.3 18325.187
3/31/16 1.2000 69.2 18538.039
6/30/16 0.3000 69.3 18729.130
9/30/16 0.2000 69.5 18905.545
12/31/16 0.8000 69.8 19057.705

Copy and paste your company revenue data from the company revenue file to this column. Pay attention to the date. You need to copy the data starting from 3/31/2000 until 12/31/2016. Then you can copy and paste all data together to Minitab for analysis.