The variable definitions are provided below:

VAR

DEFINITION

Ad ID

SERIAL NUMBER

Car Name

NAME $-$ SUBJECTIVE

Make

CAR COMPANY

Model

CAR NAME

Year

YEAR OF MAKE

KM$\text{'}$s driven

SELF EXPLANATORY

Price

PRICE QUOTED IN THE PLATFORM

Fuel

SELF EXPLANATORY

Registration city

SELF EXPLANATORY

Car documents

SELF EXPLANATORY

Assembly

LOCAL vs IMPORTED

Transmission

SELF EXPLANATORY

Condition

SELF EXPLANATORY

Seller Location

SELF EXPLANATORY

Description

SUBJECTIVE

Car Features

SUBJECTIVE

Please Note: $-$

There is lot subjective information in the file which can act as important explanatory variables in your model. Understand the data and clean the data and convert them to suitable numerical variables.

Question $1$

a$.$ Perform a clustering on the Data. $($CLO$-1,$ PLO$-1,$ Marks: $05)$

b$.$ How many clusters do you think the data has? $($CLO$-2,$ PLO$-2,$ Marks: $05)$

c$.$ What are the cluster characteristics? $($CLO$-1,$ PLO$-1,$ Marks: $05)$

Question $2-$ a$.$ Develop a predictive model that predicts the price of the car quoted in the platform? $($CLO$-1,$ PLO$-1,$ Marks: $05)$

b$.$ What is the R$-$Square and Adjusted R$-$Square of the Model? $($CLO$-2,$ PLO$-2,$ Marks: $05)$

c$.$ Suppose I want to re$-$phrase the above problem as predicting the price for an $$Expensive$$ vs $$non$-$expensive$$ car. How do I change the model specification and how would I define the cut$-$off and why? $($CLO$-2,$ PLO$-2,$ Marks: $05)$

d$.$ How do I build the model and what are the list of explanatory variables for the model? $($CLO$-2,$ PLO$-2,$ Marks: $05)$Ad ID Car Name Make Model Year KM$\text{'}$s driven Price Fuel Registration city Car documents Assembly Transmission Condition Seller Location Description Car Features

$1079071571$ fresh import Passo $2021$model Toyota Passo $2021540004190000$ Petrol Unregistered Original Imported Automatic Used Airline Avenue, Islamabad it's $2021$ model fresh import, perfect engine suspension,non accidented,push start $,$fully loaded car,need to sell urgently. ABS, Air Bags, AM$/$FM Radio, CD Player, Cassette Player, Climate Control, DVD Player, Front Speakers, Front Camera, Immobilizer Key, Keyless Entry, Navigation System, Power Locks, Power Mirrors, Power Steering, Power Windows, Rear speakers, Rear Camera

$1080125520$ Suzuki ravi Suzuki Ravi $2018950001300000$ Petrol Karachi Original Local Manual Used Kahuta, Rawalpindi Suzuki ravi $2018$ col AM$/$FM Radio

$1080748789$ Suzuki bolan $2015$ contact $03112271054$ Suzuki Bolan $201550000800000$ Petrol Karachi Original Local Manual Used Lyari Expressway, Karachi Suzuki bolan model $2015$ reg $2022$ ghadi me koi Kam nai a Rear speakers

$1076081635$ Diahatsu Move $2013$ Daihatsu Move $2013940002155000$ Petrol Lahore Original Imported Automatic Used New Amir Town, Lahore "Move Push start

Home Used car.

Model $2013.$

Registered in $2015.$

All origina documents with smart card.

Total Geniune few touch ups.

Never been into any major accident." ABS, Air Bags, Air Conditioning, Alloy Rims, AM$/$FM Radio, CD Player, Immobilizer Key, Keyless Entry, Power Locks, Power Mirrors, Power Steering, Power Windows

$1080812928$ Suzuki Swift DLX $2011$ miner tuchap Suzuki Swift $20111265441440000$ Petrol Karachi Original Local Manual Used Shadman $2,$ Karachi "Suzuki Swift DLX

AbS Break $100\%$

engine $100\%$

suspension $100\%$

Android panel

brand new tyer

$2/3$ piece Touchups

all documents clear

cplc Clear

no work required

contact no:$0/3/3/2/3/0/9/6/0/7/1"$ ABS, Air Conditioning, Alloy Rims, AM$/$FM Radio, Power Locks, Power Mirrors, Power Steering, Power Windows

$1079496823$ WagonR AGS total genuine Suzuki Wagon R $2020540002830000$ Petrol Lahore Original Local Automatic Used Abbot Road, Sialkot wagon r total genuine AGS new tyre ABS, Air Bags, Alloy Rims, AM$/$FM Radio, CD Player, DVD Player, Power Mirrors, Power Steering, Power Windows, Rear AC Vents, USB and Auxillary Cable

$1080333426$ Daihatsu Mira Daihatsu Mira $20131400002150000$ Petrol Karachi Original Imported Automatic Used North Nazimabad $-$ Block A$,$ Karachi bilkul okay condition me hen engine change hen recently change karvaya hen book pe update nhe ha ABS, Air Bags, Air Conditioning, AM$/$FM Radio, CD Player, Front Speakers, Power Locks, Power Steering, Power Windows, USB and Auxillary Cable

$1080784758$ Suzuki Bolan $2016$ genuine condition low mileage Suzuki Bolan $2016320001050000$ Petrol Karachi Original Local Manual Used Korangi Industrial Area, Karachi SUZUKI BOLANSuzuki Bolan $2016$ genuine condition low mileage Alloy Rims, AM$/$FM Radio

$10764486252004$ Honda City Honda City IDSI $20041600001230000$ Petrol Sindh Original Local Manual Used Allama Iqbal Town $-$ Huma Block, Lahore "A very well maintained $-$ Good consumption

no mechanical work, Excellent condition

complete $,$Engine perfect orginal condition car. $.$

just buy and drive daily driven smooth car

original condition Registered In Personal Name

Neat and clean interior $-$ Each and every thing is mentioned

only contact for serious buyers $-$

No silly offers good fuel average

Very good Co