1. Car_Sale
| view database structure |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |
The data set provides information about the sales of automobiles in general vehicle categories.
The fields and their meanings are shown below.
- Year
- Small: percentage of all vehicles sold that were small vehicles
- Midsize: percentage of all vehicles sold that were midsize vehicles
- Large: percentage of all vehicles sold that were large vehicles
- Luxury: percentage of all vehicles sold that were luxury vehicles
2. Classic
| view database structure |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |
The data set provides information about the value of vehicles considered "classics." It includes
peak prices, prices in 1995 and the source of the information as summarized in Road and Track.
The fields and their meanings are shown below.
- Make
- Model
- Year: of manufacture
- Peak Price
- Price: in 1994
- Source
3. Cylinders
| view database structure |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |
The data set provides information about the number of cylinders generally associated with each
size of vehicle as summarized in Car and Truck Buying Made Easier. The fields and their
meanings are as shown below.
- Size: general size of vehicle from mini-compact to full size pickup truck
- Three-Cylinder: availability of this option on the size of vehicle
- Four-Cylinder: availability of this option on the size of vehicle
- Six-Cylinder: availability of this option on the size of vehicle
- Eight-Cylinder: availability of this option on the size of vehicle
- Twelve-Cylinder: availability of this option on the size of vehicle
4. Engine
| view database structure |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |
The data set provides information about the size of engines associated with the number of
cylinders as summarized in Car and Truck Buying Made Easier. Displacement is a measure of
the volume of the combustion chambers and is expressed in liters. Generally, the greater the
volume of the combustion chamber, the greater the power potential for the engine. The fields and
their meaning are as shown below.
- No_cylinders: number of cylinders
- Low_displacement: the bottom of the displacement range typical for that
number of cylinders
- Hi_displacement: the top of the displacement range typical for that number of
cylinders
5. Holdbacks
| view database structure |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |
The data set provides information about dealer holdbacks. All American and most European and
Asian automakers refund money to the dealer after the car is sold. This amount is usually a
function of the manufacturer's suggested retail price (not including destination charge) as
summarized in Road and Track. The fields are shown below.
- Manufacturer
- Percentage Holdback
- Additional Information
6. Location
| view database structure |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |
The data set provides information on the country in which automobiles are produced as
summarized in PM Buyers Guide. The fields and their meanings are shown below.
- Make
- Model
- Country1 - Country 3: three countries in which the greatest number of
vehicles of this make and model are manufactured
7. Maintenance
| view database structure |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |
The data set summarizes the cost for regular maintenance for automobiles at recommended times
in the life of the automobile. The fields and their meanings are summarized below.
Make
Engine
Drive_train
Part_6mo: expected parts costs for 6 month regular maintenance
Labor_6mo: expected labor costs for 6 month regular maintenance
Total_6mo: total expected costs for 6 month regular maintenance
Part_12mo 12 month regular maintenance
Labor_12mo
Total_12mo
Part_18mo 18 month regular maintenance
Labor_18mo
Total_18mo
Part_24mo 24 month regular maintenance
Labor_24mo
Total_24mo
Part_30mo 30 month regular maintenance
Labor_30mo
Total_30mo
Part_36mo 36 month regular maintenance
Labor_36mo
Total_36mo
Part_42mo 42 month regular maintenance
Labor_42mo
Total_42mo
Part_48mo 48 month regular maintenance
Labor_48mo
Total_48mo
8. Overview
| view database structure |
| download dBASE file | download LOTUS file | download EXCEL file | download ACCESS file |
The data set provides an overview of vehicles in each category as summarized in Car and Truck
Buying Made Easier. The fields and their meanings are as shown below.
- Size: represents the general size of vehicle from mini-compact to full size pickup
truck
- EX1 - EX3: three common examples of the kind of vehicle in that size range
- Price_Low: the bottom of the price range typical for that size of vehicle
- Price_High: the top of the price range typical for that size of vehicle
- Attribute1 - Attribute3: three typical attributes of that size of vehicle
- Style1 - Style3: provides guidance on categories of vehicles, such as the
number of doors, windows and wagon components
- Type1 - Type3: provides guidance on the "drive types" available for that
vehicle, including front-wheel drive, rear-wheel drive, four-wheel drive
- Manual: the kind of options available with standard transmission
- Automatic: the kind of options available with automatic transmission
- Fuel1 - Fuel2: fuel requirements, e.g., gasoline or diesel
- Engine1 - Engine2: the number of cylinders available with that size of vehicle