Chapter 3 Working with Charts 125
Label the axes appropriately. Save the
chart into a chart sheet named Protein
Chart.
c. Label each point in the scatter plot
with its food name.
d. Create a bubble plot of protein versus
carbohydrates with the size of the
bubble determined by the amount
of sugar contained in each product.
Format the chart to make it easy to
read and interpret. Which plot points
show the largest bubbles (and thus the
largest sugar content) and what food
do they represent?
e. Sugar does not contain protein.
Explain how this fact is refl ected in
the placement of the two food prod-
ucts with the largest sugar content in
the bubble plot you just created.
f. Save your workbook and write a
report summarizing your observations
from the graph you created.
- How well does a player’s salary match
up with his career batting average?
You’ve been given performance and
salary data of major league players from
the beginning of the 2007 season (non-
pitchers only). Analyze the relationship
between performance and pay.
a. Open the Baseball workbook from
the Chapter03 folder and save it as
Baseball Salaries Chart.
b. Create a scatter plot with salary on
the y axis and career batting average
(AVG) on the x axis. Label the axis
appropriately and save the plot in a
chart sheet named Salary Chart
vs. AVG.
c. Change the lower range of the x axis
scale to 0.15.
d. Identify on the plot the last name of
the player with the highest salary.
How does this player’s batting average
compare to the other players in the
sample?
e. Salary values can vary in magnitude
from around 200,000 up to more
than 20,000,000. You can adjust for
this scatter by plotting the data on a
logarithmic chart. Copy your chart
sheet to a new sheet named Salary Log
Chart and then change the property of
the vertical axis to show the axis with a
log scale over a range from 300,000 up
to 30,000,000. How does the log scale
affect the vertical scatter of the data?
f. Create a scatter plot of salary vs. home
runs (HR). Save the chart on a chart
sheet named Salary Chart vs. HRs.
Compare this chart to the one you
created in the Salary Chart vs. AVG
sheet. Which chart shows the stron-
ger relationship? Which do owners
appear to value more: batting average
or homeruns?
g. There is a player in your chart who
appears to be underpaid for the
number of homeruns hit. Identify this
player. Examine how many seasons
the player has been in the league.
Explain how this could have affected
his salary value.
h. Create a bubble plot of salary vs. bat-
ting average on a new chart sheet
named Salary vs. Avg Bubble Chart
with the values of the HR column
to determine the size of each bubble
(Note: Due to the order of the columns
in the Player Data worksheet, you can
more easily create the bubble plot
using the StatPlus Fast Bubble Plot
command available under Multi-
variable Charts menu). Set the scale of
the x-axis to range from 0.15 to 0.35
in intervals of 0.05. Display the y-axis
on a log scale ranging from 300,000 to
30,000,000. Make the bubble symbols
partly transparent with the width of
the bubble scaled down to 25. Based
on your bubble plot where are the larg-
est bubbles (and thus the players with
the most home runs) concentrated?
