The following table gives a football team€™s season-ticket sales, percentage of games won, and number of active alumni for the years 2001€“2015.

a. Produce a correlation matrix for the variables. Interpret the correlation between each pair of variables. Use some software to help produce the correlation matrix.

b. Estimate a regression model for sales = Percentage of games won. Interpret the results.

c. Estimate a regression model for sales = Number of active alumni. Interpret the results.

d. Conduct a multiple regression to explain ticket sales as a key marketing metric. Interpret the results.

e. Conduct a multiple regression model to predict ticket sales in 2016 presuming that a simple 3-year moving average is used to forecast winning percentage and number of alumni.

Transcribed Image Text:

Percent Won Active Alumni Sales Year 1 Year Sales Percent Won 0.798 1.000 1.000 0.236 0.135 Active Alumni 0.865 0.099 0.959