*   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?