Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

below Question , Need a support for step by step actual working detail rather than giving hint . please help on this The variable definitions

below Question ,Need a support for step by step actual working detail rather than giving hint . please help on this
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
'
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. 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:
0
5
)
d
.
How do I build the model and what are the list of explanatory variables for the model?
(
CLO
-
2
,
PLO
-
2
,
Marks:
0
5
)
Above all Questions use only Rstudio based solution Ad ID Car Name Make Model Year KM
'
s driven Price Fuel Registration city Car documents Assembly Transmission Condition Seller Location Description Car Features
1
0
7
9
0
7
1
5
7
1
fresh import Passo
2
0
2
1
model Toyota Passo
2
0
2
1
5
4
0
0
0
4
1
9
0
0
0
0
Petrol Unregistered Original Imported Automatic Used Airline Avenue, Islamabad it's
2
0
2
1
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
1
0
8
0
1
2
5
5
2
0
Suzuki ravi Suzuki Ravi
2
0
1
8
9
5
0
0
0
1
3
0
0
0
0
0
Petrol Karachi Original Local Manual Used Kahuta, Rawalpindi Suzuki ravi
2
0
1
8
col AM
/
FM Radio
1
0
8
0
7
4
8
7
8
9
Suzuki bolan
2
0
1
5
contact
0
3
1
1
2
2
7
1
0
5
4
Suzuki Bolan
2
0
1
5
5
0
0
0
0
8
0
0
0
0
0
Petrol Karachi Original Local Manual Used Lyari Expressway, Karachi Suzuki bolan model
2
0
1
5
reg
2
0
2
2
ghadi me koi Kam nai a Rear speakers
1
0
7
6
0
8
1
6
3
5
Diahatsu Move
2
0
1
3
Daihatsu Move
2
0
1
3
9
4
0
0
0
2
1
5
5
0
0
0
Petrol Lahore Original Imported Automatic Used New Amir Town, Lahore "Move Push start
Home Used car.
Model
2
0
1
3
.
Registered in
2
0
1
5
.
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
1
0
8
0
8
1
2
9
2
8
Suzuki Swift DLX
2
0
1
1
miner tuchap Suzuki Swift
2
0
1
1
1
2
6
5
4
4
1
4
4
0
0
0
0
Petrol Karachi Original Local Manual Used Shadman
2
,
Karachi "Suzuki Swift DLX
AbS Break
1
0
0
%
engine
1
0
0
%
suspension
1
0
0
%
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
1
0
7
9
4
9
6
8
2
3
WagonR AGS total genuine Suzuki Wagon R
2
0
2
0
5
4
0
0
0
2
8
3
0
0
0
0
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
1
0
8
0
3
3
3
4
2
6
Daihatsu Mira Daihatsu Mira
2
0
1
3
1
4
0
0
0
0
2
1
5
0
0
0
0
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
1
0
8
0
7
8
4
7
5
8
Suzuki Bolan
2
0
1
6
genuine condition low mileage Suzuki Bolan
2
0
1
6
3
2
0
0
0
1
0
5
0
0
0
0
Petrol Karachi Original Local Manual Used Korangi Industrial Area, Karachi SUZUKI BOLANSuzuki Bolan
2
0
1
6
genuine con

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

Guide To Client Server Databases

Authors: Joe Salemi

2nd Edition

1562763105, 978-1562763107

More Books

Students also viewed these Databases questions

Question

Persuading Your Audience Strategies for

Answered: 1 week ago