| Year | X1 | X2 | X3 | X4 | X5 | Y | | Questions |
| 1996 | 2.850 | 7.639 | 2.000 | 5.521 | 5.642 | 5.536 | | 1. Run Correlation analysis and identify the inputs (Xs) highly correlated with the output (Y) |
| 1997 | 2.934 | 7.698 | 3.000 | 5.536 | 5.687 | 5.511 | | Remember: Any correlation coefficient +/- 0.7 or above indicates high correlation. (there should be 3 inputs highly correlated with the output Y) |
| 1998 | 3.011 | 7.685 | 4.000 | 5.511 | 5.671 | 5.465 | | 2. Run Multiple Regression Analysis with the inputs (Xs) you identified in Question 1 and calculate the estimated values of Y for the years 2020, 2021 and 2022 |
| 1999 | 2.918 | 7.694 | 5.000 | 5.465 | 5.673 | 5.467 |
| 2000 | 2.962 | 7.734 | 6.000 | 5.467 | 5.691 | 5.465 |
| 2001 | 2.890 | 7.770 | 7.000 | 5.465 | 5.628 | 5.452 |
| 2002 | 2.888 | 7.814 | 8.000 | 5.452 | 5.708 | 5.438 |
| 2003 | 2.910 | 7.821 | 9.000 | 5.438 | 5.738 | 5.431 |
| 2004 | 2.854 | 7.804 | 10.000 | 5.431 | 5.641 | 5.409 |
| 2005 | 2.820 | 7.813 | 11.000 | 5.409 | 5.633 | 5.386 |
| 2006 | 2.754 | 7.822 | 12.000 | 5.386 | 5.713 | 5.359 |
| 2007 | 2.721 | 7.862 | 13.000 | 5.359 | 5.711 | 5.358 |
| 2008 | 2.663 | 7.930 | 14.000 | 5.358 | 5.849 | 5.367 |
| 2009 | 2.599 | 7.962 | 15.000 | 5.367 | 5.831 | 5.385 |
| 2010 | 2.559 | 7.999 | 16.000 | 5.385 | 5.819 | 5.388 |
| 2011 | 2.547 | 8.021 | 17.000 | 5.388 | 5.896 | 5.394 |
| 2012 | 2.485 | 8.062 | 18.000 | 5.394 | 5.802 | 5.403 |
| 2013 | 2.512 | 8.083 | 19.000 | 5.403 | 5.772 | 5.409 |
| 2014 | 2.526 | 8.097 | 20.000 | 5.409 | 5.771 | 5.401 |
| 2015 | 2.340 | 8.097 | 21.000 | 5.401 | 5.754 | 5.398 |
| 2016 | 2.396 | 8.128 | 22.000 | 5.398 | 5.841 | 5.378 |
| 2017 | 2.336 | 8.136 | 23.000 | 5.378 | 5.902 | 5.368 |
| 2018 | 2.338 | 8.156 | 24.000 | 5.368 | 5.940 | 5.349 |
| 2019 | 2.269 | 8.177 | 25.000 | 5.349 | 5.938 | 5.368 |
| 2020 | 2.374 | 8.194 | 26.000 | 5.368 | 5.910 |
| 2021 | 2.250 | 8.223 | 27.000 | 5.366 | 5.919 |
| 2022 | 2.337 | 8.257 | 28.000 | 5.355 | 5.950 |