The file S03_58.xlsx lists salaries of MLB players in the years 2007 to 2009. Each row corresponds to a particular player. As indicated by blank salaries, some players played in one of these years, some played in two of these years, and the rest played in all three years.
a. Create a new Yes/No variable, All 3 Years, that indicates which players played all three years.
b. Create two pivot tables and corresponding pivot charts. The first should show the count of players by position who played all three years. The second should show the average salary each year, by position, for all players who played all three years. Explain briefly what these two pivot tables indicate.
c. Define a StatTools data set on only the players who played all three years. Using this data set, create a table of correlations of the three salary variables. What do these correlations indicate about player salaries?