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 data in the Excel Online file below show the conference (Conf), 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 a season. Construct a spreadsheet to answer the following questions.

Develop the estimated regression equation that could be used to predict the percentage of games won given the average number of passing yards per attempt (to 1 decimal).

Win%=b0+b1 x Yds/Att

b0=

b1=

Develop the estimated regression equation that could be used to predict the percentage of games won given the number of interceptions thrown per attempt (to 1 decimal).

Win%=b0+b1 x Int/Att

b0=

b1=

Develop 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 (to 1 decimal).

Win%=b0+b1 x Yds/Att =+b2 x Int/Att

b0=

b1=

b2=

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

Predicted percentage		Actual percentage
	<>=

Team	Conf	Yds/Att	Int/Att	Win%		Part a.
Arizona Cardinals	NFC	6.5	0.042	50.0		After reading these instructions delete all text in this shaded area.
Atlanta Falcons	NFC	7.2	0.023	62.2
Carolina Panthers	NFC	7.4	0.032	37.2		Use the XLMiner Analysis ToolPak to conduct your Linear Regression analysis.
Cincinnati Bengals	AFC	6.3	0.026	56.1
Detroit Lions	NFC	7.2	0.025	62.6		After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (H2).
Green Bay Packers	NFC	9.0	0.013	93.7
Houstan Texans	AFC	7.5	0.019	62.6		Your Linear Regression analysis output should fit into this shaded area.
Indianapolis Colts	AFC	5.5	0.027	12.5
Jacksonville Jaguars	AFC	4.7	0.032	31.4
Minnesota Vikings	NFC	5.8	0.033	18.6
New England Patriots	AFC	8.1	0.020	81.4
New Orleans Saints	NFC	8.2	0.022	81.4
Oakland Raiders	AFC	7.6	0.044	49.7
San Francisco 49ers	NFC	6.4	0.011	81.1
Tennessee Titans	AFC	6.7	0.024	56.2
Washington Redskins	NFC	6.3	0.040	31.3
						Part b.
						After reading these instructions delete all text in this shaded area.
						Use the XLMiner Analysis ToolPak to conduct your Linear Regression analysis.
						After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (H22).
						Your Linear Regression analysis output should fit into this shaded area.