Question

# The National Football League (NFL) records a variety of performance data for individuals and teams. To...

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

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

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.

#### Earn Coins

Coins can be redeemed for fabulous gifts.