Loans and leases data for the years 2005 through 2015 for Glen Lake Bank are shown below:

Year Loans & Leases ($ millions)

2005 511 2006 616 2007 718 2008 909 2009 1,135 2010 1,371 2011 1,677 2012 1,871 2013 2,021 2014 1,904 2015 2,354

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 2005 through 2015, what is the predicted value each year for loans and leases based on 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 Glen Lake Bank for 2016 and 2017.