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 data shown presents the average number of passing yards per attempt (Yds/Att) and the percentage of games won (WinPct) for a random sample of 10 NFL teams for the 2011 season (NFL website, February 12, 2012).

Team	Yds/Att	Win%
Arizona Cardinals	6.5	50
Atlanta Falcons	7.1	63
Carolina Panthers	7.4	38
Chicago Bears	6.4	50
Dallas Cowboys	7.4	50
New England Patriots	8.3	81
Philadelphia Eagles	7.4	50
Seattle Seahawks	6.1	44
St. Louis Rams	5.2	13
Tampa Bay Buccaneers	6.2	25

Perform the following:

1.)Develop a scatter diagram with the number of passing yards per attempt on the horizontal axis. What does the scatter diagram indicate about the relationship between the two variables?
2.)What is the estimated regression equation (use 2 decimal places)?
3.)Conclude on the goodness of fit.
4.)Test if the independent variable is significant. Use a = 0.10 and make sure to show all 5 steps in your test.
5.)Test the equation as a whole. Use a = 0.10 and make sure to show all 5 steps in your test.
6.)Do the assumptions about the error term seem reasonable? Use the appropriate statistical tool.
7.)Interpret the coefficient of the independent variable
8.)Develop a 90% confidence interval estimate of the mean win percentage if the passing yards per attempt is 6.2.
9.)Develop a 90% prediction interval for the Kansas City Chiefs who had an average passing yards per attempt of 6.2 for the season. .
10.)Compare your results in part i. when the known record for the KC Chiefs for the 2011 season was 7 wins and 9 losses.

Answer 1