Question: 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

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.

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!