Question: I need help with this problem. I put everything in excel and My graph looks messy and Iget lost on what this problem wants me
I need help with this problem. I put everything in excel and My graph looks messy and Iget lost on what this problem wants me to do. Please help!
| 11. The Excel file National Football League provides various data on professional football for one season. | |||
| a. Construct a scatter diagram for points/game and yards/game in the Excel file. Does there appear to be a linear relationship? | |||
| b. Use the Regression tool to develop a model for predicting points/game as a function of yards/game. Explain the statistical significance of the model and the R2 value. | |||
| National Football League Data 2007 Season.xlsx | |||
| This is from the solutions | |||
| Team | Points/Game | Yards/Game | |
| Arizona Cardinals | 25.2 | 344.1 | |
| Atlanta Falcons | 16.2 | 301 | |
| Baltimore Ravens | 17.2 | 302 | |
| Buffalo Bills | 15.8 | 277.1 | |
| Carolina Panthers | 16.7 | 284.9 | |
| Chicago Bears | 20.9 | 293.2 | |
| Cincinnati Bengals | 23.8 | 348 | |
| Cleveland Browns | 25.1 | 351.3 | |
| Dallas Cowboys | 28.4 | 365.7 | |
| Denver Broncos | 20 | 346.3 | |
| Detroit Lions | 21.6 | 322.9 | |
| Green Bay Packers | 27.2 | 370.7 | |
| Houston Texans | 23.7 | 333.6 | |
| Indianapolis Colts | 28.1 | 358.7 | |
| Jacksonville Jaguars | 25.7 | 357.4 | |
| Kansas City Chiefs | 14.1 | 276.8 | |
| Miami Dolphins | 16.7 | 287.5 | |
| Minnesota Vikings | 22.8 | 336.2 | |
| New England Patriots | 36.8 | 411.2 | |
| New Orleans Saints | 23.7 | 361.2 | |
| New York Giants | 23.3 | 331.4 | |
| New York Jets | 16.8 | 294.7 | |
| Oakland Raiders | 17.7 | 294.8 | |
| Philadelphia Eagles | 21 | 358.1 | |
| Pittsburgh Steelers | 24.6 | 327.4 | |
| San Diego Chargers | 25.8 | 315.2 | |
| San Francisco 49ers | 13.7 | 237.3 | |
| Seattle Seahawks | 24.6 | 348.9 | |
| St. Louis Rams | 16.4 | 297.5 | |
| Tampa Bay Buccaneers | 20.9 | 326.8 | |
| Tennessee Titans | 18.8 | 311.7 | |
| Washington Redskins | 20.9 | 333.4 |
Step by Step Solution
There are 3 Steps involved in it
Lets work through this step by step a Constructing a Scatter Diagram 1 Open Excel and Input the Data Enter your teams data in two columns PointsGame a... View full answer
Get step-by-step solutions from verified subject matter experts
