Year | Bonus($000) |
2000 | 100.5 |
2001 | 74.1 |
2002 | 60.9 |
2003 | 99.9 |
2004 | 113.5 |
2005 | 149.8 |
2006 | 191.4 |
2007 | 177.8 |
2008 | 100.9 |
2009 | 140.6 |
2010 | 139 |
2011 | 111.4 |
2012 | 142.9 |
2013 | 169.9 |
2014 | 172.9 |
Bonuses (Use data in Data folder on Blackboard) There has been much publicity about bonuses paid to workers on Wall Street. Just how large are these bonuses? The file Bonuses contains the bonuses paid (in $000) from 2010 to 2014. Hint: Use Coded Year as your independent variable (X), where X is relative to 2000. So, 2000 = 0, 2001 = 1, ..., 2010 = 10, 2013 = 13, etc. = = a. Plot the data. b. Compute a linear trend forecasting equation and plot the results. C. Compute a quadratic trend forecasting equation and plot the results. d. Compute an exponential trend forecasting equation using base 10 logs and plot the results. e. Using the forecasting equations in b through d, what are your annual forecasts of the bonuses for 2015 and 2016? You should have a total of six forecasts here. f. What forecast do you think you should use? Why? g. Plot your actual and predicted bonuses (on the same graph) using your model selected in part f above. This requires that you have the predicted bonuses for each year. Bonuses (Use data in Data folder on Blackboard) There has been much publicity about bonuses paid to workers on Wall Street. Just how large are these bonuses? The file Bonuses contains the bonuses paid (in $000) from 2010 to 2014. Hint: Use Coded Year as your independent variable (X), where X is relative to 2000. So, 2000 = 0, 2001 = 1, ..., 2010 = 10, 2013 = 13, etc. = = a. Plot the data. b. Compute a linear trend forecasting equation and plot the results. C. Compute a quadratic trend forecasting equation and plot the results. d. Compute an exponential trend forecasting equation using base 10 logs and plot the results. e. Using the forecasting equations in b through d, what are your annual forecasts of the bonuses for 2015 and 2016? You should have a total of six forecasts here. f. What forecast do you think you should use? Why? g. Plot your actual and predicted bonuses (on the same graph) using your model selected in part f above. This requires that you have the predicted bonuses for each year