Analytics · Automotive · Mpg · Fuel Efficiency
Executive Summary

Executive Summary

Key findings from the fuel efficiency analysis

n_observations
392
mean_mpg
24.37
mpg_range
29.8
mpg_weight_cor
-0.946
r_squared
0.9205
sd_mpg
7.05
Across 392 vehicles, average fuel efficiency is 24.4 MPG with a range of 29.8 MPG, reflecting dramatic variation driven primarily by engine configuration. Weight and MPG are correlated at r = -0.95, confirming weight as the dominant single predictor. Together weight, horsepower, displacement, and cylinders explain 92% of MPG variance (R² = 0.92); weight carries the largest standardized regression coefficient.
Interpretation

Across 392 vehicles, average fuel efficiency is 24.4 MPG with a range of 29.8 MPG, reflecting dramatic variation driven primarily by engine configuration. Weight and MPG are correlated at r = -0.95, confirming weight as the dominant single predictor. Together weight, horsepower, displacement, and cylinders explain 92% of MPG variance (R² = 0.92); weight carries the largest standardized regression coefficient.

Data Table

Descriptive Statistics

Summary statistics for key vehicle attributes

metricmpgweighthorsepowerdisplacement
Mean24.372789124.2221.8
Median25.22606123213
Std Dev7.05799.631.9571.4
Min916004672
Max38.84785230403
Interpretation

The average vehicle achieves 24.4 MPG (SD = 7.0) with a mean weight of 2789 lbs and 124 horsepower. The wide standard deviation in MPG indicates substantial fleet heterogeneity, driven by the mix of 4-, 6-, and 8-cylinder vehicles spanning over a decade of model years.

Visualization

Attribute Correlation Matrix

Pairwise Pearson correlations between vehicle attributes

Interpretation

Weight correlates with MPG at r = -0.95 — the strongest single-attribute relationship in the dataset. Displacement and horsepower are nearly as strongly correlated with MPG (and with each other), suggesting significant multicollinearity: knowing weight already tells you much of what displacement and horsepower would add.

Visualization

Weight vs. Fuel Efficiency

Vehicle weight vs. MPG coloured by cylinder count

Interpretation

Each point in the scatter represents one vehicle (392 total). The strong downward trend (r = -0.95) confirms that heavier cars consistently achieve lower MPG. Clear clusters appear by cylinder count (5 groups), with 8-cylinder vehicles occupying the high-weight / low-MPG corner and 4-cylinder cars clustering in the light-weight / high-MPG region.

Visualization

MPG Distribution by Cylinder Count

Fuel efficiency box plots grouped by number of engine cylinders

Interpretation

4-cylinder engines average 29.4 MPG versus 16.4 MPG for 8-cylinder engines — a gap of 13.0 MPG. The box plots reveal not only different medians but also different spread: 8-cylinder vehicles cluster tightly in the low-efficiency range, while 4-cylinder cars show more variation, reflecting the broad range of compact and economy models.

Visualization

Fuel Efficiency Trend by Model Year

Average MPG per model year from 1970 to 1982

Interpretation

Average fleet MPG rose from 24.2 (model year 70) to 24.7 (model year 82), a gain of 0.5 MPG over the period. The most efficient model year was 79. The steepest improvements coincide with regulatory pressure and oil-price shocks in the mid-to-late 1970s, when automakers accelerated the shift to lighter, more fuel-efficient designs.

Visualization

Feature Importance for MPG Prediction

Standardized regression coefficients showing each predictor's MPG contribution

Interpretation

Standardized regression coefficients show weight as the single largest contributor to MPG prediction (beta = 0.800), meaning a one-SD shift in weight is associated with a 0.800-SD change in MPG, holding other variables constant. The four-predictor model explains 92% of MPG variance (R² = 0.920).

Data Table

Top Fuel-Efficient Vehicles

Top 20 vehicles ranked by MPG

mpgweightcar_namecylindershorsepower
38.81656oldsmobile rabbit476
38.51600honda impala346
381682oldsmobile corolla467
37.81600opel chevette485
37.21600oldsmobile corolla496
37.11744volkswagen fiesta493
371600plymouth tercel461
36.61600volkswagen omni457
36.51600honda chevette468
35.71829dodge horizon488
35.51600plymouth delta 88388
35.51600toyota fiesta465
35.51688peugeot omni460
35.41902fiat golf4101
35.11600pontiac galaxie3104
351600opel electra571
34.91839pontiac omni483
34.92133peugeot golf4118
34.81600buick chevette493
34.81920volkswagen horizon491
Interpretation

The top 20 most fuel-efficient vehicles average 36.2 MPG at a mean weight of 1700 lbs. 80% are 4-cylinder models, confirming that cylinder count is the primary structural differentiator of high-efficiency vehicles. The most efficient car in the dataset is the oldsmobile rabbit at 38.8 MPG.

Your data has more stories to tell. Run any analysis on your own data — 60+ validated R modules, interactive reports, AI insights, and PDF export. 2,000 free credits on signup.
Try Free — No Signup Sign Up Free

Report an Issue

Tell us what's wrong. You'll get a free re-run of this analysis so you can try again with different parameters. If the re-run still doesn't meet your expectations, we'll refund your credits.

Want to run this analysis on your own data? Upload CSV — Free Analysis See Pricing