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 average number of passing yards per attempt (Yds/Att) and the percentage of games won (Win%) for a random sample of  NFL teams.

Team	Yds/Att	Win%
Team 1	6.5	43
Team 2	7.9	76
Team 3	8.0	74
Team 4	7.6	63
Team 5	7.3	66
Team 6	7.9	76
Team 7	7.7	72
Team 8	8.0	77
Team 9	5.0	19
Team 10	5.9	36

c. 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. Enter negative value as negative number. win= ( )+ ( )(Yds/Att) (to 2 decimals) d. Provide an interpretation for the slope of the estimated regression equation (to 1 decimal). The slope of the estimated regression line is approximately _____. So, for every_______of one yard in the average number of passes per attempt, the percentage of games won by the team increases by____ %. e. The average number of passing yards per attempt for the other Team was 7.3. Use the estimated regression equation developed in part (c) to predict the percentage of games won by the team. ____ %.

Answer 1

Solution: We can excel regression data analysis tool to find the estimated regression equation. The excel output is given below:

c. 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. Enter negative value as negative number.

Answer: From the above outputs, we have:

d. Provide an interpretation for the slope of the estimated regression equation (to 1 decimal).

The slope of the estimated regression line is approximately _____. So, for every_______of one yard in the average number of passes per attempt, the percentage of games won by the team increases by____ %.

Answer: The slope of the estimated regression line is approximately 19.42. So, for every increase of one yard in the average number of passes per attempt, the percentage of games won by the team increases by19.42%.

e. The average number of passing yards per attempt for the other Team was 7.3. Use the estimated regression equation developed in part (c) to predict the percentage of games won by the team. ____ %.

Answer: The estimated regression equation is:

Therefore, the average number of passing yards per attempt for the other Team was 7.3. Use the estimated regression equation developed in part (c) to predict the percentage of games won by the team. 62.50%.