126 Excel
i. There appears to be a player whose
reported salary is lower than expected
for his combination of batting average
and homeruns. Identify that player.
j. Save your workbook and write a
report summarizing your observa-
tions. Which is more important
in determining the player salary:
homeruns or batting average?- Working at the Bureau of Labor
Statistics, James Longley tracked several
variables related to the United States
economy from 1947 to 1962. Study the
data he collected.
a. Open the Longley workbook from the
Chapter03 folder and save the work-
book as Longley Graph.
b. The workbook has seven columns
related to the economy. The Total col-
umn displays the total U.S.
employment in thousands. The Arm-
force column displays the total number
of people in the armed forces, listed
again in thousands. Create a scatter
plot of Total versus Armforce. Label
and scale the chart appropriately.
c. Add labels to each plot point indicat-
ing the year in which the datum was
recorded.
d. Four points on the lower left of the
scatter plot stand out. Examine the
economic and political history of the
era to explain why these values are so
distinct from all of the others.
e. Aside from the four points in the
lower left corner of the plot, describe
the general relationship between
total employment and the number of
people in the armed forces.
f. Save your workbook and write
a report summarizing your
observations. - What is the relationship between race
results and reaction time (the time it
takes for the runner to leave the starting
block after hearing the sound of the
starting gun)? You’ve been given a work-
book containing the race results and
reaction times from the fi rst round of
the 100- meter heats at the 1996 Summer
Olympic games in Atlanta. Graph the
data to investigate the effect that reac-
tion time has on race results.
a. Open the Race workbook from the
Chapter03 folder and save it as Race
Graphs.
b. Create a scatter plot of race time
versus reaction time. Label and scale
the chart appropriately. Do you see a
trend that would indicate that runners
with faster reaction times have faster
race times?
c. There is a point that lies away from
the others. Identify the runner corre-
sponding to this point.
d. Copy your chart to another chart sheet
and then rescale the axes, setting the
x axis range to 0.12 to 0.24 seconds
and the y axis scale to 9.5 to 12.5
seconds. Is there any more indication
that a relationship exists between
reaction time and race time?
e. Save your workbook and write a
summary including a comment on
how the scale used in plotting data
can affect your perception of the
results.- The Cars workbook contains informa-
tion on car models from Consumer
Reports®, 2003–2008. Data in the
workbook include the miles per gallon
(MPG) of each car as well as the time to
accelerate from 0 to 60, weight, horse-
power, price, etc. See Exercise 10 of
Chapter 2.
a. Open the Cars workbook from the
Chapter03 folder and save it as Car
Graphs.
b. Create a scatter plot on a separate
chart sheet of MPG (on the y-axis)
versus horsepower (on the x-axis).