Question

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 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.

Excel File

https://drive.google.com/file/d/1pfIsW3U477qRB8nj0fv_PD1fnRHV68Xx/view?usp=sharing

(a)	Using Excel Regression Analysis, write the fitted regression equation. (Round your answer to 4 decimal places. Negative values should be indicated by a minus sign. Confidence level is NOT included and NOT taken into consideration).

yˆy^ =

+  * Yds/Att +  * Int/Att

(b)	What is the number of observations (whole number) ?

(c)	What is the R Square value ? (Round your answer to 4 decimal places. Negative values should be indicated by a minus sign.)

R2

(d)

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 .036 . Use the estimated regression equation developed in part (a) to predict the percentage of games won by the Kansas City Chiefs. ( Round your answer to 2 decimal places - example 25.45%)

%

(e)	For the season, the Kansas City Chief's record was 7 wins and 9 losses. What is the actual percentage? ( Round your answer to 2 decimal places - example 28.37%)

%

(f)	For the season, the Kansas City Chief's

	won more than predicted.
	won less than predicted.

  

Answer 1

Here there are 2 independent and 1 dependent variable.

Independent variable: Yds and Int

Dependent variable: Win

Using Excel:

Go in Data --> Data analysis --> Regression --> Select Win data as Y range and Yds and Int as X range. Then select the output range and then ok.

(a)

(b) Number of observations are 16

(c) Using excel output

R square = 0.7330

(d) Given Yds = 6.2, Int = 0.036

%

(e) Total games = 7 win + 9 loss = 16

The actual percentage of wins =

Actual percentage = 43.75%

(f) Actual is more than predicted,

For the season, the Kansas City Chief's won more than predicted.