Forbes magazine ranks NFL teams by value each year. The following data are the value of the Indianapolis Colts from 1998 to 2008 (Forbes website).

a. Construct a time series plot. What type of pattern exists in the data?

b. Using Minitab or Excel, develop the quadratic trend equation that can be used to forecast the team’s value.

c. Using Minitab or Excel, develop the exponential trend equation that can be used to forecast the team’s value.

d. Using Minitab or Excel, develop the linear trend equation that can be used to forecast the team’s value.

e. Which equation would you recommend using to estimate the team’s value in 2009?

f. Use the model you recommended in part

(e) to forecast the value of the Colts in 2009.