The Complete Car Market Analysis: 150+ Insights Across Price, Performance & Efficiency

By shrijeetverma13 · June 23, 2026

This comprehensive analysis breaks down 17,000+ vehicle records across 26 manufacturers to reveal what you're actually paying for. From the Chevrolet…

The Chevrolet Camaro offers the best horsepower-per-dollar value, delivering 13.626 HP for every $1,000 of MSRP, starting at just $23,705. A horizontal bar chart shows the top 15 models ranked by this metric, making it easy to compare value across brands.

A line chart has been generated showing how average MSRP trended across trim years 2017 through 2020. The visualization plots each year's average MSRP with markers, making it easy to see whether prices rose, fell, or stayed stable over this four-year period.

Bugatti commands the highest average MSRP at nearly $2 million, making it the clear leader in premium positioning. The top 5 premium makes are Bugatti ($1,990,064), Rolls-Royce ($380,812), Lamborghini ($340,958), McLaren ($282,822), and Ferrari ($262,688). A horizontal bar chart shows the top 15 makes by average MSRP, visually highlighting the dramatic gap between Bugatti and the rest of the field. The overall average MSRP across all makes is $123,693, meaning these luxury brands sit well above the market norm.

For fuel-conscious buyers, Hatchbacks are the clear winner with an average of 31.9 combined MPG — significantly ahead of other body types. A bar chart and data tables have been generated showing the full ranking across body types.

The models with the largest gaps between MSRP and invoice price are dominated by luxury and exotic vehicles. The Porsche 918 Spyder tops the list with a massive $88,700 gap (MSRP $887,000 vs Invoice $798,300). Ferrari models claim the next four spots, with the 812 Superfast ($37,066 gap), 488 Spider ($31,489), 488 GTB ($28,350), and Portofino ($23,186). A horizontal bar chart shows the top 15 models ranked by their average MSRP–Invoice gap.

Across 26 makes with electric models, Tesla stands out with the longest average electric range at 303.8 miles. Two charts were generated: a scatter plot showing the relationship between average range and 240V charging time per make, and a bar chart ranking makes by average range with charging time as a color dimension. The overall average electric range is 73.9 miles, with an average 240V charge time of 4.63 hours.

The grouped bar chart and analysis reveal how vehicle trims are distributed across body type and drive type combinations. The most common pairing overall is SUV + All Wheel Drive with 2,144 trims, representing 44.3% of all SUV trims. Sedans favor Front Wheel Drive (1,707 trims, 45.2%), while Hatchbacks are strongly dominated by Front Wheel Drive at 82.1% of their category. Crew Cab Trucks lean toward Four Wheel Drive (53.0%), and Coupes are predominantly Rear Wheel Drive (63.1%).

The analysis examined engine size and performance metrics across 13 different cylinder configurations using 17,452 records. Two visualizations were generated: a box plot showing how engine sizes are distributed within each cylinder type, and a bar chart comparing average horsepower across configurations. These charts reveal clear patterns — larger cylinder counts (like V8, V10, V12) tend to have both bigger engine displacements and higher horsepower, while smaller configurations (like I3, I4) cluster at lower engine sizes and output.

Here are the top 15 car makes ranked by average combined MPG for non-electric vehicles, along with their engine size and horsepower. Two visualizations were created: a horizontal bar chart showing the fuel efficiency rankings and a scatter plot illustrating the power vs. efficiency trade-off. Smart takes the top spot with an impressive 34.71 MPG average, followed by Honda (29.02 MPG), Hyundai (28.66 MPG), FIAT (28.29 MPG), and Mazda (28.13 MPG). Notably, Polestar ranks 12th in efficiency (26.0 MPG) but dominates in horsepower with an average of 619 HP — far ahead of any other make in the top 15.

The analysis successfully computed a Pearson correlation matrix for 7 vehicle physical and weight metrics, produced an annotated heatmap, and created a scatter plot of Curb Weight vs. Max Towing Capacity colored by Body Type. The strongest positive correlation is between Body Length and Body Wheel Base (r = 0.975), meaning longer vehicles almost always have a proportionally longer wheelbase. The weakest/most negative relationship found was between Body Height and Body Max Towing Capacity (r = 0.414), suggesting taller vehicles (like SUVs and vans) tend to have lower towing capacity compared to longer, flatter vehicles like trucks. No variable pairs reached the r ≥ 0.5 threshold beyond the length-wheelbase pair, indicating that weight metrics (Curb Weight, Gross Weight, Towing Capacity) are more loosely correlated with pure dimensional measures in this dataset.

The sentiment analysis of the 'Trim Description' column reveals that the text is overwhelmingly neutral in tone. A bar chart was generated showing the distribution across all three sentiment categories, making it easy to see how the data skews.

A word cloud has been generated for the 'Trim Description' column in your dataset. The visualization displays the most frequently occurring words in the trim descriptions, with larger words appearing more prominently to indicate higher frequency.