By the end of this lab you should have Homework Assignment One done.

Here's the text in case you don't have the book yet.

The Base.xls file records information related to

• baseball salaries (in hundreds of thousands of dollars) and
• batting averages throughout a player's career.

1. Display only those players whose career batting average is 0.310 or greater.
   Print your results.

2. Add a new column to the worksheet, displaying
   • the batting average divided by the player's salary and multiplied by 1000.

3. Sort the worksheet in descending order of the new column you created.
   What are the top ten players in terms of batting average per dollar?
   Print your results.

4. Examine the number of years played in your sorted list.
   Where do most of the first-year players lie?
   What would account for that?
   (Hint: What are some of the other factors besides batting average that may account for a player's high salary?)

5. Save the workbook as and turn it in.

Turn your assignment in OnCourse before the end of the lab.

1. Homework Two will be collected next time (problem 2 on page 111).
2. You need to show (and describe) your completed experiment.

You might receive questions of the following nature:

1. How do you work with Excel (Kenai Fjords, pp. 15-23).
2. How do you load the StatPlus Add-In and the Data Analysis ToolPak (pp. 30-33)?
3. What is AutoFill (pp. 40-42).
4. How do you insert a formula (pp. 47-51)?
5. What are cell references (p. 51)?
6. How do you import data from text files (pp. 62-66, Wheat.txt)?
7. How do you create charts with the chart wizard (pp. 85-91, BigTen.xls)?
8. How do you edit charts (pp. 91-97)?
9. What is a bubble plot (pp. 102-106)?