Car Sales Analysis

Executive Summary

This presentation provides:

🚗 Analysis of UK car sales data (2023-2024)

📊 Popularity, price, and unit sales/revenue

🚀 Recommendations for increasing revenue:

  1. Investigate sales in Bath
  2. Sell Jeep, RAM, Dodge, Mazda, Chevrolet models
  3. Start marketing campaign during Q1 (March)

Popularity & Price

💵 Most Expensive Mazda Car Sold

The most expensive Mazda car sold was a: 

2024 Mazda CX-90 PHEV Base.

Sold for £60200.0.

Purchased in Southampton.

Purchased on 2023-10-22.

🚗💚 Green Cars Sold by City

Number of green cars sold in each city from 2023-10-13 to 2024-02-02:

 rank        city  count
    1  Nottingham    287
    2 Southampton    272
    3     Bristol    167
    4   Liverpool    128
    5  Manchester     77

Average Car Price by City

Average price for cars in each city: 

 rank        city  average_price
    1  Nottingham       63240.21
    2  Manchester       61281.54
    3        Bath       61264.52
    4     Bristol       60959.20
    5  Birmingham       58456.43
    6   Liverpool       57768.45
    7 Southampton       57110.31

Price and Discount

The relationship between price and discount given appears linear and positive, so as price increases, the discount increases.

There seem to be 12 relatively distinct lines, which might be worth further investigation.

Price and Discount (Chart)

Unit Sales and Revenue

The following plots show a difference, which might be statistically significant, between unit sales and revenues between Bath, and other cities, with Bath having higher sales/revenues.

Unit Sales and Revenue (Chart)

Total Unit Sales

Total Revenue

Recommendations for Growing Revenue

Recommendation 1: Investigate Sales in Bath

Car sales in Bath are dramatically higher than other cities.

Recommendation 1: Investigate Sales in Bath (Chart)

Recommendation 1: Investigate Sales in Bath

The total sales in Bath is £678034.

The average sales in other cities is £220327.67

The difference is £457706.33

Recommendation 1: Investigate Sales in Bath (Chart)

The city with the lowest approximate population - Bath - has got the highest total revenue, probably due to having much higher total sales.

Total Car Sales by City (Map)

Total Car Sales by City

Recommendation 2: Makes and Models

Sell Jeep, RAM, Dodge, Mazda, Chevrolet models.

Sell the vehicles with the top 3 revenue:

  1. RAM 3500
  2. Jeep Grand Cherokee 4xe
  3. Mazda CX-90 PHEV
Top 10 vehicles providing the best revenue:

 rank      make              model  total_revenue
    1       RAM               3500   1.290089e+10
    2      Jeep Grand Cherokee 4xe   5.456865e+09
    3     Mazda         CX-90 PHEV   5.285632e+09
    4      Jeep           Wagoneer   4.337264e+09
    5     Dodge             Hornet   4.112463e+09
    6     Dodge            Durango   3.859909e+09
    7 Chevrolet     Silverado 1500   3.806809e+09
    8      Jeep   Grand Cherokee L   3.643796e+09
    9      Jeep         Wagoneer L   3.643266e+09
   10      Jeep       Wrangler 4xe   3.424804e+09

Recommendation 3: Marketing Campaign

Start marketing campaign during seasonal spikes (e.g. March, Q1).

Feedback

To give feedback on the presentation, get in touch!

Click here to view the code and get in touch