Question: provide a pivot table that shows the average salary each year, by position, for all players who played all three years. (For each of these,
provide a
pivot table that shows 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.) Round your answers to a whole dollar amount, if necessary.
| Values | ||||||
| Position | Average of Salary 2007 | Average of Salary 2008 | Average of Salary 2009 | |||
| Catcher | $ | $ | $ | |||
| Designated Hitter | $ | $ | $ | |||
| First Base | $ | $ | $ | |||
| Outfielder | $ | $ | $ | |||
| Pitcher | $ | $ | $ | |||
| Second Base | $ | $ | $ | |||
| Shortstop | $ | $ | $ | |||
| Third Base | $ | $ | $ | |||
| Grand Total | $ | $ | $ |
Select the appropriate pivot chart that shows the average salary each
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
