First,
use your mouse to highlight the "Wins (1999)" column for just the
American League (AL).
Next,
use the "Data" command menu (at the top of the Excel window) to
select "Sort."
You
will be prompted to "expand the selection." Answer 'yes' and choose
"descending order" from the menu. (NOTE: If you have done this
correctly, the New York Yankees--with 98 wins--should now be the first team on
the AL list.)
Repeat
this process for the National League (NL). (NOTE: If you have done this
correctly, the Atlanta Braves--with 103 wins--should now be the first team on
the NL list.)
You
may want to print out your Excel worksheet and refer to the printout as you
answer the following questions:
1. Only two of the top seven teams in the American League
had an average player salary lower than the MLB average. Which teams were
these?
2. Only one of the bottom seven teams in the American
League had an average player salary higher than the MLB average. Which team was
this?
3. Only two of the top eight teams in the National League
had an average player salary lower than the MLB average. Which teams were
these?
4. Only two of the bottom eight teams in the National
League had an average player salary higher than the MLB average. Which teams
were these?
5. What do these results seem to imply?