The file P03_58.xlsx lists salaries of MLB players in the years 2007 to 2009. Each row corresponds to a particular playe

[answerhappygod]

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.
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 Filters area.)
Create a pivot table that shows the count of players by position
who played all three years.