Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra and Its Applications

Authors: Gilbert Strang

4th edition

30105678, 30105676, 978-0030105678

More Books

Students also viewed these Mathematics questions