Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 1: The File NFLValues.xlsx show the annual revenue ($ millions) and the estimated team value ($ millions) for the 32 teams in the National
Problem 1:
The File NFLValues.xlsxshow the annual revenue ($ millions) and the estimated team value ($ millions) for the 32 teams in the National Football League.
- Develop a scatter diagram with Revenue on the horizontal axis and Value on the vertical axis. Does it appear that there are any outliers and/or influential observations in the data?
- Develop the estimated regression equation that can be used to predict team value given the value of annual revenue.
- Use residual analysis to determine whether any outliers and/or
- influential observations are present. ( Cook's Distance).Briefly summarize your findings and conclusions.
Use SAS for this ques: and also provide the SAS code:
DATASET file NFLVALUE:
Team | Revenue | Value | |
Arizona Cardinals | 203 | 914 | |
Atlanta Falcons | 203 | 872 | |
Baltimore Ravens | 226 | 1062 | |
Buffalo Bills | 206 | 885 | |
Carolina Panthers | 221 | 1040 | |
Chicago Bears | 226 | 1064 | |
Cincinnati Bengals | 205 | 941 | |
Cleveland Browns | 220 | 1035 | |
Dallas Cowboys | 269 | 1612 | |
Denver Broncos | 226 | 1061 | |
Detroit Lions | 204 | 917 | |
Green Bay Packers | 218 | 1023 | |
Houston Texans | 239 | 1125 | |
Indianapolis Colts | 203 | 1076 | |
Jacksonville Jaguars | 204 | 876 | |
Kansas City Chiefs | 214 | 1016 | |
Miami Dolphins | 232 | 1044 | |
Minnesota Vikings | 195 | 839 | |
New England Patriots | 282 | 1324 | |
New Orleans Saints | 213 | 937 | |
New York Giants | 214 | 1178 | |
New York Jets | 213 | 1170 | |
Oakland Raiders | 205 | 861 | |
Philadelphia Eagles | 237 | 1116 | |
Pittsburgh Steelers | 216 | 1015 | |
San Diego Chargers | 207 | 888 | |
San Francisco 49ers | 201 | 865 | |
Seattle Seahawks | 215 | 1010 | |
St Louis Rams | 206 | 929 | |
Tampa Bay Buccaneers | 224 | 1053 | |
Tennessee Titans | 216 | 994 | |
Washington Redskins | 327 | 1538 | |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started