Car Marketing Report

In this project, I analyzed car market data from the year 2000 to 2023, focusing on three key aspects: **prices**, **brands**, and **fuel types**. The goal of the analysis was to understand the main trends in the car market and provide strategic recommendations for consumers and professionals in the automotive industry.

1. Data Collection:

Data was imported from a file containing information on car prices, brands, fuel types (petrol, diesel, electric, hybrid), and mileage.

2. Data Cleaning

I cleaned the data to ensure its accuracy and completeness, including removing missing or incorrect values and standardizing formats to ensure data quality before analysis.

3. Data Analysis

Using **Pivot Tables** and **Line Charts** in Excel, I analyzed the data to extract the following insights:

- Price Analysis by Year:

The average car prices were calculated for each year from 2000 to 2023. It was observed that prices gradually increased over the years, with slight drops in certain years such as 2023, 2021, 2008, and 2004.

- Price Analysis by Fuel Type:

Electric cars were found to be the most expensive compared to petrol or diesel cars.

- Price and Mileage Relationship

It was observed that cars with lower mileage tend to be more expensive, reflecting higher demand in the market.

- Price Analysis by Brand and Fuel Type

Average prices were analyzed for different brands according to fuel types (diesel, electric, hybrid, petrol).

4. Data Visualization

Line charts were created to illustrate trends in car prices over the years, as well as charts showing the relationship between price and mileage.

5. Analysis Report

I wrote a detailed report summarizing the key findings and providing strategic recommendations based on the data. The recommendations included:

- For Consumers

If you are considering purchasing a new car, electric cars may be a better option despite their higher price, as they offer lower maintenance costs in the long run.

- For Automotive Professionals

This data can be used to understand future market trends, such as the increasing demand for electric vehicles, and adjust pricing strategies accordingly.

6. Conclusion:

The report provided a comprehensive overview of car price trends, the impact of fuel types on pricing, and the relationship between price and mileage. These insights help in making informed decisions for both consumers and companies operating in the automotive sector.