1.The file P03_56.xlsx lists the average salary for each NBA team from 2004 to 2009, along with the number of team wins each of these years. Answer the same questions as in the previous problem for...

1.The file P03_56.xlsx lists the average salary for each NBA team from 2004 to 2009, along with the number of team wins each of these years. Answer the same questions as in the previous problem for this basketball data. 2. The file P03_57.xlsx lists the average salary for each NFL team from 2004 to 2009, along with the number of team wins each of these years. Answer the same questions as in the problem 55 for this football data. 3. The file P03_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. (For each of these, put the All 3 Years variable in the Report Filter area.) 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?