Assignment:
Loans and leases data for the years 2000 through 2010 for the Bank of the Ozarks are shown below:
| Year |
Loans & Leases ($ million) |
| 2000 |
511 |
| 2001 |
616 |
| 2002 |
718 |
| 2003 |
909 |
| 2004 |
1135 |
| 2005 |
1371 |
| 2006 |
1677 |
| 2007 |
1871 |
| 2008 |
2021 |
| 2009 |
1904 |
| 2010 |
2354 |
a. Produce a time-series plot of these data.
b. Fit a linear trend line to these data.
c. Conduct a hypothesis test of the significance of the linear trend model developed in part b. Use a level of significance of 0.05.
d. For the years 2000 through 2010, what is the predicted value each year for loans and leases using the linear trend model estimated in part b.
e. Calculate the MAD for the linear trend forecasts developed in part d.
f. Use the linear trend model to forecast loans and leases for the Bank of the Ozarks for 2011 and 2012.
Provide complete and step by step solution for the question and show calculations and use formulas.