Assignment #4 NOTES: 1. The data sets for these problems are available on D2L under the data set module. 2. These questions can be done by hand or by excel. If doing calculations by hand show your work. If using excel, copy & paste your excel output into your assignment. Total = 17 Marks Problem 1 [6 marks] DATAfile: NFLPassing 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 (Yards/Attempt) and the percentage of games won (WinPct) for a random sample of 10 NFL teams for the 2011 season. t Team Yards/Attempt WinPct 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