The graduate assistant for the Santa Clara Broncos football team

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 in problem 12 of chapter 6, 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