Madonna-22/Car-Sales-Data-Analysis

This project provides a glimpse into Nigeria's car market, revealing typical car features (mileage, engine size, horsepower) and customer preferences (popular makes, colors etc). Key findings include Toyota's dominance, preference for black cars, and valuable insights for car dealers and manufacturers to inform business strategies. # Nigeria-Car-Sales-Data-Analysis # Project Overview This project summarises the insights from the analysis of Nigeria car sales data. The dataset encompasses details such as the make, model, colour, amount, mileage, engine size, transmission etc. The key insights showed that Toyota is the most popular car make, and the average car price is 5 million naira. # Dataset Overview and Structure Source: kaggle; Nigeria Car Sales Dataset. Scope: the dataset has 2,895 rows and 23 columns, covering car description, amount, condition, mileage, engine size, horse power etc # Tool Excel: Used for data cleaning, analysis and dashboard creation. # Methodology 1.data cleaning/preparation 2. Exploratory data analysis: This was done to answer the following questions: - what is the average car price, mileage, horse power and engine size? - which car make sold the most? - what car colour is the most purchased? - which state has the highest car sales (top-selling state), and which one has the lowest ? - which car types are sold more? Automatic or manual? # Insights: 1. The average cost of a car 🚗 is ₦5 million. 2. The average distance Nigerian used cars has been driven (mileage) is 28,000 kilometres (km). (Note: A higher mileage typically suggests more use and potential wear on the vehicle's components, while lower mileage might indicate less wear and tear. Generally, a car with lower mileage tends to have a higher resale value.) 3. The average horsepower (the rate at which the engine can do work) is 217 hp. A good horse power range for a car is around 150 - 250 hp. 4. The average engine size is 3,100 cubic centimetres (cc). 5. The most popular car make used/owned is Toyota, followed by Honda, then Lexus. 6. The most popular car colour is Black ◼️, followed by Grey, then silver. 7. Most drivers/car owners (94%) prefer automatic transmission cars. This might be because it's more convenient and less stressful to drive (it doesn't involve clutch and gear shifting). 8. Lagos s …