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.