You have been given some data about professional football for one season. Assume
ID: 3053924 • Letter: Y
Question
You have been given some data about professional football for one season.
Assume that the Yards/Game column is the INDEPENDENT variable.
Using Excel's Regression tool (from the Data Analysis pack), determine the coefficients of the linear regression. You also want to know if there are any OUTLIERS in the data, where the assumption is that the data is an outlier, if it is BEYOND plus or minus TWO standard deviations.
You will be answering the following questions:
a) What is the value of R Squared?
b) Using Linear Regression, you are going to come up with an equation: PointsPerGame = b0 + b1 * YardsPerGame. What is the value of b1?
c) Is there a linear relationship between PointsPerGame and YardsPerGame?
d) Are there any outliers?
You have been given some data about professional football for one season.
Assume that the Yards/Game column is the INDEPENDENT variable.
Using Excel's Regression tool (from the Data Analysis pack), determine the coefficients of the linear regression. You also want to know if there are any OUTLIERS in the data, where the assumption is that the data is an outlier, if it is BEYOND plus or minus TWO standard deviations.
You will be answering the following questions:
a) What is the value of R Squared?
b) Using Linear Regression, you are going to come up with an equation: PointsPerGame = b0 + b1 * YardsPerGame. What is the value of b1?
c) Is there a linear relationship between PointsPerGame and YardsPerGame?
d) Are there any outliers?
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.4Explanation / Answer
1] the value of R^2 = 0.7999
2] PointsPerGame = b0 + b1 * YardsPerGame
PointsPerGame = -19.2478+ 0.1259 * YardsPerGame
3] there is a linear relationship between PointsPerGame and YardsPerGame
SUMMARY OUTPUT Regression Statistics Multiple R 0.89439966 R Square 0.79995074 Adjusted R Square 0.79328244 Standard Error 2.26981501 Observations 32 Coefficients Standard Error t Stat P-value Intercept -19.2477563 3.759480472 -5.11979 1.66E-05 X Variable 1 0.12588913 0.011493822 10.95277 5.27E-12Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.