The national football league NFL records a variety of perfor

The national football league (NFL) records a variety of performance data for individuals and teams. to investigate the importance of passing on the percentage of games won by a team, the following data shows the conference, average number of passing yards per attempt (Yds/Att), the number of interceptions thrown per attempt (Int/Att), and the percentage of games won (Win%) for a random sample of 16 NFL teams for teh 2011 season (NFL website, February 12, 2012).

     TEAM

Conf.

    YDS/ATT

    Int/Att

   Win%

Cardinals

NFC

6.5

.042

50.0

Flacons

NFC

7.1

.022

62.5

Panthers

NFC

7.4

.033

37.5

Bengals

AFC

6.2

.026

56.3

Lions

NFC

7.2

.024

62.5

Packers

NFC

8.9

.014

93.8

Texans

AFC

7.5

.019

62.5

Colts

AFC

5.6

.026

12.5

Jaguars

AFC

4.6

.032

31.3

Vikings

NFC

5.8

.033

18.8

Patriots

AFC

8.3

.020

81.3

Saints

NFC

8.1

.021

81.3

Raiders

AFC

7.6

.044

50.0

49ers

NFC

6.5

.011

81.3

Titans

AFC

6.7

.024

56.3

Redskins

NFC

6.4

.041

31.3

A.) Develope the estimated regression equation that could be used to predict the percentage of games won given the average number of passing yards per attempt.

B.) Develope the estimated regression equation that could be used to predict the percentage of games won given the number of interceptions thrown per attempt.

C.) Develope the estimated regression equation that could be used to predict the percentage of games won given the average number of passing yards per attempt and the number of interceptions thrown per attempt.

D.) The average number of passing yards per attempt for the Kansas City Cheifs was 6.2 and the number of interceptions thrown per attempt was .036. Use the estimated regression equation developed in part (c) to predict the percentage of games won by the kansas City Cheifs. (Note: For the 2011 season teh Kansas City Cheifs\' record was 7 wins and 9 losses.) Compare your predictions to the actual percentage of games won by the Kansas City Chiefs.

This is supposed to be done in Excel, and I have no clue how to do it... Please Help!! Thank you!

TEAM	Conf.	YDS/ATT	Int/Att	Win%
Cardinals	NFC	6.5	.042	50.0
Flacons	NFC	7.1	.022	62.5
Panthers	NFC	7.4	.033	37.5
Bengals	AFC	6.2	.026	56.3
Lions	NFC	7.2	.024	62.5
Packers	NFC	8.9	.014	93.8
Texans	AFC	7.5	.019	62.5
Colts	AFC	5.6	.026	12.5
Jaguars	AFC	4.6	.032	31.3
Vikings	NFC	5.8	.033	18.8
Patriots	AFC	8.3	.020	81.3
Saints	NFC	8.1	.021	81.3
Raiders	AFC	7.6	.044	50.0
49ers	NFC	6.5	.011	81.3
Titans	AFC	6.7	.024	56.3
Redskins	NFC	6.4	.041	31.3

Solution

TEAM Conf.     YDS/ATT     Int/Att    Win% YDS*Win YDS2 Int*Win Int2 YDS*Int Cardinals NFC 6.5 0.042 50 325 42.25 2.1 0.001764 0.273 Flacons NFC 7.1 0.022 62.5 443.75 50.41 1.375 0.000484 0.1562 Panthers NFC 7.4 0.033 37.5 277.5 54.76 1.2375 0.001089 0.2442 Bengals AFC 6.2 0.026 56.3 349.06 38.44 1.4638 0.000676 0.1612 Lions NFC 7.2 0.024 62.5 450 51.84 1.5 0.000576 0.1728 Packers NFC 8.9 0.014 93.8 834.82 79.21 1.3132 0.000196 0.1246 Texans AFC 7.5 0.019 62.5 468.75 56.25 1.1875 0.000361 0.1425 Colts AFC 5.6 0.026 12.5 70 31.36 0.325 0.000676 0.1456 Jaguars AFC 4.6 0.032 31.3 143.98 21.16 1.0016 0.001024 0.1472 Vikings NFC 5.8 0.033 18.8 109.04 33.64 0.6204 0.001089 0.1914 Patriots AFC 8.3 0.02 81.3 674.79 68.89 1.626 0.0004 0.166 Saints NFC 8.1 0.021 81.3 658.53 65.61 1.7073 0.000441 0.1701 Raiders AFC 7.6 0.044 50 380 57.76 2.2 0.001936 0.3344 49ers NFC 6.5 0.011 81.3 528.45 42.25 0.8943 0.000121 0.0715 Titans AFC 6.7 0.024 56.3 377.21 44.89 1.3512 0.000576 0.1608 Redskins NFC 6.4 0.041 31.3 200.32 40.96 1.2833 0.001681 0.2624 A.) Develope the estimated regression equation that could be used to predict the percentage of games won given the average number of passing yards per attempt. C.) Develope the estimated regression equation that could be used to predict the percentage of games won given the average number of passing yards per attempt and the number of interceptions thrown per attempt. Sum of X 110.4 Sum of Y 869.2 Sum of X1 110.4 Sum of Y 869.2 Sum of X2 0.432 Sum of XY 6291.2 Sum of X and Sum of Y 95959.68 Sum of X1Y 6291.2 Sum of X1X2 2.9239 Sum of X2Y 21.1861 Sum of X2 779.68 Sum of X12 779.68 Square of Sum of X1X2 8.54919121 Sum of X22 0.01309 SXY 293.72 SXX -468.04 SX1Y 20.40577 SXX 1.65681999 SX2Y -1876.46 b1 -0.62755 b0 58.65512 b1 12.31623 b0 -0.077627762 b2 -1132.57 The estimated regression equation is The estimated regression equation is Y=58.655-0.627X Y=-0.077+12.31X1 -1132.57X2 B.) Develope the estimated regression equation that could be used to predict the percentage of games won given the number of interceptions thrown per attempt. D.)the estimated regression equation developed in part (c) to predict the percentage of games won by the kansas City Cheifs is Sum of X 0.432 Sum of Y 869.2 Sum of XY 21.1861 Sum of X and Sum of Y 375.4944 Y=0.077+12.31*6.2-1132.57*.036=35.6265 Sum of X2 0.01309 SXY -2.2823 SXX -2.29396 b1 0.994915 b0 54.29814 The estimated regression equation is Y=54.298-0.9949X