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

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!