Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The variable definitions are provided below: VAR DEFINITION Ad ID SERIAL NUMBER Car Name NAME - SUBJECTIVE Make CAR COMPANY Model CAR NAME Year YEAR
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
KMs 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
a Perform a clustering on the Data. CLO PLO Marks:
b How many clusters do you think the data has? CLO PLO Marks:
c What are the cluster characteristics? CLO PLO Marks:
Question a Develop a predictive model that predicts the price of the car quoted in the platform? CLO PLO Marks:
b What is the RSquare and Adjusted RSquare of the Model? CLO PLO Marks:
c Suppose I want to rephrase the above problem as predicting the price for an Expensive vs nonexpensive car. How do I change the model specification and how would I define the cutoff and why? CLO PLO Marks:
d How do I build the model and what are the list of explanatory variables for the model? CLO PLO Marks: Ad ID Car Name Make Model Year KMs driven Price Fuel Registration city Car documents Assembly Transmission Condition Seller Location Description Car Features
fresh import Passo model Toyota Passo Petrol Unregistered Original Imported Automatic Used Airline Avenue, Islamabad it's model fresh import, perfect engine suspension,non accidented,push start fully loaded car,need to sell urgently. ABS, Air Bags, AMFM 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
Suzuki ravi Suzuki Ravi Petrol Karachi Original Local Manual Used Kahuta, Rawalpindi Suzuki ravi col AMFM Radio
Suzuki bolan contact Suzuki Bolan Petrol Karachi Original Local Manual Used Lyari Expressway, Karachi Suzuki bolan model reg ghadi me koi Kam nai a Rear speakers
Diahatsu Move Daihatsu Move Petrol Lahore Original Imported Automatic Used New Amir Town, Lahore "Move Push start
Home Used car.
Model
Registered in
All origina documents with smart card.
Total Geniune few touch ups.
Never been into any major accident." ABS, Air Bags, Air Conditioning, Alloy Rims, AMFM Radio, CD Player, Immobilizer Key, Keyless Entry, Power Locks, Power Mirrors, Power Steering, Power Windows
Suzuki Swift DLX miner tuchap Suzuki Swift Petrol Karachi Original Local Manual Used Shadman Karachi "Suzuki Swift DLX
AbS Break
engine
suspension
Android panel
brand new tyer
piece Touchups
all documents clear
cplc Clear
no work required
contact no: ABS, Air Conditioning, Alloy Rims, AMFM Radio, Power Locks, Power Mirrors, Power Steering, Power Windows
WagonR AGS total genuine Suzuki Wagon R Petrol Lahore Original Local Automatic Used Abbot Road, Sialkot wagon r total genuine AGS new tyre ABS, Air Bags, Alloy Rims, AMFM Radio, CD Player, DVD Player, Power Mirrors, Power Steering, Power Windows, Rear AC Vents, USB and Auxillary Cable
Daihatsu Mira Daihatsu Mira 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, AMFM Radio, CD Player, Front Speakers, Power Locks, Power Steering, Power Windows, USB and Auxillary Cable
Suzuki Bolan genuine condition low mileage Suzuki Bolan Petrol Karachi Original Local Manual Used Korangi Industrial Area, Karachi SUZUKI BOLANSuzuki Bolan genuine condition low mileage Alloy Rims, AMFM Radio
Honda City Honda City IDSI 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
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