Answer Happy

A local car software company, JM inc., is looking for data scientists to help them understand the ossible patterns that will affect the car resale prices. Current ly the company plans to build an pplication (app) for the used cars that are sold/purchased across the country. The company is terested in estimating the sale price of cars for the app users. Such an app will help the company o attract investor for potential projects. The company has provided the relevant data that they ave collected over the years. Following table presents an overview of the collected data: Fields Manufacturer Type Cylinders Model Year Model Price Sold Year Sale Price KM Driven KPL Power Class Location Accident _History Owner _History Color Seller _Type Service History Table 1: Data Description Description Cars's manufacturer. Type of the car. The car could be sedan, crossover or SUV. Total number of cylinders in the car's engine. The year of the car was manufactured. Sale Price of the car in Model - Year' in SAR. The year in which the car was sold. Sale Price of the car in 'Sold-Year' in SAR. Total Kilometers the car is driven before the sale in km units. Estimated kilometers per liter at the time of sale in kpl units. Four wheel drive (4WD), or two wheel drive (2WD). Standard or Premium features available on the car. City in which the car was sold, 'Riyadh', 'Dammam', 'Jeddah', 'Dhahran', 'Makka h', 'Madinah'. 1 Total number of major accidents reported on car's history. Total number of owners of the car, The color of the car. Whether the seller is an individual or a company. It either 0 or 1, where l indicates the service history from the car's authorized dealer is available. * 100 Aim. The aim of this project is to explore the data, and find possible patterns/relationships 1 the data. The key variable of interest to JMI inc. is Sale _Price. Assume that the cars that epreciate by 10% or less are high return cars, and those that depreciate by 20% or more are low eturn cars. The depreciation is defined as: [Model_Price] – [Sale_Price] ([Sold_Year] – [Model_Year)[Model_Price] Data. The data related to the project is provided in three different files, named in the following ormat: Group _SS_XX_A, Group_SS_XX_B and Group_SS_XX_C files, where SS is your ection number and XX is your group number. In addition to that, Table 1 presents the meta ata related to the given data. Expectations. At the end of this project, you are expected to provide JML with answers to the Ollowing questions. Support your answers with corresponding/appropriate data science methods nd visualizations (wherever applicable).

For the following task use Group_SS_XX_B file:

Task-5: What are the common patterns for the low return cars? Use plots to just ify. Task-6: What are the common patterns for the high return cars? Use plots to justify.

Manufactu Type Mercetes suv Toyoda sedan Toyoda suv Mercetes sedan Nesshan suv Huendae sedan Honta suv Wolksvage sedan Shevy suv BeEmW suv Masda suv Mercetes suv BeEmW suv JournalMa suv Cylinders Model_Ye: Model_Pri Sold_Year Sale_Price KM_Driver KPL Power 4 1997 137,787 SA 2000 82,072 SAF 148417 5.46 2WD 6 2004 108,530 SA 2008 69,955 SAF 80349 13.8 4WD 4 1998 103,255 Si 2006 32,060 SAF 70663 13.89 4WD 4 1997 65,612 SAF 2000 37,024 SAF 29174 10.13 2WD 6 2001 106,532 SA 2004 73,826 SAP 55871 7.9 2WD 4 4 2003 52,779 SAF 2008 30,258 SAF 52744 14.46 2WD 4 1998 100,387 SA 1999 88,541 SAF 22547 13.35 2WD 4 2006 67,211 SAF 2012 34,781 SAF 76858 13.85 2WD 4 2006 141,144 SA 2008 88,095 SAF 41937 6.22 4WD 4 1997 98,419 SAF 2000 55,537 SAF 49860 5.92 2WD 4 2001 76,094 SAF 2009 19,415 SAF 415218 11.25 2WD 4 2002 108,662 SA 2006 54,814 SAF 80515 7.37 2WD 4 1996 115,787 SA 2002 54,861 SAF 218137 4.25 4WD 6 2002 152,128 SA 2005 100,153 SA 63856 3.84 2WD Class Location Accident_1 Owner_His Color premium Madinah 1 2 Black premium Jeddah 0 4 Gray standard Riyadh 4 1 White standard Dammam 5 2 Gray premium Madinah 2 2 Gray standard Jeddah 3 2 Gray premium Jeddah 2. 2 Red standard Jeddah 8 1 Silver standard Dhahran 6 3 Black standard Makkah 6 1 White standard Riyadh 5 1 Silver standard Dhahran 12 1 Gray standard Dammam 1 1 White premium Madinah 0 2 Gray Seller_Typ Service_Hist individual 0 individual 0 0 individual 0 0 individual 0 0 individual 0 0 individual 1 1 individual 1 individual 0 individual 0 0 individual 0 individual 0 0 individual 0 company 1 individual 1