The file S03_55.xlsx lists the average salary for each MLB team from 2004 to 2009, along with the number of team wins in each of these years.
a. Create a table of correlations between the Wins columns. What do these correlations indicate? Are they higher or lower than you expected?
b. Create a table of correlations between the Salary columns. What do these correlations indicate? Are they higher or lower than you expected?
c. For each year, create a scatter plot and the associated correlations between Wins for that year (Y axis) and Salary for that year. Does it appear that teams are buying their way to success?
d. The coloring in the Wins columns indicates the playoff teams. Create a new Yes/No column for each year, indicating whether the team made it to the playoffs that year. Then create a pivot table for each year showing average of Salary for that year, broken down by the Yes/No column for that year. Do these pivot tables indicate that teams are buying their way into the playoffs?