Question
Part B (40%) - Data Exploration and Cleaning Use the provided dataset to answer this section. You are given access to 24 variables that are
Part B (40%) - Data Exploration and Cleaning Use the provided dataset to answer this section. You are given access to 24 variables that are directly related to used car sales from the above-mentioned dataset. Most of these variables are similar to the type of information that an assessor will use to evaluate and assess the price of a used car (e.g., when was it made? What is the length and width of the car? What type of wheel system? Number of seats?). You need to answer the following questions with evidence and justifications.
4. b. What are the methods of handling missing values?
c. Apply the 3 methods of handling missing values in R and demonstrate the output (summary statistics and transformation plot) for each method in (4-a). (hint: the objective is to identify the impact of using each of the methods you mentioned in 4-a on the summary statistics output above). Which method of handling missing values is most suitable for this data set? Discuss briefly referring to the data set.
Variables are:
Data description 1. price: selling price of the car. 2. back_legroom: Legroom in the rear seat in inches. 3. body_type: Body Type of the vehicle. Like Convertible, Hatchback, Sedan, etc. 4. city_fuel_economy: Fuel economy in city traffic in km per litre. 5. condition: Condition of the car, e.g., excellent, good, fair. 6. daysonmarket: Days since the vehicle was first listed on the market. 7. engine_cylinders: Engine configuration with number of cylinders. 8. engine_displacement: the measure of the cylinder volume swept by all of the pistons of a piston engine, excluding the combustion chambers. 9. Front_legroom: Legroom in the front seat in inches. 10. fuel_tank_volume: Fuel tank's filling capacity in gallons. 11. fuel_type: Dominant type of fuel ingested by the vehicle. 12. height: Height of the vehicle in inches. 13. highway_fuel_economy: Fuel economy in highway traffic in km per litre. 14. horsepower: Horsepower is the power produced by an engine. 15. length: Length of the vehicle in inches. 16. make_name: name of the car model maker. 17. maximum_seating: Maximum seats in the vehicle. 18. mileage: The distance traveled of the vehicle in km. 19. owner_count: Number of owners the vehicle had previously. 20. salvage: whether the car has a salvage title. 21. transmission: type of transmission. E.g., manual, automatic, etc. 22. wheel_system: wheel system of the vehicle. E.g., all wheel drive, etc. 23. wheelbase: length of wheel base in inches. 24. width: width of the car in inches. 25. year: year the car was made
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started