The file S03_58.xlsx lists salaries of MLB players in the years 2007 to 2009. Each row corresponds
Question:
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?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Question Posted: