2025-10-31

The Dataset

This project uses the BMW_Sales_Data_2010–2024 dataset from kaggle.

The dataset contains information on the BMW car sales from 2010 to 2024 across multiple global regions.

It includes 10 columns which are:

Model, Year, Region, Color, Fuel Type, Transmission, Engine Size (L), Mileage (KM), and Price (USD).

This dataset allows us to analyze trends in pricing, sales, and fuel, with all of BMW’s models as well as their sales in across regions.

Brief Overview

We will explore this dataset using multiple visualizations to uncover sales trends and insights.

The project layout includes:

Bar Graph: Average car prices among the top 10 models sold in 2024.

Scatter Plot: Relationship between mileage and price for the top-selling models.

Box Plot: Comparison of price distributions across different regions.

3D Scatter Plot: Connection between engine size, mileage, and price for BMW models in North America.

Pie Charts: Distribution of car colors for the top 3 BMW models in 2024.

Bar Graph: Average Price by Model (Top 10 Models in 2024)

This bar graph displays the average car price (USD) for the top 10 BMW models sold in 2024. Each bar represents a model, with taller bars indicating higher average sale prices. We want to look at the more popular models and see the trends. We can see that 3 series is the most expensive car in the 2024 bestselling vehicles.

Box Plot: Price Distribution by Fuel Type

This box plot compares the price distributions of BMW vehicles across different fuel types (Petrol, Diesel, Hybrid, and Electric). Each box represents the spread and median price for each category. The plot shows how electric and hybrid models have a higher price range, while diesel models are to be more consistent and medium. We can also see that it is more expensive in North America and Asia.

Scatter Plot: Price vs Mileage (Top 5 Models in 2024)

This scatter plot shows the relationship between mileage and price for the top 10 BMW models sold in 2024. Each point represents a vehicle, with its position showing mileage and price. The color indicates the model.We can see that the 5 series gives the most bang for your buck in terms of mileage and price. The worst is the X3 because it is very expensive and doesn’t give that good of mileage.

3D Plot: Engine Size, Mileage, and Price (North America, 2024)

This interactive 3D scatter plot visualizes Engine Size (L), Mileage (KM), and Price (USD) for BMW cars sold in North America in 2024. Each point’s color represents a specific model. We can see a trend of how the SUV’s are the best option in terms of a lot of mileage for an affordable price. Unfortunately this does not have any correlation with the engine size.

Pie Charts: Color Distribution of Top 3 BMW Models (2024)

These pie charts display the color distribution of the top 3 BMW models sold in 2024. Each chart represents one model, divided by color, with segment size showing how common each color is. The combination of all three pie charts shows consumer color preferences across different vehicle types. White and black are the most popular, while blue and red are popular choices for specific sporty or luxury models.

Statistical analysis

This 5-number summary provides insight into the distribution of prices across the top BMW models. The results show that the X5 has the highest median price, which means that it is one of the more expensive models, while the 3 Series and i8 have lower median prices. The M5 and X5 both have large interquartile ranges, which indicates a greater price variability within those models. Models like the i3 and 7 Series show more consistent pricing, which is shown by their smaller IQRs. Overall, the data indicates that SUV and performance models tend to have higher price ranges, while sedans and electric models are slightly more stable and lower on average.

## # A tibble: 10 × 6
##    Model      Min     Q1 Median     Q3    Max
##    <chr>    <int>  <dbl>  <dbl>  <dbl>  <int>
##  1 3 Series 31315 56958. 77858. 96599. 119881
##  2 5 Series 30155 52654. 76281  97670  119963
##  3 7 Series 30326 53258. 78892. 98922  119926
##  4 M5       30098 49727  71051  93825  119773
##  5 X1       30236 53049. 77714. 97184. 119769
##  6 X3       30054 52597  78872  99424. 119691
##  7 X5       30447 51776  73424  94217  119416
##  8 X6       30096 51488  75784  99228  119818
##  9 i3       30067 51192. 72388  94678. 118989
## 10 i8       30072 55972. 77016. 98218. 119997