Linear Regression

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

11 5 350 9

12 7 375 9

13 2 150 15

14 5 380 5

Using the date provided, develop the projection for wins of the 15 year using the following models:  1. Linear regression  2. Moving Average using a N= 4, and N=6  3. Weight Moving Average with (45%, 30%, 25%)  4. Exponential Smoothing with alpha =20%  Calculate the MAD for each model and determine which model is more aligned with the trend of the values.  Calculate R and F for the Linear regression and make your interpretation.

Calculate R and F and T statistics and interpret them.

Run test for multicollinearity, autocorrelation, and Heteroscedasticity. Comment on the outcomes.