80 Excel
a. Open the Cars workbook from the
Chapter02 folder.
b. Create range names for all of the data
columns you retrieved.
Using techniques that you’ve learned
in this chapter, answer the following
questions:
c. How many cars come from the model
year 2007?
d. Which car has the highest horsepower?
e. Which car has the highest horsepower
relative to its weight?
f. Which car has the highest miles per
gallon (MPG)?g. Which car has the highest MPG rela-
tive to its 0–60 time? Note that this
car will have fast acceleration and
pretty good MPG.
h. If you sort the data by the ratio of
MPG to 0–60 time, what is the Region
of most of the cars with low values?
What kind of vehicles are these? What
are the Regions of most of the highest
models, and what kind of vehicles do
you fi nd high on this scale? Discuss
the relationship of this scale to Weight.
i. Save your workbook as Cars Perfor-
mance Analysis.MPG Overall miles per gallon
Time0–60 0–60 time in seconds
Weight Weight in pounds
Date Date of Issue
Region Original location of manufacturer
Eng type01 1 if hybrid or diesel, 0 otherwise(Source: Copyright 2008 by Consumers Union of U.S., Inc. Yonkers, NY 10703-1057, a nonprofi t organization.
Reprinted with permission from the February 2008 posting of ConsumerReport.org http://www.consumerreports
.org/ ® for educational purposes only. No commercial use or reproduction permitted.)