What's the City Mileage of a Typical American Car?


It has been said that Americans have always had a love affair with big gas-guzzling cars. In the past, most American car manufactures such as Ford and General Motors modeled their cars to satisfy this desire of American car buyers. However, in the late 1970s, gas prices rose at tremendous rates. This, in turn, made driving much more expensive than it used to be. Also, foreign manufactures began to import smaller, more gas efficient cars and Americans began to buy more foreign cars.

Nowadays, there are a wide variety of American cars some with high mileages and some with poor mileages. Your job is to analyze the data and find an average for the mileages of American cars. A problem like this can sometimes involve difficult and time-consuming statistical analyses. But in this lesson you will explore a method of analysis that will simplify problems such as these. This method is called the BOOTSTRAP.

To do this lesson, download this Microsoft Excel 5.0 spreadsheet - BOOTSTRAP.xls

If you are unfamiliar with Excel 5.0 then check out this quick Excel 5.0 tutorial. The lesson was created so that even if you have no experience with Excel, you can still do it.

To continue with the lesson and find just how fuel efficient American cars are, follow the first link below. You will be directed to the other links when you finish each section.

The Mileage Analysis - How To Sample

The Mileage Analysis - Developing A Confidence Interval

Helium Footballs - How To Sample From Two Data Sets

Helium Footballs - Finding Differences Between Means

Do Your Own Analysis

Comments about the lesson and suggestions on how and with who to use it.

Any comments or questions? Send mail to the MSTE Webmaster.

For links to other math and statistics lessons, check out the MSTE lesson database.

This page has been visited times since 6/30/97.