Answered step by step
Verified Expert Solution
Link Copied!

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.

  1. 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?
  2. Develop the estimated regression equation that can be used to predict team value given the value of annual revenue.
  3. Use residual analysis to determine whether any outliers and/or
  4. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transportation A Global Supply Chain Perspective

Authors: John J. Coyle, Robert A. Novak, Brian Gibson, Edward J. Bard

8th edition

9781305445352, 1133592961, 130544535X, 978-1133592969

More Books

Students also viewed these Mathematics questions