Eco 309 economic forecasting
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.