Computer Science 211

Manipulating Excel Data

Assigned: Week of April 18, 1999

Due: Week of April 25, 1999

10 points

Purpose: To learn how to manipulate data in a large excel file to obtain information and create graphs.

Assignment:
Answer the following questions about the data:

• What is the average batting-average of each team? (Hint, calculate an average of all the players’ batting averages for each team. That will be close enough.)
• What are the overall batting averages for each of the following positions: First basemen (1B), Second basemen (2B), Third basemen (3B), Short-stops (SS) Outfielders (OF), Catchers (C) and Designated Hitters (DH)? (Hint, calculate similar to the way done for team averages.)
• How many home-runs did Mark McGuire hit that year?
  How many at-bats did Mick Tittleton have?
  How many times did Robin Ventura strike out?

Create the following charts:

• A bar-chart showing the average batting-average for each team. (You can use the same data from above.) The chart should have the teams listed along the bottom (the x-axis) and there should be data-labels at the top of each bar. (Sample chart. Please note, the data in the sample are not the same as the data you will use for your chart.)
• A pie-chart showing a break-down of the Milwaukee Brewers’ hitting for the season. There should be a ‘slice’ in the pie for each of the following categories: Hits, Doubles, Triples and Home-runs. There should be data-labels showing the percentage contribution of each slice. (Sample chart. Please note, the data in the sample are not the same as the data you will use for your chart.)

Turn in: At the start of lab next week, please turn in typed answers to the above questions along with a print-out of each of the graphs. Please place each graph on its own page and make sure your name is on each page.

Any questions?