Repeat Problem 51 with the football data in the file P03_57.xlsx.
a. Rearrange the data so that there are four long columns: Team, Year, Salary, and Wins. There should be 6*30 values for each.
b. Create a scatter plot of Wins (Y) versus Salary (X). Is there any indication of a relationship between these two variables? Is it a linear relationship?
c. Run a regression of Wins versus Salary. What does it say, if anything, about teams buying their way to success?