The graduate assistant for the Santa Clara Broncos football team has compiled the following statistics:

YEAR WINS AVERAGE OFFENSIVE YARDS AVERAGE INTERCEPTIONS

1 10 500 2

2 8 450 4

3 5 250 10

4 10 485 1

5 7 399 4

6 11 521 2

7 4 158 15

8 11 525 0

9 8 485 4

10 4 300 9

1 1 5 350 9

12 7 375 9

13 2 150 15

14 5 380 5

a. Using Excel, develop a linear regression model for wins, employing average offensive yards and average interceptions.

b. Calculate the MAD for your model.

c. Calculate R, F, and t statistics and interpret them.

d. Run tests for multicollinearity, autocorrrelation, and heteroscedasticity. Comment on the outcomes