Car Analysis

Car Data Analysis

This chart provides insight into the cumulative distance driven across all vehicles for each year.
The trend is highly irregular, with notable peaks and troughs. Some years show significantly higher total mileage, possibly due to a large number of vehicles being included in the dataset for those years.
There are a few years with extreme spikes in kilometers driven, suggesting that some vehicles in those years have exceptionally high mileage.
The dataset might include a mix of newer and older cars, meaning some years could appear inflated due to older vehicles with accumulated miles being accounted for.
If the peaks correspond to older vehicles, this could suggest that buyers in those years purchased used cars with higher mileage rather than new cars.

This chart provides a direct comparison between the sum of selling prices (blue) and sum of present prices (orange) for various car models.
For almost all models, the sum of present prices is higher than the sum of selling prices, which makes sense because cars depreciate in value over time.
Certain models show significant gaps between the present price and the selling price, indicating vehicles that retain their value better than others.
Some models, particularly well-known ones, show higher selling prices, which might suggest higher demand in the second-hand market.
If there are models where the selling price is close to the present price, it could indicate that these models are either newer (not much depreciation yet) or have strong resale value.

This chart compares the total selling price of Diesel, Petrol, and CNG cars in the dataset.
Petrol cars have the highest total selling price, followed by Diesel cars, with CNG cars having a negligible total selling price.
This could indicate that petrol cars dominate the dataset, either due to higher availability or greater demand in the second-hand market.
Diesel cars, despite having lower total selling prices than petrol, still hold significant value, suggesting they are also widely traded.
The low total selling price of CNG vehicles could mean either that there are fewer CNG vehicles in the dataset or that CNG cars depreciate more quickly than their petrol/diesel counterparts.

Most cars experience a significant drop in value from their present price to their selling price, highlighting depreciation as a key factor in second-hand car transactions.
Certain car models retain their value better than others, making them better investments in the used car market.

Petrol cars seem to dominate the market in terms of selling price, potentially due to greater availability or preference among buyers.
Diesel cars also hold considerable resale value, likely due to their fuel efficiency and durability.
CNG cars have low representation, which may suggest a niche market or lower resale demand.

The top left chart shows that certain years have a much higher cumulative mileage. This could indicate that the second-hand market sees more transactions of older, high-mileage vehicles during those years.
If high-mileage cars are frequently resold, it could indicate that buyers in the used car market are willing to compromise on mileage in exchange for lower prices.

If choosing between different fuel types, petrol cars might be the safest investment due to their strong resale presence.
Some specific models appear to retain their value better, making them good choices for resale.