The File NFLValues.xlsx show the annual revenue ($ millions) and the estimated team value ($ millions) for the 32 teams in the National Football League.

a. 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?

b. Develop the estimated regression equation that can be used to predict team value given the value of annual revenue.

c. Use residual analysis to determine whether any outliers and/or influential observations are present. Briefly summarize your findings and conclusions.