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 (Win96) for a random sample of 10 NFL teams. Team Team 1 Team 2 Team 3 Team 4 Team 5 Team б Team 7 Team 8 Team 9 Team 10 Yds/Att 5.5 6.1 6.3 7.6 7.7 7.0 7.4 7.4 6.5 7.2 Win % 30 51 56 76 78 60 69 71 59 67 b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables? The scatter diagram Indicates a Select your answer lnear relationship between r average number of passing yards per attempt and y the percentage of games won by the teanm C. Develop the estimated regression equation that could be used to predict the percentage of games won glven the average number of passing yards per attempt. Enter negative value as negative number (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 Select your answer 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 5.6. Use the estimated regression equation developed in part (c) to predict the percentage of games won by the team. % (to 2 decimals)

Answer 1

b)

9 8 7 6 5 4 3 2 1 0 98765 321 %UIM

scatterplot,diagram indicates a positive linear reltionship

c)

excel o/p usinh data analyis tool for regression given below,

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.96636
R Square	0.933851
Adjusted R Square	0.925583
Standard Error	3.85802
Observations	10
ANOVA
	df	SS	MS	F	Significance F
Regression	1	1681.025	1681.025	112.9393	5.38E-06
Residual	8	119.0746	14.88432
Total	9	1800.1
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	-66.3196	12.10792	-5.47737	0.000589	-94.2405	-38.3986	-94.2405	-38.3986
YDS/ATT	18.63458	1.753465	10.62729	5.38E-06	14.59108	22.67808	14.59108	22.67808

from, here,

Win % = -66.32 + 18.63*yds/att

d)

the slope of estimated regression equation is approximately 18.6, so, for every unit increase of one yard, in the avergae number of passes per attempt,the percentage of games won increases by 18.63%

e)

x=5.6

Win % = -66.32 + 18.63*5.6 = 38.03%(answer)