Analyzing the Relationship between the prices of the car with other variables.
Initial Analysis of the Project
Dataset contains 9576 rows and 10 variables with essential meanings:
car: manufacturer brand
price: seller’s price in advertisement (in USD)
body: car body type
mileage: as mentioned in advertisement (’000 Km)
engV: rounded engine volume (’000 cubic cm)
engType: type of fuel (“Other” in this case should be treated as NA)
registration: whether car registered in Ukraine or not
year: year of production
model: specific model name
drive: drive type
Aim: To analyse the dependence of the price of the car on various facrs( like mileage, engV, year of production)
Reading the dataset into R
car <- read.csv(paste("car_ad.csv", sep=""))
View(car)
visualizing the length and breadth of your dataset
Length
dim(car)[1]
## [1] 9576
Breadth
dim(car)[2]
## [1] 10
str(car)
## 'data.frame': 9576 obs. of 10 variables:
## $ car : Factor w/ 87 levels "Acura","Alfa Romeo",..: 28 53 53 53 53 60 35 65 53 53 ...
## $ price : num 15500 20500 35000 17800 33000 16600 6500 10500 21500 22700 ...
## $ body : Factor w/ 6 levels "crossover","hatch",..: 1 4 3 6 5 1 4 5 4 4 ...
## $ mileage : int 68 173 135 162 91 83 199 185 146 125 ...
## $ engV : num 2.5 1.8 5.5 1.8 NA 2 2 1.5 1.8 2.2 ...
## $ engType : Factor w/ 4 levels "Diesel","Gas",..: 2 2 4 1 3 4 4 1 2 1 ...
## $ registration: Factor w/ 2 levels "no","yes": 2 2 2 2 2 2 2 2 2 2 ...
## $ year : int 2010 2011 2008 2012 2013 2013 2003 2011 2012 2010 ...
## $ model : Factor w/ 888 levels "1 Series","1.3",..: 504 337 273 213 337 861 182 559 337 337 ...
## $ drive : Factor w/ 4 levels "","front","full",..: 3 4 4 2 1 3 2 2 4 4 ...
summary(car)
## car price body mileage
## Volkswagen : 936 Min. : 0 crossover:2069 Min. : 0.0
## Mercedes-Benz: 921 1st Qu.: 4999 hatch :1252 1st Qu.: 70.0
## BMW : 694 Median : 9200 other : 838 Median :128.0
## Toyota : 541 Mean : 15633 sedan :3646 Mean :138.9
## VAZ : 489 3rd Qu.: 16700 vagon : 722 3rd Qu.:194.0
## Renault : 469 Max. :547800 van :1049 Max. :999.0
## (Other) :5526
## engV engType registration year
## Min. : 0.100 Diesel:3013 no : 561 Min. :1953
## 1st Qu.: 1.600 Gas :1722 yes:9015 1st Qu.:2004
## Median : 2.000 Other : 462 Median :2008
## Mean : 2.646 Petrol:4379 Mean :2007
## 3rd Qu.: 2.500 3rd Qu.:2012
## Max. :99.990 Max. :2016
## NA's :434
## model drive
## E-Class : 199 : 511
## A6 : 172 front:5188
## Camry : 134 full :2500
## Vito ïàññ.: 131 rear :1377
## Lanos : 127
## X5 : 119
## (Other) :8694
library(psych)
describe(car)
## vars n mean sd median trimmed mad min
## car* 1 9576 51.09 25.63 53.0 52.65 34.10 1.0
## price 2 9576 15633.32 24106.52 9200.0 10981.42 7709.52 0.0
## body* 3 9576 3.30 1.60 4.0 3.25 1.48 1.0
## mileage 4 9576 138.86 98.63 128.0 131.20 91.92 0.0
## engV 5 9142 2.65 5.93 2.0 2.10 0.74 0.1
## engType* 6 9576 2.65 1.33 3.0 2.69 1.48 1.0
## registration* 7 9576 1.94 0.23 2.0 2.00 0.00 1.0
## year 8 9576 2006.61 7.07 2008.0 2007.52 5.93 1953.0
## model* 9 9576 455.45 255.42 486.5 456.62 328.40 1.0
## drive* 10 9576 2.50 0.80 2.0 2.44 0.00 1.0
## max range skew kurtosis se
## car* 87.00 86.00 -0.42 -1.04 0.26
## price 547800.00 547800.00 7.13 93.67 246.34
## body* 6.00 5.00 -0.06 -1.05 0.02
## mileage 999.00 999.00 1.30 5.15 1.01
## engV 99.99 99.89 15.18 239.61 0.06
## engType* 4.00 3.00 -0.14 -1.76 0.01
## registration* 2.00 1.00 -3.76 12.13 0.00
## year 2016.00 63.00 -1.55 3.87 0.07
## model* 888.00 887.00 -0.03 -1.18 2.61
## drive* 4.00 3.00 0.54 -0.46 0.01
Descriptive Statistics for price
summary(car$price)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0 4999 9200 15633 16700 547800
Descriptive Statistics for mileage
summary(car$mileage)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.0 70.0 128.0 138.9 194.0 999.0
Descriptive Statistics for engV
summary(car$mileage)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.0 70.0 128.0 138.9 194.0 999.0
3)To create one-way contingency tables for the categorical variables in the dataset.
one-way contingency table for car variable
table(car$car)
##
## Acura Alfa Romeo Aro Aston Martin Audi
## 13 11 1 3 457
## Barkas Bentley BMW Bogdan Buick
## 1 16 694 2 1
## BYD Cadillac Changan Chery Chevrolet
## 7 3 1 53 246
## Chrysler Citroen Dacia Dadi Daewoo
## 28 108 12 2 235
## Daihatsu Dodge ËUAZ FAW Ferrari
## 3 16 6 1 2
## Fiat Fisker Ford GAZ Geely
## 119 1 350 34 56
## GMC Great Wall Groz Hafei Honda
## 3 9 2 1 206
## Huanghai Hummer Hyundai Infiniti Isuzu
## 1 5 367 64 2
## JAC Jaguar Jeep Kia Lamborghini
## 2 19 25 215 1
## Lancia Land Rover Lexus Lifan Lincoln
## 3 151 174 4 6
## Maserati Mazda Mercedes-Benz Mercury MG
## 1 198 921 1 4
## MINI Mitsubishi Moskvich-AZLK Moskvich-Izh Nissan
## 15 327 12 5 368
## Opel Other-Retro Peugeot Porsche Renault
## 400 1 182 92 469
## Rolls-Royce Rover Saab Samand Samsung
## 2 4 1 2 1
## Seat Skoda SMA Smart SsangYong
## 39 368 1 57 45
## Subaru Suzuki TATA Tesla Toyota
## 114 58 1 22 541
## UAZ VAZ Volkswagen Volvo Wartburg
## 21 489 936 32 1
## ZAZ ZX
## 102 1
one-way contingency table for body column
table(car$body)
##
## crossover hatch other sedan vagon van
## 2069 1252 838 3646 722 1049
one-way contingency table for engType column
table(car$engType)
##
## Diesel Gas Other Petrol
## 3013 1722 462 4379
one-way contingency table for registration column
table(car$registration)
##
## no yes
## 561 9015
one-way contingency table for model column
table(car$model)
##
## 1 Series 1.3 10
## 1 1 1
## 100 106 107
## 18 1 11
## 11 1102 Òàâðèÿ 1103 Ñëàâóòà
## 1 22 29
## 110557 1117 1118
## 9 2 11
## 1119 116 118
## 9 3 5
## 120 125 1301
## 1 1 1
## 1302 147 156
## 1 1 2
## 159 19 190
## 4 2 8
## 2 200 2008
## 3 7 4
## 205 206 207
## 1 10 11
## 208 21 210
## 5 10 3
## 2101 2102 2103
## 24 3 6
## 2104 2105 2106
## 13 19 32
## 2107 2108 2109
## 46 28 28
## 2109 (Áàëòèêà) 21093 21099
## 1 15 44
## 2110 2111 2112
## 39 18 13
## 2113 2114 2115
## 10 18 28
## 2117 2121 2123
## 1 45 1
## 2140 2141 2170
## 4 5 24
## 2171 2172 2190 Ãðàíòà
## 5 7 1
## 220 230 24
## 2 4 3
## 240 2410 25
## 1 3 3
## 250 2705 GAZåëü 2715
## 1 3 1
## 2717 2752 Ñîáîëü 3
## 3 2 47
## 300 300 C 300 M
## 1 9 1
## 3008 301 306
## 11 4 2
## 307 308 31029
## 15 18 1
## 3110 31105 3151
## 2 5 1
## 31512 31514 316
## 1 1 9
## 3163 318 320
## 1 29 61
## 3221 GAZåëü 32213 323
## 1 1 13
## 324 325 328
## 1 9 8
## 33 330 3302 GAZåëü
## 1 10 2
## 3303 335 340
## 1 2 1
## 350 350Z 3741
## 1 1 1
## 3962 4 Series Gran Coupe 401
## 1 1 1
## 403 405 406
## 1 2 2
## 407 412 428
## 14 1 1
## 452 ïàññ. 458 Italia 469
## 1 1 7
## 469Á 4Runner 5
## 2 1 5
## 5 Series 5 Series GT 500
## 3 3 2
## 500 L 5008 508
## 2 1 4
## 520 523 524
## 80 13 1
## 525 528 530
## 54 17 52
## 535 540 545
## 19 6 1
## 550 6 6 MPS
## 4 64 5
## 6 Series Gran Coupe 605 607
## 1 2 4
## 626 630 640
## 17 3 4
## 645 650 69
## 3 1 2
## 728 730 735
## 1 29 8
## 740 745 75
## 8 6 3
## 750 760 80
## 16 2 15
## 850 9 9-May
## 2 1 1
## 90 911 965
## 1 5 1
## 968 969 Âîëûíü 969Ì
## 3 1 3
## A 140 A 150 A 160
## 3 2 1
## A 170 A 180 A1
## 5 1 3
## A3 A4 A4 Allroad
## 11 58 4
## A5 A6 A6 Allroad
## 16 172 25
## A7 A8 Acadia
## 3 38 1
## Accent Accord Actyon
## 68 90 3
## Actyon Sports Agila Almera
## 1 1 17
## Alpina Altea Altea XL
## 1 1 1
## Altima Amarok Ampera
## 1 4 1
## Amulet Antara Armada
## 16 1 3
## Ascona Astra F Astra G
## 2 9 39
## Astra H Astra J Astro ïàññ.
## 30 10 2
## ASX Auris Aurora
## 7 30 1
## Avalon Avenger Avensis
## 2 2 29
## Aveo Aygo B-Class Electric Drive
## 80 3 5
## B-Max B 170 B 180
## 2 1 7
## B 200 B1000 BDD
## 3 1 1
## Beat Beetle Bentayga
## 1 2 4
## Berlingo ãðóç. Berlingo ïàññ. Besta
## 9 24 1
## Bipper ïàññ. Bluebird Bora
## 1 2 7
## Boxer ãðóç. Boxer ïàññ. Bravo
## 3 2 1
## C-Class C-Elysee C-Max
## 54 3 5
## C1 C3 C3 Picasso
## 5 5 5
## C30 C4 C4 Picasso
## 1 18 2
## C5 Cabrio Caddy
## 4 3 1
## Caddy ãðóç. Caddy ïàññ. Caliber
## 63 55 1
## Calibra California Camaro
## 2 1 9
## Camry Captiva Captur
## 134 11 2
## Caravelle Carens Carina
## 6 5 4
## Carisma Carnival Cayenne
## 7 4 61
## Cayman Ceed Cefiro
## 1 20 1
## Celica Century Cerato
## 2 1 24
## Challenger Cherokee Cinquecento
## 1 2 2
## City Civic CK
## 3 56 6
## CK-2 CK1 CL 180
## 6 2 1
## CL 500 CL 55 AMG CL 550
## 5 3 1
## CL 63 AMG CLA-Class CLA 200
## 3 1 3
## CLA 220 Clarus CLC 180
## 1 3 1
## CLC 200 Clio CLK 200
## 1 7 2
## CLK 220 CLK 230 CLK 240
## 1 2 1
## CLK 280 CLK 320 CLK 430
## 1 3 1
## CLS 350 CLS 400 CLS 500
## 6 1 2
## CLS 63 AMG Cobalt Colt
## 2 1 11
## Combo ãðóç. Combo ïàññ. Compass
## 14 21 1
## Continental Cooper Cooper S
## 9 10 1
## Cordoba Corolla Corolla Verso
## 6 54 1
## Corsa Corvette Countryman
## 10 2 2
## Coupe Courier CR-V
## 5 2 42
## Cross Touran CrossEastar Crossfire
## 1 1 1
## Crosstour Cruze CT
## 1 22 2
## Cuore CX-5 CX-7
## 1 5 26
## CX-9 D-Max Daimler
## 4 1 1
## DB9 Defender Discovery
## 1 2 7
## Discovery Sport Doblo ãðóç. Doblo ïàññ.
## 1 26 29
## Doblo Panorama Dokker ïàññ. DS3
## 2 2 1
## DS4 DS5 Ducato ãðóç.
## 3 2 6
## Ducato ïàññ. Durango Duster
## 2 1 8
## E-Class Eastar Eclipse
## 199 4 2
## Edge Êëàññè÷åñêèå EL
## 1 1 2
## Elantra Elara Elgrand
## 28 2 1
## Emgrand 7 (EC7) Emgrand 8 Emgrand X7
## 18 4 2
## Eos Epica ES 200
## 3 14 1
## ES 300 ES 330 ES 350
## 4 1 15
## Escalade Escort Escort van
## 2 16 1
## Espace Espero Evanda
## 4 3 6
## EX 35 EX 37 Expert ïàññ.
## 1 1 10
## Explorer Express ïàññ. F-150
## 2 4 1
## F-350 F3 F3R
## 1 4 1
## Fabia Felicia Fiesta
## 75 4 49
## Fiorino ãðóç. Fiorino ïàññ. FJ Cruiser
## 2 5 7
## Fluence Flying Spur Focus
## 10 2 62
## Focus Electric Forester Forfour
## 6 48 4
## Fortuner Fortwo Forza
## 1 47 7
## Freelander Frontera Fusion
## 10 3 12
## FX 30 FX 35 FX 37
## 3 25 7
## FX 45 G 320 G 350
## 2 1 6
## G 500 G 55 AMG G 63 AMG
## 11 5 6
## G25 G35 G37
## 4 3 2
## Galant Galaxy Gallardo
## 29 2 1
## Galloper GC6 Genesis
## 1 1 1
## Gentra Getz Giulietta
## 3 28 2
## GL 320 GL 350 GL 420
## 9 12 1
## GL 450 GL 500 GL 550
## 4 2 2
## GLC-Class GLE-Class GLK 220
## 3 18 2
## GLK 300 Gloria GLS 350
## 1 1 24
## GLS 400 GLS 500 GLS 63
## 3 5 6
## Golf GTI Golf II Golf III
## 2 12 19
## Golf IV Golf Plus Golf V
## 26 5 14
## Golf Variant Golf VI Golf VII
## 6 15 11
## Gran Move Granada Grand C4 Picasso
## 1 2 2
## Grand Cherokee Grand Marquis Grand Scenic
## 16 1 15
## Grand Vitara Grand Voyager Grande Punto
## 28 3 3
## Grandeur Grandis GranTurismo
## 4 4 1
## GS 250 GS 300 GS 350
## 1 16 8
## GT-R GX H 100 ïàññ.
## 5 8 1
## H 200 ãðóç. H 200 ïàññ. H1 ãðóç.
## 1 1 2
## H1 ïàññ. H2 H3
## 7 2 3
## Haval Hiace ïàññ. Highlander
## 1 3 14
## Hilux Hover HR-V
## 11 6 1
## i10 i20 I3
## 4 6 2
## i30 Ïàòðèîò Ibiza
## 29 4 11
## Ideal Ïðèîðà Ignis
## 1 1 1
## Impreza Impreza WRX STI Insight
## 12 4 3
## Insignia Intrepid IQ
## 13 1 1
## IS 200 IS 250 IS 300
## 3 3 4
## IX35 ix55 (Veracruz) J2
## 30 4 1
## Jaggi Jazz Jetta
## 3 2 49
## Jimny Juke Juke Nismo
## 2 26 1
## Jumper ãðóç. Jumpy ãðóç. Jumpy ïàññ.
## 2 5 8
## KA Kadett Kangoo ãðóç.
## 1 15 72
## Kangoo ïàññ. Karma Kimo
## 74 1 3
## Kizashi Koleos Korando
## 1 5 10
## Koup Kubistar Kuga
## 3 1 31
## Kyron L 200 L 400 ïàññ.
## 9 12 1
## Lacetti Laguna Lancer
## 64 29 54
## Lancer Evolution Lancer X Lancer X Sportback
## 4 52 1
## Land Cruiser 100 Land Cruiser 105 Land Cruiser 200
## 16 1 48
## Land Cruiser 76 Land Cruiser 80 Land Cruiser Prado
## 1 5 76
## LandMark Lanos Latitude
## 1 127 1
## Leaf Legacy Leganza
## 59 18 2
## Legend Leon LHS
## 2 14 1
## Linea Lite Ace Logan
## 3 1 23
## LS 400 LS 430 LS 460
## 1 1 14
## LT ïàññ. Lumina Lupo
## 4 2 2
## LX 450 LX 470 LX 570
## 7 10 18
## M11 M35 M37
## 2 1 1
## M5 M6 Macan
## 10 1 2
## Magentis Malibu Manta
## 25 2 1
## Maple C81 Mark II Master ãðóç.
## 1 1 8
## Master ïàññ. Matiz Matrix
## 2 35 6
## Maxima MB ãðóç. MDX
## 18 1 5
## Megane Micra MK
## 88 16 11
## MK-2 MK Cross MKX
## 2 4 1
## ML 250 ML 270 ML 280
## 3 3 1
## ML 320 ML 350 ML 400
## 11 22 3
## ML 430 ML 500 ML 550
## 1 2 1
## ML 63 AMG Model S Model X
## 5 19 3
## Modus Mohave Mondeo
## 1 1 38
## MPV Mulsanne Multivan
## 1 1 21
## Murano Mustang Mustang GT
## 14 8 2
## Navara Navigator Nemo ãðóç.
## 2 1 3
## Nemo ïàññ. Neon New Beetle
## 3 1 2
## Nexia Nitro Niva
## 25 1 15
## Note Nubira NV
## 19 12 2
## NX 200 NX 300 Òàâðèÿ-Íîâà
## 2 1 2
## Octavia Octavia A5 Octavia A7
## 32 108 25
## Octavia Scout Octavia Tour Omega
## 5 42 50
## One Opirus Optima
## 1 1 1
## Orion Outback Outlander
## 2 16 29
## Outlander XL Paceman Pacifica
## 24 1 1
## Pajero Pajero Pinin Pajero Sport
## 6 1 28
## Pajero Wagon Panamera Panda
## 48 23 3
## Partner ãðóç. Partner ïàññ. Passat B2
## 19 22 3
## Passat B3 Passat B4 Passat B5
## 17 15 58
## Passat B6 Passat B7 Passat B8
## 66 51 5
## Passat CC Pathfinder Patriot
## 22 9 1
## Patrol Phaeton Phantom
## 15 7 2
## Phedra Picanto Pilot
## 1 4 5
## Pointer Polarsun Business Van Polo
## 1 1 60
## Pony Prelude Premacy
## 1 2 1
## Previa Primastar ãðóç. Primastar ïàññ.
## 1 2 2
## Primera Prisma Prius
## 27 1 4
## Pro Ceed Probe PT Cruiser
## 1 1 5
## Punto Q3 Q5
## 4 5 14
## Q50 Q7 Q70
## 1 59 1
## Qashqai Qashqai+2 QQ
## 49 1 13
## Qubo ïàññ. QX50 QX70
## 2 2 9
## QX80 R 320 R8
## 1 1 4
## RAM Ram Van Range Rover
## 7 1 68
## Range Rover Evoque Range Rover Sport Ranger
## 8 56 5
## Rapid Rapide Rav 4
## 6 2 54
## RCZ Rekord Rexton
## 3 1 4
## Rexton II Rexton W Rio
## 14 3 31
## RL Roadster Rodius
## 2 1 1
## Roomster RX-8 RX 200
## 2 6 2
## RX 270 RX 300 RX 330
## 3 11 6
## RX 350 RX 400 RX 450
## 27 2 1
## S-Guard S-Type S 140
## 2 2 5
## S 250 S 280 S 300
## 1 2 1
## S 320 S 350 S 400
## 12 41 8
## S 420 S 430 S 500
## 1 2 51
## S 55 S 550 S 600
## 1 13 7
## S 63 AMG S 65 AMG S2000
## 6 2 1
## S4 S40 S5
## 2 3 2
## S6 S60 S8
## 2 3 3
## S80 Safari Safe
## 6 1 1
## Saibao Samurai Sandero
## 1 1 6
## Sandero StepWay Santa FE Savana
## 1 44 1
## SC 430 Scenic Scion
## 2 23 1
## Scirocco Scorpio Scudo ãðóç.
## 6 16 3
## Scudo ïàññ. Sebring Sens
## 12 5 42
## Sentra Sephia Sequoia
## 4 3 1
## Sharan Shuma Shuttle
## 11 1 2
## Sienna Sierra SL 500 (550)
## 2 12 1
## SL 55 AMG SLK 200 SLK 350
## 1 2 1
## SM5 Smart Solaris
## 1 1 1
## Solenza Sonata Sorento
## 2 26 43
## Soul Space Star Space Wagon
## 7 5 1
## Spaceback Splash Sportage
## 2 1 37
## Sprinter 208 ïàññ. Sprinter 210 ãðóç. Sprinter 211 ïàññ.
## 2 1 1
## Sprinter 212 ïàññ. Sprinter 213 ïàññ. Sprinter 310 ïàññ.
## 3 2 1
## Sprinter 311 ïàññ. Sprinter 312 ãðóç. Sprinter 312 ïàññ.
## 1 2 4
## Sprinter 313 ãðóç. Sprinter 313 ïàññ. Sprinter 315 ïàññ.
## 6 10 1
## Sprinter 316 ãðóç. Sprinter 316 ïàññ. Sprinter 318 ïàññ.
## 1 2 2
## Sprinter 319 ãðóç. Sprinter 319 ïàññ. Sprinter 324 ïàññ.
## 1 1 1
## Sprinter ãðóç. SRX Stanza
## 1 1 1
## Stilo Stratus Sunny
## 1 1 5
## Superb SuperNova Swift
## 61 1 10
## SX4 Symbol Syncro
## 8 11 1
## T2 (Transporter) T3 (Transporter) T4 (Transporter) ãðóç
## 1 2 8
## T4 (Transporter) ïàññ. T5 (Transporter) ãðóç T5 (Transporter) ïàññ.
## 45 40 61
## T6 (Transporter) ãðóç T6 (Transporter) ïàññ. Tacoma
## 8 5 3
## Tacuma Taurus Teana
## 5 1 12
## Tempra Terios Terracan
## 1 1 1
## Terrano Thema Thunderbird
## 2 1 1
## Tiggo Tigra Tiguan
## 8 1 17
## TIIDA Tipo TL
## 14 4 4
## TLX Toledo Touareg
## 1 6 69
## Touran Tourneo Connect ïàññ. Tourneo Courier
## 19 4 1
## Town Car Trafic ãðóç. Trafic ïàññ.
## 4 36 41
## Transit ãðóç. Transit Connect ãðóç. Transit Connect ïàññ.
## 19 9 13
## Transit Custom Transit ïàññ. Tribeca
## 1 21 15
## Tribute Trooper TT
## 1 1 5
## Tucson Tundra Uno
## 69 5 3
## Up V 250 V40
## 2 13 3
## V5 Vaneo Vanette ïàññ.
## 1 1 1
## Vectra A Vectra B Vectra C
## 19 46 45
## Vento Venza Viano ïàññ.
## 6 8 7
## Vida Virage Vista
## 15 1 1
## Vitara Vito ãðóç. Vito ïàññ.
## 6 40 131
## Vivaro ãðóç. Vivaro ïàññ. Volt
## 27 34 7
## Voyager Wrangler X-Trail
## 1 5 34
## X-Type X1 X3
## 3 11 12
## X5 X5 M X6
## 119 14 41
## X6 M Xantia XC60
## 5 1 4
## XC70 XC90 XE
## 4 5 2
## Xedos 6 Xedos 9 Xenon
## 4 2 1
## XF XJR-S XKR
## 9 1 1
## Xsara Xsara Picasso XV
## 1 2 1
## Yaris Yeti Z3
## 14 6 1
## Z4 Zafira ZDX
## 5 5 1
one-way contingency table for drive column
table(car$drive)
##
## front full rear
## 511 5188 2500 1377
table(car$car, car$drive)
##
## front full rear
## Acura 0 5 8 0
## Alfa Romeo 0 10 0 1
## Aro 0 0 1 0
## Aston Martin 0 0 0 3
## Audi 26 211 218 2
## Barkas 1 0 0 0
## Bentley 0 0 15 1
## BMW 36 7 227 424
## Bogdan 0 2 0 0
## Buick 0 1 0 0
## BYD 0 7 0 0
## Cadillac 0 0 3 0
## Changan 1 0 0 0
## Chery 2 51 0 0
## Chevrolet 8 194 33 11
## Chrysler 4 15 2 7
## Citroen 8 100 0 0
## Dacia 0 11 1 0
## Dadi 0 0 1 1
## Daewoo 9 224 1 1
## Daihatsu 0 2 1 0
## Dodge 1 6 8 1
## ËUAZ 1 0 5 0
## FAW 0 1 0 0
## Ferrari 0 0 0 2
## Fiat 6 112 0 1
## Fisker 1 0 0 0
## Ford 18 243 35 54
## GAZ 10 2 1 21
## Geely 4 51 1 0
## GMC 0 0 3 0
## Great Wall 1 1 7 0
## Groz 0 0 0 2
## Hafei 0 1 0 0
## Honda 9 145 50 2
## Huanghai 0 0 1 0
## Hummer 1 0 4 0
## Hyundai 23 203 129 12
## Infiniti 4 0 49 11
## Isuzu 1 0 1 0
## JAC 0 2 0 0
## Jaguar 1 0 3 15
## Jeep 0 0 25 0
## Kia 11 140 63 1
## Lamborghini 0 0 1 0
## Lancia 1 2 0 0
## Land Rover 2 0 149 0
## Lexus 3 26 112 33
## Lifan 2 2 0 0
## Lincoln 0 0 2 4
## Maserati 0 0 0 1
## Mazda 12 145 36 5
## Mercedes-Benz 61 90 291 479
## Mercury 0 0 0 1
## MG 0 4 0 0
## MINI 0 12 2 1
## Mitsubishi 20 159 147 1
## Moskvich-AZLK 2 5 0 5
## Moskvich-Izh 2 0 0 3
## Nissan 26 235 102 5
## Opel 20 324 6 50
## Other-Retro 1 0 0 0
## Peugeot 10 170 2 0
## Porsche 1 0 83 8
## Renault 15 436 16 2
## Rolls-Royce 0 0 0 2
## Rover 0 3 1 0
## Saab 0 1 0 0
## Samand 0 2 0 0
## Samsung 0 1 0 0
## Seat 2 37 0 0
## Skoda 19 337 12 0
## SMA 0 1 0 0
## Smart 9 2 0 46
## SsangYong 1 7 37 0
## Subaru 2 3 109 0
## Suzuki 3 20 35 0
## TATA 0 0 1 0
## Tesla 0 3 8 11
## Toyota 14 274 244 9
## UAZ 2 0 19 0
## VAZ 30 286 45 128
## Volkswagen 57 744 130 5
## Volvo 1 17 12 2
## Wartburg 0 1 0 0
## ZAZ 6 92 1 3
## ZX 0 0 1 0
table(car$car, car$engType)
##
## Diesel Gas Other Petrol
## Acura 0 5 1 7
## Alfa Romeo 1 1 0 9
## Aro 0 0 0 1
## Aston Martin 0 0 0 3
## Audi 214 53 23 167
## Barkas 0 0 0 1
## Bentley 0 0 0 16
## BMW 267 74 21 332
## Bogdan 0 1 0 1
## Buick 0 0 0 1
## BYD 0 3 0 4
## Cadillac 0 0 0 3
## Changan 0 0 1 0
## Chery 0 14 3 36
## Chevrolet 3 91 18 134
## Chrysler 3 7 2 16
## Citroen 64 10 1 33
## Dacia 1 2 1 8
## Dadi 0 0 0 2
## Daewoo 0 102 5 128
## Daihatsu 0 0 0 3
## Dodge 4 4 1 7
## ËUAZ 0 1 0 5
## FAW 0 0 0 1
## Ferrari 0 0 0 2
## Fiat 73 14 3 29
## Fisker 0 0 1 0
## Ford 110 55 19 166
## GAZ 0 14 5 15
## Geely 0 29 1 26
## GMC 0 0 0 3
## Great Wall 0 5 0 4
## Groz 0 1 0 1
## Hafei 0 0 0 1
## Honda 6 48 11 141
## Huanghai 0 0 0 1
## Hummer 0 4 1 0
## Hyundai 89 73 14 191
## Infiniti 5 19 2 38
## Isuzu 2 0 0 0
## JAC 0 1 0 1
## Jaguar 1 0 0 18
## Jeep 11 3 1 10
## Kia 65 49 5 96
## Lamborghini 0 0 0 1
## Lancia 2 0 1 0
## Land Rover 85 9 4 53
## Lexus 10 42 13 109
## Lifan 0 0 0 4
## Lincoln 0 3 0 3
## Maserati 0 0 0 1
## Mazda 8 38 13 139
## Mercedes-Benz 509 98 32 282
## Mercury 0 1 0 0
## MG 0 0 0 4
## MINI 2 0 0 13
## Mitsubishi 51 114 12 150
## Moskvich-AZLK 0 2 1 9
## Moskvich-Izh 0 3 0 2
## Nissan 52 59 71 186
## Opel 149 87 13 151
## Other-Retro 1 0 0 0
## Peugeot 85 23 5 69
## Porsche 20 6 4 62
## Renault 355 24 19 71
## Rolls-Royce 0 0 1 1
## Rover 1 0 0 3
## Saab 0 0 0 1
## Samand 0 2 0 0
## Samsung 0 0 0 1
## Seat 8 5 2 24
## Skoda 60 53 10 245
## SMA 0 0 0 1
## Smart 4 1 4 48
## SsangYong 43 1 1 0
## Subaru 10 17 6 81
## Suzuki 0 12 2 44
## TATA 1 0 0 0
## Tesla 0 0 22 0
## Toyota 94 163 18 266
## UAZ 0 6 6 9
## VAZ 1 143 28 317
## Volkswagen 529 87 29 291
## Volvo 14 2 2 14
## Wartburg 0 0 0 1
## ZAZ 0 38 3 61
## ZX 0 0 0 1
table(car$car, car$registration)
##
## no yes
## Acura 0 13
## Alfa Romeo 2 9
## Aro 0 1
## Aston Martin 0 3
## Audi 104 353
## Barkas 0 1
## Bentley 0 16
## BMW 109 585
## Bogdan 0 2
## Buick 0 1
## BYD 0 7
## Cadillac 0 3
## Changan 0 1
## Chery 0 53
## Chevrolet 2 244
## Chrysler 4 24
## Citroen 3 105
## Dacia 0 12
## Dadi 0 2
## Daewoo 3 232
## Daihatsu 0 3
## Dodge 0 16
## ËUAZ 0 6
## FAW 0 1
## Ferrari 0 2
## Fiat 2 117
## Fisker 0 1
## Ford 11 339
## GAZ 0 34
## Geely 0 56
## GMC 0 3
## Great Wall 0 9
## Groz 0 2
## Hafei 0 1
## Honda 5 201
## Huanghai 0 1
## Hummer 0 5
## Hyundai 5 362
## Infiniti 0 64
## Isuzu 0 2
## JAC 0 2
## Jaguar 1 18
## Jeep 3 22
## Kia 2 213
## Lamborghini 0 1
## Lancia 1 2
## Land Rover 10 141
## Lexus 5 169
## Lifan 0 4
## Lincoln 0 6
## Maserati 0 1
## Mazda 8 190
## Mercedes-Benz 69 852
## Mercury 0 1
## MG 0 4
## MINI 0 15
## Mitsubishi 11 316
## Moskvich-AZLK 0 12
## Moskvich-Izh 0 5
## Nissan 12 356
## Opel 53 347
## Other-Retro 0 1
## Peugeot 6 176
## Porsche 1 91
## Renault 27 442
## Rolls-Royce 0 2
## Rover 1 3
## Saab 0 1
## Samand 0 2
## Samsung 0 1
## Seat 1 38
## Skoda 19 349
## SMA 0 1
## Smart 2 55
## SsangYong 0 45
## Subaru 0 114
## Suzuki 0 58
## TATA 0 1
## Tesla 0 22
## Toyota 4 537
## UAZ 0 21
## VAZ 0 489
## Volkswagen 74 862
## Volvo 1 31
## Wartburg 0 1
## ZAZ 0 102
## ZX 0 1
table(car$body, car$drive)
##
## front full rear
## crossover 71 140 1851 7
## hatch 57 1137 24 34
## other 86 349 169 234
## sedan 202 2271 301 872
## vagon 33 509 103 77
## van 62 782 52 153
table(car$body, car$registration)
##
## no yes
## crossover 59 2010
## hatch 52 1200
## other 33 805
## sedan 246 3400
## vagon 136 586
## van 35 1014
table(car$engType, car$drive)
##
## front full rear
## Diesel 132 1485 932 464
## Gas 66 975 460 221
## Other 115 228 64 55
## Petrol 198 2500 1044 637
5)To draw a boxplot of the variables that belong to the study.
For price
boxplot(car$price, data=car, xlab="Salary", main="Boxplot of Salary", horizontal=TRUE,col = "blue")
For mileage
boxplot(car$mileage, data=car, xlab="Mileage", main="Boxplot of Mileage", horizontal=TRUE , col = "yellow")
For engV
boxplot(car$engV, data=car, xlab="Engine Volume", main="Boxplot of Engine Volume", horizontal=TRUE,col = "red")
6)To draw Histograms for suitable data fields.
library(lattice)
histogram(~car, data = car,main = "Distribution of Manufacturing Brand of the cars", xlab="Car Brand", ylab = "Number of cars", col='blue' )
histogram(~price, data = car,main = "Distribution of Price of cars", xlab="Price", ylab = "Number of cars",col='yellow' )
histogram(~body, data = car,main = "Distribution of body type of the cars", xlab="Body type", ylab="Number of cars",col='green' )
histogram(~mileage, data = car,main = "Distribution of Mileage", xlab="Mileage", ylab="Number of cars",col='red')
histogram(~engV, data = car,main = "Distribution of Engine Volume", xlab="Engine Volume",ylab="Number of cars", col='purple' )
histogram(~year, data = car,main = "Distribution of year of Production", xlab="Year",ylab="Number of cars", col='orange' )
library(car)
##
## Attaching package: 'car'
## The following object is masked from 'package:psych':
##
## logit
scatterplot(car$mileage, car$price,main="Scatterplot of Price vs Mileage",
xlab="Mileage", ylab="Price")
scatterplot(car$engV, car$price,main="Scatterplot of Price vs Engine Volume",
xlab="Engine Volume", ylab="Price")
plot(car$year, car$price,main="Scatterplot of Price vs Year",
xlab="Year", ylab="Price")
library(car)
scatterplot(price ~ mileage | registration, data=car,
xlab="Mileage", ylab="Price",
main="Comparison of Price with Mileage",
labels=row.names(car))
scatterplot(price ~ engV | registration, data=car,
xlab="Mileage", ylab="Price",
main="Comparison of Price with Mileage",
labels=row.names(car))
cardata <- car[ , c(2,4,5,8)] #correlation matrix of numeric type
cor(cardata)
## price mileage engV year
## price 1.0000000 -0.3124151 NA 0.3703792
## mileage -0.3124151 1.0000000 NA -0.4955992
## engV NA NA 1 NA
## year 0.3703792 -0.4955992 NA 1.0000000
cor(car$price,car$mileage)
## [1] -0.3124151
cor(car$price,car$year)
## [1] 0.3703792
9)To Visualize your correlation matrix using corrgram
library(corrgram)
corrgram(car, order=FALSE, lower.panel=panel.shade, upper.panel=panel.pie, text.panel=panel.txt, main="Corrgram of car Variables")
Insights from corrgram
1 ) Price is strongly and negatively correlated to mileage 2 ) Price is weakly and positively correlated to engV 2 ) Price is Strongly and positively correlated to year 3 ) Mileage is weakly and positively correlated to engV 4 ) Mileage is strongly and negatively correlated to year 5 ) engV is negatively and weakly correlated to year.
library(car)
scatterplot.matrix(~price+mileage+engV++year, data=car,main="Price versus other variables")
## Warning: 'scatterplot.matrix' is deprecated.
## Use 'scatterplotMatrix' instead.
## See help("Deprecated") and help("car-deprecated").
Null hypothesis 1 : There is no significant relationship between the price of the car and mileage
cor.test(car$price, car$mileage)
##
## Pearson's product-moment correlation
##
## data: car$price and car$mileage
## t = -32.18, df = 9574, p-value < 2.2e-16
## alternative hypothesis: true correlation is not equal to 0
## 95 percent confidence interval:
## -0.3303770 -0.2942269
## sample estimates:
## cor
## -0.3124151
p-value < 2.2e-16. So we reject the null hyphothesis in favour of alternative hyphothesis that there is significant relationship between price of car and its mileage.
Null hypothesis 2 : There is no significant relationship between the price of the car and engine volume
cor.test(car$price, car$engV)
##
## Pearson's product-moment correlation
##
## data: car$price and car$engV
## t = 4.8889, df = 9140, p-value = 1.031e-06
## alternative hypothesis: true correlation is not equal to 0
## 95 percent confidence interval:
## 0.03060302 0.07149463
## sample estimates:
## cor
## 0.05107023
p-value = 1.031e-06 < 0.05. So we reject the null hyphothesis in favour of alternative hyphothesis that there is significant relationship between price of car and its engine volume.
12)To run a t-test to analyse the hypothesis.
Null Hyphothesis 3: There is no significant difference between the prices of cars based on whether the car is registered in Ukraine or not
t.test(car$price~car$registration)
##
## Welch Two Sample t-test
##
## data: car$price by car$registration
## t = -42.281, df = 6577.2, p-value < 2.2e-16
## alternative hypothesis: true difference in means is not equal to 0
## 95 percent confidence interval:
## -12979.45 -11829.22
## sample estimates:
## mean in group no mean in group yes
## 3955.677 16360.012
p-value < 2.2e-16 < 0.05 . SO we reject the ull hyphothesis ans conclude that There is significant difference between the prices of cars based on whether the car is registered in Ukraine or not
13)Chi-square test
a <- xtabs(~ body + engType, data = car)
a
## engType
## body Diesel Gas Other Petrol
## crossover 766 421 52 830
## hatch 129 200 124 799
## other 296 84 55 403
## sedan 535 865 177 2069
## vagon 390 96 27 209
## van 897 56 27 69
Null Hyphothesis 1 :- There is significant relationship between the body type of the car and its engType
chisq.test(a)
##
## Pearson's Chi-squared test
##
## data: a
## X-squared = 2533, df = 15, p-value < 2.2e-16
p-value < 2.2e-16. p value is less than 0.05 , so we reject null hyphotheses and conclude that There is significant relationship between the body type of the car and its engType
Linear regression
We perofrm Multivariate Regression to find the dependance of price of car on other variables.
Model 1:
Independant variable : mileage , engV, year Dependant variable : Price
model1 <- price ~ mileage + engV + year
lm1 <- lm(model1 , data = car)
summary(lm1)
##
## Call:
## lm(formula = model1, data = car)
##
## Residuals:
## Min 1Q Median 3Q Max
## -45885 -9463 -3802 3672 515786
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -1.955e+06 7.704e+04 -25.378 < 2e-16 ***
## mileage -4.265e+01 2.730e+00 -15.626 < 2e-16 ***
## engV 2.894e+02 3.887e+01 7.445 1.06e-13 ***
## year 9.847e+02 3.829e+01 25.714 < 2e-16 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 22000 on 9138 degrees of freedom
## (434 observations deleted due to missingness)
## Multiple R-squared: 0.1641, Adjusted R-squared: 0.1638
## F-statistic: 597.8 on 3 and 9138 DF, p-value: < 2.2e-16
lm1$coefficients
## (Intercept) mileage engV year
## -1.955008e+06 -4.265228e+01 2.893995e+02 9.846567e+02
Conclusion: p values of all variables is less than 0.05. So price of car is strongly dependant on mileage of the car, its engine volume and year in which it is manufactured
Model 2
Independant variable : car, body, mileage , engV, engType, year, model, drive Dependant variable : Price
model2 <- price ~ car + body + mileage + engV + engType + year + model + drive
lm2 <- lm(model2, data = car)
summary(lm2)
##
## Call:
## lm(formula = model2, data = car)
##
## Residuals:
## Min 1Q Median 3Q Max
## -362478 -2563 -135 2135 225804
##
## Coefficients: (68 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -2.016e+06 9.064e+04 -22.239 < 2e-16 ***
## carAlfa Romeo -7.942e+03 3.301e+04 -0.241 0.809852
## carAro -9.787e+03 2.049e+04 -0.478 0.632968
## carAston Martin 1.005e+05 1.783e+04 5.637 1.79e-08 ***
## carAudi -3.961e+03 1.594e+04 -0.248 0.803797
## carBentley 5.183e+05 2.056e+04 25.211 < 2e-16 ***
## carBMW -1.204e+04 2.056e+04 -0.586 0.558047
## carBogdan -2.112e+04 2.309e+04 -0.915 0.360399
## carBuick 2.957e+03 2.055e+04 0.144 0.885604
## carBYD -1.625e+04 1.777e+04 -0.914 0.360503
## carCadillac -4.289e+03 2.048e+04 -0.209 0.834106
## carChery -1.940e+04 1.552e+04 -1.250 0.211456
## carChevrolet -1.957e+03 1.571e+04 -0.125 0.900918
## carChrysler -5.662e+03 2.057e+04 -0.275 0.783079
## carCitroen -8.107e+03 1.784e+04 -0.454 0.649501
## carDacia -9.192e+03 2.864e+04 -0.321 0.748229
## carDadi -2.167e+04 2.052e+04 -1.056 0.291131
## carDaewoo -1.499e+04 1.568e+04 -0.956 0.338948
## carDaihatsu -1.735e+04 2.048e+04 -0.847 0.397041
## carDodge -3.519e+03 2.057e+04 -0.171 0.864208
## carËUAZ -7.288e+03 1.778e+04 -0.410 0.681889
## carFAW -2.337e+04 2.054e+04 -1.138 0.255295
## carFerrari 1.027e+05 2.055e+04 4.997 5.93e-07 ***
## carFiat 1.510e+03 1.683e+04 0.090 0.928524
## carFord -2.059e+03 1.494e+04 -0.138 0.890380
## carGAZ 1.344e+04 3.186e+04 0.422 0.673130
## carGeely -2.266e+04 1.682e+04 -1.347 0.177953
## carGMC 1.078e+04 2.054e+04 0.525 0.599765
## carGreat Wall -1.946e+04 2.048e+04 -0.950 0.341984
## carGroz -1.409e+04 2.051e+04 -0.687 0.492295
## carHafei -1.556e+04 2.054e+04 -0.757 0.448885
## carHonda -1.038e+03 2.055e+04 -0.051 0.959702
## carHuanghai -1.881e+04 2.048e+04 -0.919 0.358354
## carHummer -5.462e+03 1.775e+04 -0.308 0.758261
## carHyundai -2.340e+04 2.201e+04 -1.063 0.287716
## carInfiniti 5.417e+04 2.048e+04 2.645 0.008187 **
## carIsuzu 5.746e+03 2.053e+04 0.280 0.779564
## carJAC -2.385e+04 2.596e+04 -0.919 0.358371
## carJaguar 1.029e+04 2.055e+04 0.501 0.616484
## carJeep 1.926e+04 1.586e+04 1.214 0.224683
## carKia -1.291e+04 1.470e+04 -0.878 0.380003
## carLamborghini 9.832e+04 2.052e+04 4.791 1.69e-06 ***
## carLancia -5.558e+03 2.057e+04 -0.270 0.786965
## carLand Rover 7.141e+03 3.144e+04 0.227 0.820337
## carLexus -2.246e+01 1.783e+04 -0.001 0.998995
## carLifan -3.599e+04 2.188e+04 -1.644 0.100113
## carLincoln 1.048e+04 1.629e+04 0.643 0.520261
## carMaserati 7.977e+04 2.055e+04 3.881 0.000105 ***
## carMazda -2.600e+04 2.287e+04 -1.137 0.255776
## carMercedes-Benz -1.399e+04 2.304e+04 -0.607 0.543738
## carMercury 4.074e+03 2.056e+04 0.198 0.842920
## carMG -4.572e+04 2.362e+04 -1.935 0.052969 .
## carMINI -6.122e+03 2.053e+04 -0.298 0.765522
## carMitsubishi -9.336e+03 2.055e+04 -0.454 0.649550
## carMoskvich-AZLK 1.785e+04 2.080e+04 0.858 0.390928
## carMoskvich-Izh -1.548e+04 1.682e+04 -0.920 0.357471
## carNissan -1.257e+04 1.472e+04 -0.854 0.392944
## carOpel -1.211e+04 1.597e+04 -0.759 0.448130
## carOther-Retro 9.192e+03 2.053e+04 0.448 0.654403
## carPeugeot -6.783e+03 1.681e+04 -0.404 0.686510
## carPorsche 3.335e+04 1.486e+04 2.244 0.024875 *
## carRenault -1.264e+04 2.791e+04 -0.453 0.650551
## carRolls-Royce 4.454e+04 1.780e+04 2.502 0.012359 *
## carRover -1.669e+04 2.786e+04 -0.599 0.549156
## carSaab -3.150e+03 2.055e+04 -0.153 0.878167
## carSamand -1.556e+04 1.782e+04 -0.873 0.382500
## carSamsung -1.016e+04 2.054e+04 -0.494 0.621038
## carSeat -6.119e+03 1.573e+04 -0.389 0.697204
## carSkoda -1.641e+04 1.566e+04 -1.048 0.294519
## carSMA -1.709e+04 2.054e+04 -0.832 0.405608
## carSmart -7.891e+03 2.055e+04 -0.384 0.701023
## carSsangYong -1.815e+04 2.054e+04 -0.884 0.376810
## carSubaru -1.744e+04 2.053e+04 -0.849 0.395704
## carSuzuki -1.368e+04 1.565e+04 -0.874 0.382080
## carTATA -2.393e+04 2.053e+04 -1.166 0.243701
## carTesla 4.273e+04 1.678e+04 2.547 0.010875 *
## carToyota -1.451e+04 1.510e+04 -0.961 0.336672
## carUAZ -1.835e+04 1.620e+04 -1.132 0.257511
## carVAZ -1.641e+04 2.055e+04 -0.799 0.424378
## carVolkswagen -7.291e+02 1.574e+04 -0.046 0.963068
## carVolvo 2.220e+03 1.588e+04 0.140 0.888826
## carWartburg -1.361e+03 2.056e+04 -0.066 0.947218
## carZAZ -2.184e+04 1.506e+04 -1.451 0.146847
## carZX -1.409e+04 2.048e+04 -0.688 0.491511
## bodyhatch -2.158e+02 1.503e+03 -0.144 0.885880
## bodyother 1.379e+03 1.329e+03 1.037 0.299728
## bodysedan -1.706e+03 1.407e+03 -1.213 0.225331
## bodyvagon -2.341e+03 1.409e+03 -1.661 0.096744 .
## bodyvan 9.957e+02 1.585e+03 0.628 0.529833
## mileage -2.832e+01 2.391e+00 -11.842 < 2e-16 ***
## engV -1.786e+00 2.823e+01 -0.063 0.949564
## engTypeGas -2.194e+03 5.998e+02 -3.658 0.000256 ***
## engTypeOther -2.616e+03 1.054e+03 -2.482 0.013075 *
## engTypePetrol -1.612e+03 5.183e+02 -3.110 0.001877 **
## year 1.017e+03 4.449e+01 22.860 < 2e-16 ***
## model1.3 NA NA NA NA
## model10 NA NA NA NA
## model100 8.975e+03 7.385e+03 1.215 0.224244
## model106 2.576e+03 1.674e+04 0.154 0.877758
## model107 -1.279e+04 9.476e+03 -1.350 0.177166
## model11 9.670e+03 2.780e+04 0.348 0.727951
## model1102 Òàâðèÿ 9.368e+03 4.978e+03 1.882 0.059876 .
## model1103 Ñëàâóòà 5.575e+03 4.639e+03 1.202 0.229552
## model110557 3.149e+03 6.404e+03 0.492 0.622932
## model1117 -4.962e+03 1.773e+04 -0.280 0.779657
## model1118 -1.111e+02 1.511e+04 -0.007 0.994132
## model1119 -2.428e+03 1.527e+04 -0.159 0.873673
## model116 4.289e+03 1.672e+04 0.257 0.797565
## model118 2.829e+03 1.588e+04 0.178 0.858600
## model120 -5.244e+03 2.049e+04 -0.256 0.797994
## model125 -2.384e+03 1.678e+04 -0.142 0.887022
## model1301 -1.352e+04 1.774e+04 -0.762 0.446157
## model1302 -4.222e+03 1.774e+04 -0.238 0.811898
## model147 -1.448e+02 3.296e+04 -0.004 0.996495
## model156 -3.257e+03 3.134e+04 -0.104 0.917242
## model159 -4.709e+02 3.050e+04 -0.015 0.987681
## model19 1.235e+04 2.586e+04 0.478 0.632991
## model190 2.560e+04 1.862e+04 1.375 0.169201
## model2 6.249e+03 1.947e+04 0.321 0.748269
## model200 1.968e+04 1.883e+04 1.045 0.295996
## model2008 -7.386e+03 1.109e+04 -0.666 0.505276
## model205 4.252e+03 1.677e+04 0.254 0.799855
## model206 -5.962e+03 9.678e+03 -0.616 0.537904
## model207 -8.701e+03 9.577e+03 -0.909 0.363602
## model208 -1.212e+04 1.061e+04 -1.142 0.253389
## model21 1.497e+04 2.781e+04 0.538 0.590521
## model210 1.455e+04 1.975e+04 0.737 0.461166
## model2101 2.535e+04 1.489e+04 1.702 0.088715 .
## model2102 2.690e+04 1.779e+04 1.512 0.130593
## model2103 3.079e+04 1.596e+04 1.930 0.053695 .
## model2104 7.032e+03 1.508e+04 0.466 0.640944
## model2105 1.680e+04 1.490e+04 1.127 0.259665
## model2106 2.039e+04 1.481e+04 1.377 0.168639
## model2107 6.593e+03 1.468e+04 0.449 0.653281
## model2108 1.224e+04 1.477e+04 0.829 0.407018
## model2109 5.945e+03 1.476e+04 0.403 0.687002
## model2109 (Áàëòèêà) 1.471e+03 2.049e+04 0.072 0.942778
## model21093 1.319e+03 1.503e+04 0.088 0.930068
## model21099 2.539e+03 1.463e+04 0.174 0.862220
## model2110 1.749e+03 1.467e+04 0.119 0.905117
## model2111 2.895e+03 1.496e+04 0.194 0.846547
## model2112 6.618e+02 1.503e+04 0.044 0.964879
## model2113 -3.316e+03 1.526e+04 -0.217 0.828009
## model2114 -3.912e+03 1.490e+04 -0.262 0.792973
## model2115 -5.690e+02 1.474e+04 -0.039 0.969213
## model2121 2.405e+03 1.473e+04 0.163 0.870258
## model2123 -1.329e+03 2.053e+04 -0.065 0.948393
## model2140 -9.673e+03 1.693e+04 -0.571 0.567701
## model2141 -2.230e+04 1.617e+04 -1.379 0.167805
## model2170 -9.484e+02 1.476e+04 -0.064 0.948776
## model2171 -2.522e+03 1.587e+04 -0.159 0.873744
## model2172 -3.228e+03 1.564e+04 -0.206 0.836494
## model2190 Ãðàíòà -8.921e+03 2.046e+04 -0.436 0.662777
## model220 1.336e+04 2.061e+04 0.648 0.516796
## model230 2.197e+04 1.931e+04 1.138 0.255215
## model24 3.034e+03 3.007e+04 0.101 0.919629
## model240 9.291e+03 1.596e+04 0.582 0.560436
## model2410 -1.284e+04 3.009e+04 -0.427 0.669711
## model25 1.835e+04 2.517e+04 0.729 0.465946
## model250 1.951e+04 2.302e+04 0.848 0.396707
## model2705 GAZåëü -2.100e+04 3.193e+04 -0.658 0.510742
## model2715 1.534e+04 1.673e+04 0.917 0.359301
## model2717 NA NA NA NA
## model2752 Ñîáîëü -3.112e+04 3.019e+04 -1.031 0.302582
## model3 1.458e+04 1.773e+04 0.822 0.410911
## model300 2.397e+04 2.302e+04 1.042 0.297649
## model300 C 3.805e+03 1.533e+04 0.248 0.803911
## model300 M -1.051e+03 2.049e+04 -0.051 0.959092
## model3008 -7.038e+03 9.470e+03 -0.743 0.457381
## model301 -1.156e+04 1.108e+04 -1.044 0.296701
## model306 -2.919e+02 1.322e+04 -0.022 0.982392
## model307 -3.206e+03 9.174e+03 -0.350 0.726704
## model308 -9.651e+03 9.055e+03 -1.066 0.286543
## model31029 -1.643e+04 3.177e+04 -0.517 0.605095
## model3110 -2.512e+04 3.010e+04 -0.835 0.403945
## model31105 -2.590e+04 2.906e+04 -0.891 0.372810
## model3151 -1.228e+04 1.620e+04 -0.758 0.448700
## model31512 3.224e+03 1.619e+04 0.199 0.842220
## model31514 -1.126e+04 1.618e+04 -0.696 0.486215
## model316 1.376e+04 1.553e+04 0.886 0.375480
## model3163 6.112e+03 1.629e+04 0.375 0.707613
## model318 1.162e+04 1.477e+04 0.787 0.431475
## model320 1.029e+04 1.465e+04 0.702 0.482527
## model3221 GAZåëü -2.809e+04 3.183e+04 -0.883 0.377512
## model32213 -2.257e+04 3.185e+04 -0.709 0.478644
## model323 2.286e+04 1.718e+04 1.330 0.183456
## model324 2.464e+04 2.052e+04 1.201 0.229891
## model325 1.102e+04 1.539e+04 0.716 0.473899
## model328 1.721e+04 1.552e+04 1.109 0.267560
## model33 7.129e+03 3.296e+04 0.216 0.828736
## model330 8.267e+03 1.522e+04 0.543 0.587088
## model3302 GAZåëü -2.905e+04 3.017e+04 -0.963 0.335666
## model335 1.330e+04 1.778e+04 0.748 0.454532
## model340 9.011e+03 1.599e+04 0.564 0.572997
## model350 2.704e+04 2.352e+04 1.149 0.250405
## model350Z 8.224e+03 1.478e+04 0.556 0.577984
## model3741 -6.179e+03 1.617e+04 -0.382 0.702438
## model4 Series Gran Coupe 2.394e+04 2.049e+04 1.168 0.242720
## model403 5.582e+03 2.066e+04 0.270 0.787011
## model405 2.973e+03 1.676e+04 0.177 0.859181
## model406 2.654e+03 1.322e+04 0.201 0.840832
## model407 -2.679e+03 9.236e+03 -0.290 0.771765
## model412 NA NA NA NA
## model428 2.055e+04 2.052e+04 1.002 0.316470
## model452 ïàññ. 2.539e+04 1.632e+04 1.556 0.119765
## model458 Italia 7.412e+04 2.045e+04 3.624 0.000292 ***
## model469 1.519e+04 9.144e+03 1.661 0.096667 .
## model469Á 1.361e+04 1.259e+04 1.080 0.280016
## model4Runner 2.634e+04 1.507e+04 1.748 0.080464 .
## model5 1.651e+04 1.880e+04 0.878 0.380066
## model5 Series 1.157e+04 1.674e+04 0.691 0.489419
## model5 Series GT 2.421e+04 1.675e+04 1.445 0.148472
## model500 -1.961e+04 1.325e+04 -1.480 0.138842
## model500 L -1.651e+04 1.328e+04 -1.243 0.213737
## model5008 -3.521e+03 1.673e+04 -0.210 0.833361
## model508 -2.936e+03 1.109e+04 -0.265 0.791145
## model520 1.805e+04 1.462e+04 1.235 0.216902
## model523 1.399e+04 1.531e+04 0.914 0.360972
## model524 2.194e+04 2.052e+04 1.069 0.284958
## model525 1.396e+04 1.467e+04 0.951 0.341439
## model528 1.562e+04 1.495e+04 1.045 0.296155
## model530 1.212e+04 1.467e+04 0.826 0.408922
## model535 1.524e+04 1.496e+04 1.019 0.308293
## model540 1.770e+04 1.568e+04 1.129 0.258985
## model545 1.631e+04 2.050e+04 0.796 0.426313
## model550 4.179e+04 1.648e+04 2.535 0.011252 *
## model6 1.773e+04 1.766e+04 1.004 0.315561
## model6 MPS 1.031e+04 1.877e+04 0.549 0.582841
## model6 Series Gran Coupe 6.260e+04 2.053e+04 3.049 0.002300 **
## model605 1.188e+04 1.326e+04 0.897 0.369997
## model607 -3.671e+03 1.109e+04 -0.331 0.740778
## model626 2.509e+04 1.794e+04 1.398 0.162117
## model630 1.270e+03 1.778e+04 0.071 0.943060
## model640 5.486e+04 1.622e+04 3.381 0.000724 ***
## model645 1.601e+04 1.778e+04 0.900 0.367935
## model650 1.453e+04 2.051e+04 0.708 0.478814
## model730 2.009e+04 1.480e+04 1.358 0.174486
## model735 1.636e+04 1.541e+04 1.062 0.288233
## model740 1.844e+04 1.539e+04 1.198 0.230853
## model745 1.398e+04 1.568e+04 0.892 0.372602
## model75 9.627e+03 2.585e+04 0.372 0.709641
## model750 3.698e+04 1.499e+04 2.467 0.013638 *
## model760 1.842e+04 1.777e+04 1.037 0.299932
## model80 7.859e+03 7.769e+03 1.012 0.311759
## model850 -9.927e+02 1.221e+04 -0.081 0.935208
## model9 1.733e+04 2.781e+04 0.623 0.533267
## model9-May NA NA NA NA
## model90 4.602e+03 1.593e+04 0.289 0.772672
## model911 2.088e+03 7.201e+03 0.290 0.771847
## model965 4.507e+04 1.517e+04 2.972 0.002970 **
## model968 1.814e+04 1.101e+04 1.648 0.099378 .
## model969 Âîëûíü -7.395e+03 1.774e+04 -0.417 0.676707
## model969Ì NA NA NA NA
## modelA 140 4.139e+03 1.969e+04 0.210 0.833493
## modelA 150 4.252e+03 2.057e+04 0.207 0.836197
## modelA 170 4.352e+03 1.898e+04 0.229 0.818691
## modelA 180 9.476e+03 2.297e+04 0.413 0.679981
## modelA1 -7.814e+03 1.062e+04 -0.736 0.461715
## modelA3 -4.967e+03 7.863e+03 -0.632 0.527586
## modelA4 -8.822e+02 6.803e+03 -0.130 0.896833
## modelA4 Allroad 1.477e+03 9.778e+03 0.151 0.879957
## modelA5 3.964e+03 7.504e+03 0.528 0.597285
## modelA6 -1.202e+03 6.628e+03 -0.181 0.856119
## modelA6 Allroad -2.328e+03 7.176e+03 -0.324 0.745651
## modelA7 2.680e+04 1.063e+04 2.521 0.011731 *
## modelA8 5.187e+03 6.990e+03 0.742 0.458132
## modelAcadia -2.581e+04 2.052e+04 -1.258 0.208490
## modelAccent 7.905e+03 1.650e+04 0.479 0.631885
## modelAccord -5.610e+03 1.461e+04 -0.384 0.700893
## modelActyon -2.346e+03 1.678e+04 -0.140 0.888804
## modelActyon Sports -5.343e+03 2.048e+04 -0.261 0.794179
## modelAgila 7.118e+03 1.588e+04 0.448 0.653923
## modelAlmera 3.438e+02 4.770e+03 0.072 0.942543
## modelAlpina -1.941e+04 2.050e+04 -0.947 0.343830
## modelAltea -7.988e+03 1.564e+04 -0.511 0.609549
## modelAltea XL -4.036e+03 1.564e+04 -0.258 0.796326
## modelAltima 2.975e+03 1.476e+04 0.202 0.840288
## modelAmarok -1.581e+04 9.443e+03 -1.675 0.094063 .
## modelAmpera 4.050e+03 1.592e+04 0.254 0.799149
## modelAmulet 2.185e+03 6.765e+03 0.323 0.746651
## modelAntara -1.247e+04 1.594e+04 -0.783 0.433788
## modelArmada 5.231e+03 8.724e+03 0.600 0.548812
## modelAscona 1.880e+04 1.218e+04 1.544 0.122657
## modelAstra F 1.093e+04 8.139e+03 1.342 0.179536
## modelAstra G 2.214e+03 6.942e+03 0.319 0.749782
## modelAstra H -1.659e+03 7.071e+03 -0.235 0.814550
## modelAstra J -6.006e+03 7.976e+03 -0.753 0.451455
## modelAstro ïàññ. -1.166e+04 1.195e+04 -0.976 0.329206
## modelASX -2.960e+03 1.568e+04 -0.189 0.850216
## modelAuris 3.372e+01 4.709e+03 0.007 0.994287
## modelAurora NA NA NA NA
## modelAvalon 1.049e+04 1.097e+04 0.956 0.338928
## modelAvenger -8.783e+03 1.777e+04 -0.494 0.621085
## modelAvensis 6.341e+03 4.771e+03 1.329 0.183890
## modelAveo -1.340e+04 6.231e+03 -2.150 0.031547 *
## modelAygo -5.490e+03 9.203e+03 -0.597 0.550843
## modelB-Max -1.652e+04 1.075e+04 -1.536 0.124544
## modelB 170 6.529e+03 2.297e+04 0.284 0.776257
## modelB 180 4.154e+03 1.869e+04 0.222 0.824114
## modelB 200 3.740e+03 1.970e+04 0.190 0.849458
## modelBDD 4.974e+03 2.049e+04 0.243 0.808147
## modelBeat -3.438e+03 1.546e+04 -0.222 0.824038
## modelBeetle -6.128e+03 1.184e+04 -0.518 0.604743
## modelBentayga -1.948e+05 1.627e+04 -11.976 < 2e-16 ***
## modelBerlingo ãðóç. -9.100e+03 1.132e+04 -0.804 0.421630
## modelBerlingo ïàññ. -8.326e+03 1.066e+04 -0.781 0.434782
## modelBesta 9.199e+03 1.478e+04 0.622 0.533794
## modelBipper ïàññ. -1.197e+04 1.674e+04 -0.715 0.474578
## modelBluebird 2.335e+04 1.068e+04 2.187 0.028769 *
## modelBora -4.969e+03 8.053e+03 -0.617 0.537243
## modelBoxer ãðóç. -3.487e+03 1.183e+04 -0.295 0.768249
## modelBoxer ïàññ. 4.392e+03 1.328e+04 0.331 0.740856
## modelBravo -6.678e+03 1.674e+04 -0.399 0.689991
## modelC-Class 1.481e+04 1.799e+04 0.823 0.410453
## modelC-Elysee -1.482e+04 1.326e+04 -1.118 0.263721
## modelC-Max -1.177e+04 7.237e+03 -1.627 0.103797
## modelC1 -1.172e+04 1.261e+04 -0.930 0.352419
## modelC3 -8.731e+03 1.218e+04 -0.717 0.473591
## modelC3 Picasso -8.754e+03 1.213e+04 -0.721 0.470645
## modelC30 -2.045e+03 2.053e+04 -0.100 0.920637
## modelC4 -7.223e+03 1.093e+04 -0.661 0.508850
## modelC4 Picasso -2.500e+03 1.453e+04 -0.172 0.863351
## modelC5 -2.513e+03 1.259e+04 -0.200 0.841756
## modelCabrio -2.927e+03 1.670e+04 -0.175 0.860898
## modelCaddy -1.734e+04 1.566e+04 -1.107 0.268437
## modelCaddy ãðóç. -1.643e+04 6.305e+03 -2.605 0.009193 **
## modelCaddy ïàññ. -1.323e+04 6.359e+03 -2.081 0.037485 *
## modelCaliber -9.797e+03 2.053e+04 -0.477 0.633306
## modelCalibra 1.280e+04 1.215e+04 1.054 0.292037
## modelCalifornia NA NA NA NA
## modelCamaro 2.189e+04 7.816e+03 2.800 0.005119 **
## modelCamry 8.771e+03 4.144e+03 2.116 0.034346 *
## modelCaptiva -1.122e+04 7.553e+03 -1.485 0.137547
## modelCaptur -2.923e+03 2.593e+04 -0.113 0.910239
## modelCaravelle -6.296e+03 8.846e+03 -0.712 0.476636
## modelCarens -1.667e+03 7.066e+03 -0.236 0.813546
## modelCarina 1.660e+04 8.244e+03 2.014 0.044085 *
## modelCarisma 3.071e+03 1.547e+04 0.198 0.842686
## modelCarnival 5.706e+02 7.798e+03 0.073 0.941669
## modelCayenne -2.613e+04 3.789e+03 -6.897 5.72e-12 ***
## modelCayman -2.600e+04 1.483e+04 -1.753 0.079587 .
## modelCeed -6.698e+02 4.291e+03 -0.156 0.875977
## modelCefiro 9.673e+03 1.477e+04 0.655 0.512625
## modelCelica 9.869e+03 1.099e+04 0.898 0.369052
## modelCentury NA NA NA NA
## modelCerato -5.769e+02 4.055e+03 -0.142 0.886873
## modelChallenger 2.357e+04 2.052e+04 1.149 0.250760
## modelCherokee -2.714e+04 1.211e+04 -2.242 0.024997 *
## modelCinquecento -6.962e+03 1.321e+04 -0.527 0.598156
## modelCity -1.382e+03 1.773e+04 -0.078 0.937868
## modelCivic -8.604e+03 1.466e+04 -0.587 0.557199
## modelCK 4.115e+03 1.026e+04 0.401 0.688400
## modelCK-2 1.308e+03 1.026e+04 0.128 0.898545
## modelCK1 4.924e+03 1.323e+04 0.372 0.709865
## modelCL 180 1.536e+04 2.301e+04 0.668 0.504471
## modelCL 500 1.927e+04 1.905e+04 1.012 0.311714
## modelCL 55 AMG 2.670e+04 1.974e+04 1.353 0.176243
## modelCL 550 2.837e+04 2.302e+04 1.232 0.217859
## modelCL 63 AMG 4.683e+04 1.977e+04 2.369 0.017859 *
## modelCLA-Class 2.213e+04 2.298e+04 0.963 0.335662
## modelCLA 200 1.741e+04 1.972e+04 0.883 0.377303
## modelCLA 220 2.610e+04 2.297e+04 1.136 0.255844
## modelClarus 8.731e+03 8.814e+03 0.991 0.321920
## modelCLC 180 1.089e+04 2.302e+04 0.473 0.636158
## modelCLC 200 7.602e+03 2.303e+04 0.330 0.741274
## modelClio 3.638e+02 2.438e+04 0.015 0.988095
## modelCLK 200 9.500e+03 2.063e+04 0.461 0.645132
## modelCLK 220 8.478e+03 2.302e+04 0.368 0.712689
## modelCLK 230 6.621e+03 2.059e+04 0.321 0.747855
## modelCLK 240 1.231e+04 2.302e+04 0.535 0.592828
## modelCLK 280 1.406e+04 2.302e+04 0.611 0.541327
## modelCLK 320 1.315e+04 1.976e+04 0.665 0.505966
## modelCLK 430 9.941e+03 2.301e+04 0.432 0.665699
## modelCLS 350 1.733e+04 1.883e+04 0.921 0.357322
## modelCLS 400 7.568e+04 2.298e+04 3.293 0.000995 ***
## modelCLS 500 4.298e+04 2.057e+04 2.090 0.036663 *
## modelCLS 63 AMG 4.910e+04 2.061e+04 2.382 0.017238 *
## modelCobalt -1.306e+04 1.569e+04 -0.833 0.405045
## modelColt -3.576e+03 1.527e+04 -0.234 0.814790
## modelCombo ãðóç. -5.078e+03 7.705e+03 -0.659 0.509915
## modelCombo ïàññ. -1.899e+03 7.242e+03 -0.262 0.793103
## modelCompass -3.390e+04 1.585e+04 -2.139 0.032496 *
## modelContinental -4.614e+05 1.530e+04 -30.149 < 2e-16 ***
## modelCooper -1.278e+03 1.523e+04 -0.084 0.933132
## modelCooper S -3.406e+03 2.051e+04 -0.166 0.868101
## modelCordoba -2.465e+03 8.364e+03 -0.295 0.768185
## modelCorolla 5.481e+03 4.422e+03 1.239 0.215205
## modelCorolla Verso 9.041e+03 1.500e+04 0.603 0.546741
## modelCorsa 1.356e+03 8.005e+03 0.169 0.865531
## modelCorvette 3.278e+04 1.194e+04 2.745 0.006070 **
## modelCountryman -2.042e+03 1.776e+04 -0.115 0.908456
## modelCoupe 9.474e+03 1.794e+04 0.528 0.597516
## modelCourier -1.301e+04 1.073e+04 -1.213 0.225210
## modelCR-V -9.668e+03 1.473e+04 -0.656 0.511637
## modelCross Touran -9.269e+03 1.568e+04 -0.591 0.554376
## modelCrossEastar 8.085e+03 1.553e+04 0.520 0.602751
## modelCrossfire -6.867e+03 2.049e+04 -0.335 0.737528
## modelCrosstour -7.855e+03 2.049e+04 -0.383 0.701425
## modelCruze -1.191e+04 6.744e+03 -1.766 0.077483 .
## modelCT -2.455e+03 1.458e+04 -0.168 0.866302
## modelCuore 5.672e+03 2.053e+04 0.276 0.782315
## modelCX-5 1.731e+04 1.883e+04 0.920 0.357836
## modelCX-7 1.065e+04 1.793e+04 0.594 0.552487
## modelCX-9 1.340e+04 1.911e+04 0.701 0.483336
## modelD-Max -2.525e+04 2.055e+04 -1.229 0.219237
## modelDaimler 1.500e+03 2.047e+04 0.073 0.941587
## modelDB9 -5.687e+04 1.774e+04 -3.206 0.001349 **
## modelDefender 1.818e+04 2.971e+04 0.612 0.540574
## modelDiscovery -1.078e+04 2.842e+04 -0.379 0.704423
## modelDiscovery Sport 9.233e+03 3.143e+04 0.294 0.768914
## modelDoblo ãðóç. -1.974e+04 8.952e+03 -2.205 0.027459 *
## modelDoblo ïàññ. -1.646e+04 8.890e+03 -1.851 0.064199 .
## modelDoblo Panorama -1.439e+04 1.327e+04 -1.084 0.278281
## modelDokker ïàññ. -6.721e+03 2.592e+04 -0.259 0.795397
## modelDS3 -9.108e+03 1.778e+04 -0.512 0.608413
## modelDS4 -8.755e+03 1.328e+04 -0.659 0.509659
## modelDS5 3.943e+02 1.452e+04 0.027 0.978342
## modelDucato ãðóç. -1.651e+04 1.032e+04 -1.600 0.109577
## modelDucato ïàññ. 1.703e+03 1.332e+04 0.128 0.898297
## modelDurango -2.905e+03 2.055e+04 -0.141 0.887606
## modelDuster -7.854e+03 2.438e+04 -0.322 0.747389
## modelE-Class 1.570e+04 1.791e+04 0.876 0.380905
## modelEastar 3.418e+03 9.180e+03 0.372 0.709644
## modelEclipse 3.652e+03 1.774e+04 0.206 0.836932
## modelÊëàññè÷åñêèå NA NA NA NA
## modelEL NA NA NA NA
## modelElantra 1.032e+04 1.664e+04 0.620 0.535234
## modelElara 2.975e+03 1.169e+04 0.255 0.799032
## modelElgrand 4.267e+03 1.484e+04 0.288 0.773676
## modelEmgrand 7 (EC7) 2.545e+03 9.081e+03 0.280 0.779312
## modelEmgrand 8 3.236e+03 1.107e+04 0.292 0.770156
## modelEmgrand X7 3.681e+03 1.329e+04 0.277 0.781848
## modelEos -1.090e+04 1.028e+04 -1.060 0.289037
## modelEpica -1.115e+04 7.161e+03 -1.557 0.119583
## modelES 200 -1.237e+04 1.778e+04 -0.696 0.486585
## modelES 300 -3.211e+03 1.263e+04 -0.254 0.799285
## modelES 330 -2.559e+03 1.778e+04 -0.144 0.885528
## modelES 350 -2.524e+03 1.098e+04 -0.230 0.818151
## modelEscalade 6.569e+04 1.772e+04 3.708 0.000210 ***
## modelEscort -1.146e+03 4.930e+03 -0.232 0.816161
## modelEscort van -3.173e+03 1.483e+04 -0.214 0.830569
## modelEspace 1.805e+03 2.490e+04 0.072 0.942211
## modelEspero 1.450e+04 1.020e+04 1.421 0.155303
## modelEvanda -8.447e+03 8.445e+03 -1.000 0.317181
## modelEX 37 -5.811e+04 2.045e+04 -2.841 0.004508 **
## modelExpert ïàññ. -5.475e+03 9.596e+03 -0.571 0.568344
## modelExplorer 1.843e+04 1.086e+04 1.697 0.089742 .
## modelExpress ïàññ. 1.272e+03 9.512e+03 0.134 0.893644
## modelF-150 4.235e+03 1.486e+04 0.285 0.775686
## modelF-350 7.256e+03 1.488e+04 0.488 0.625741
## modelF3 -2.137e+03 1.261e+04 -0.169 0.865455
## modelF3R -6.277e+03 1.778e+04 -0.353 0.724124
## modelFabia 1.642e+03 6.298e+03 0.261 0.794345
## modelFelicia 9.799e+03 9.446e+03 1.037 0.299598
## modelFiesta -1.467e+04 4.018e+03 -3.650 0.000264 ***
## modelFiorino ãðóç. -2.766e+04 1.331e+04 -2.078 0.037703 *
## modelFiorino ïàññ. -1.916e+04 1.067e+04 -1.796 0.072465 .
## modelFJ Cruiser 1.799e+04 6.851e+03 2.626 0.008646 **
## modelFluence -2.514e+03 2.421e+04 -0.104 0.917315
## modelFlying Spur -3.523e+05 1.778e+04 -19.819 < 2e-16 ***
## modelFocus -1.250e+04 3.881e+03 -3.221 0.001281 **
## modelForester 4.733e+03 1.468e+04 0.322 0.747095
## modelForfour -5.175e+03 1.619e+04 -0.320 0.749307
## modelFortuner 4.077e+03 1.507e+04 0.271 0.786772
## modelFortwo -5.557e+03 1.463e+04 -0.380 0.704148
## modelForza -1.040e+03 6.622e+03 -0.157 0.875240
## modelFreelander -1.765e+04 2.827e+04 -0.624 0.532453
## modelFrontera 5.744e+03 1.071e+04 0.536 0.591815
## modelFusion -1.309e+04 5.383e+03 -2.431 0.015069 *
## modelFX 30 -4.826e+04 1.671e+04 -2.888 0.003891 **
## modelFX 35 -6.064e+04 1.477e+04 -4.106 4.06e-05 ***
## modelFX 37 -5.346e+04 1.546e+04 -3.457 0.000550 ***
## modelFX 45 -6.300e+04 1.772e+04 -3.555 0.000381 ***
## modelG 320 2.577e+04 2.302e+04 1.119 0.263059
## modelG 350 2.561e+04 1.904e+04 1.345 0.178524
## modelG 500 5.291e+04 1.842e+04 2.872 0.004084 **
## modelG 55 AMG 4.677e+04 1.904e+04 2.457 0.014046 *
## modelG 63 AMG 1.354e+05 1.886e+04 7.180 7.55e-13 ***
## modelG25 -4.966e+04 1.627e+04 -3.052 0.002280 **
## modelG35 -6.035e+04 1.677e+04 -3.599 0.000321 ***
## modelG37 -5.491e+04 1.780e+04 -3.085 0.002042 **
## modelGalant 7.094e+03 1.473e+04 0.482 0.630024
## modelGalaxy -9.443e+03 1.073e+04 -0.880 0.378675
## modelGallardo NA NA NA NA
## modelGalloper 9.696e+03 2.201e+04 0.441 0.659514
## modelGC6 -1.310e+03 1.672e+04 -0.078 0.937556
## modelGenesis -2.276e+03 2.189e+04 -0.104 0.917215
## modelGentra -4.780e+03 1.015e+04 -0.471 0.637654
## modelGetz 8.369e+03 1.661e+04 0.504 0.614396
## modelGiulietta 7.074e+03 3.137e+04 0.225 0.821616
## modelGL 320 1.799e+04 1.853e+04 0.971 0.331721
## modelGL 350 4.122e+04 1.839e+04 2.242 0.025001 *
## modelGL 420 1.368e+04 2.302e+04 0.595 0.552145
## modelGL 450 1.483e+04 1.931e+04 0.768 0.442451
## modelGL 500 2.332e+04 2.062e+04 1.131 0.258032
## modelGL 550 3.216e+03 2.062e+04 0.156 0.876069
## modelGLC-Class 1.403e+04 1.976e+04 0.710 0.477675
## modelGLE-Class 2.698e+04 1.822e+04 1.481 0.138699
## modelGLK 220 1.332e+04 2.062e+04 0.646 0.518198
## modelGLK 300 1.992e+04 2.301e+04 0.865 0.386794
## modelGloria 1.117e+04 1.483e+04 0.754 0.451089
## modelGLS 350 5.467e+04 1.816e+04 3.011 0.002615 **
## modelGLS 400 5.764e+04 1.976e+04 2.917 0.003541 **
## modelGLS 500 3.198e+04 1.904e+04 1.679 0.093096 .
## modelGLS 63 1.703e+05 1.886e+04 9.032 < 2e-16 ***
## modelGolf GTI -1.791e+04 1.186e+04 -1.511 0.130898
## modelGolf II 5.464e+03 7.277e+03 0.751 0.452774
## modelGolf III -2.155e+03 6.852e+03 -0.315 0.753131
## modelGolf IV -7.074e+03 6.634e+03 -1.066 0.286255
## modelGolf Plus -1.074e+04 8.797e+03 -1.221 0.222051
## modelGolf V -1.119e+04 7.118e+03 -1.572 0.116039
## modelGolf Variant -1.107e+04 8.401e+03 -1.317 0.187819
## modelGolf VI -1.252e+04 7.103e+03 -1.762 0.078110 .
## modelGolf VII -7.963e+03 7.416e+03 -1.074 0.282988
## modelGran Move 1.036e+04 2.054e+04 0.505 0.613922
## modelGranada 1.760e+04 1.081e+04 1.628 0.103580
## modelGrand C4 Picasso -5.617e+03 1.449e+04 -0.388 0.698200
## modelGrand Cherokee -2.327e+04 7.425e+03 -3.134 0.001732 **
## modelGrand Marquis NA NA NA NA
## modelGrand Scenic -2.696e+03 2.413e+04 -0.112 0.911018
## modelGrand Vitara -7.202e+02 6.517e+03 -0.111 0.912003
## modelGrand Voyager -7.618e+03 1.670e+04 -0.456 0.648339
## modelGrande Punto -1.823e+04 1.184e+04 -1.539 0.123859
## modelGrandeur 1.729e+04 1.793e+04 0.965 0.334684
## modelGrandis -3.282e+03 1.620e+04 -0.203 0.839451
## modelGranTurismo NA NA NA NA
## modelGS 250 1.576e+04 1.774e+04 0.888 0.374425
## modelGS 300 -7.340e+02 1.089e+04 -0.067 0.946255
## modelGS 350 -6.076e+03 1.169e+04 -0.520 0.603251
## modelGT-R 7.408e+04 7.073e+03 10.473 < 2e-16 ***
## modelGX 5.044e+03 1.157e+04 0.436 0.662856
## modelH 100 ïàññ. 1.614e+04 2.189e+04 0.737 0.460896
## modelH 200 ãðóç. 2.085e+04 2.190e+04 0.952 0.341042
## modelH 200 ïàññ. 1.202e+04 2.190e+04 0.549 0.582980
## modelH1 ãðóç. 1.328e+04 1.935e+04 0.686 0.492511
## modelH1 ïàññ. 1.637e+04 1.731e+04 0.945 0.344519
## modelH2 1.957e+04 1.448e+04 1.352 0.176523
## modelH3 NA NA NA NA
## modelHaval -5.527e+02 2.053e+04 -0.027 0.978518
## modelHiace ïàññ. 1.725e+04 9.362e+03 1.843 0.065365 .
## modelHighlander 1.235e+04 5.832e+03 2.117 0.034272 *
## modelHilux 1.085e+04 5.994e+03 1.811 0.070188 .
## modelHover 9.086e+02 1.562e+04 0.058 0.953624
## modelHR-V -1.571e+04 2.053e+04 -0.765 0.444189
## modeli10 4.855e+03 1.791e+04 0.271 0.786277
## modeli20 5.309e+03 1.742e+04 0.305 0.760533
## modelI3 2.423e+04 2.054e+04 1.180 0.238198
## modeli30 6.617e+03 1.660e+04 0.399 0.690221
## modelÏàòðèîò NA NA NA NA
## modelIbiza -8.827e+03 7.480e+03 -1.180 0.237983
## modelÏðèîðà NA NA NA NA
## modelIgnis 7.796e+03 1.595e+04 0.489 0.624970
## modelImpreza 2.914e+03 1.506e+04 0.193 0.846586
## modelImpreza WRX STI 1.016e+04 1.618e+04 0.628 0.530229
## modelInsight -1.315e+04 1.680e+04 -0.783 0.433797
## modelInsignia 4.019e+03 7.759e+03 0.518 0.604446
## modelIntrepid 4.258e+03 2.050e+04 0.208 0.835489
## modelIQ 1.526e+03 1.497e+04 0.102 0.918812
## modelIS 200 -8.430e+02 1.324e+04 -0.064 0.949239
## modelIS 250 -2.320e+03 1.324e+04 -0.175 0.860935
## modelIS 300 -2.025e+03 1.256e+04 -0.161 0.871915
## modelIX35 9.394e+03 1.679e+04 0.560 0.575740
## modelix55 (Veracruz) 1.429e+04 1.808e+04 0.790 0.429430
## modelJ2 -3.557e+03 2.593e+04 -0.137 0.890882
## modelJaggi -1.418e+02 1.007e+04 -0.014 0.988767
## modelJazz -1.727e+04 1.776e+04 -0.972 0.330944
## modelJetta -6.356e+03 6.314e+03 -1.007 0.314138
## modelJimny -3.014e+03 1.563e+04 -0.193 0.847045
## modelJuke -8.515e+02 4.003e+03 -0.213 0.831541
## modelJuke Nismo -1.456e+03 1.468e+04 -0.099 0.921018
## modelJumper ãðóç. -7.019e+03 1.448e+04 -0.485 0.627779
## modelJumpy ãðóç. -7.175e+03 1.212e+04 -0.592 0.553736
## modelJumpy ïàññ. -3.649e+03 1.145e+04 -0.319 0.750040
## modelKA -8.229e+03 1.487e+04 -0.553 0.580008
## modelKadett 1.395e+04 7.633e+03 1.828 0.067613 .
## modelKangoo ãðóç. -7.830e+03 2.390e+04 -0.328 0.743176
## modelKangoo ïàññ. -2.577e+03 2.387e+04 -0.108 0.914017
## modelKimo 3.544e+02 1.168e+04 0.030 0.975801
## modelKizashi -1.144e+04 1.569e+04 -0.729 0.466099
## modelKoleos -4.484e+03 2.471e+04 -0.182 0.855976
## modelKorando 2.835e+03 1.527e+04 0.186 0.852752
## modelKoup -3.290e+03 8.784e+03 -0.375 0.707965
## modelKubistar -2.698e+03 1.477e+04 -0.183 0.855014
## modelKuga -1.122e+04 4.406e+03 -2.547 0.010874 *
## modelKyron -6.708e+02 1.542e+04 -0.043 0.965309
## modelL 200 -7.779e+03 1.523e+04 -0.511 0.609459
## modelLacetti -1.170e+04 6.281e+03 -1.863 0.062477 .
## modelLaguna 1.783e+03 2.390e+04 0.075 0.940552
## modelLancer -1.150e+03 1.461e+04 -0.079 0.937267
## modelLancer Evolution -4.171e+03 1.620e+04 -0.257 0.796877
## modelLancer X -3.229e+03 1.461e+04 -0.221 0.825079
## modelLancer X Sportback -4.966e+03 2.047e+04 -0.243 0.808367
## modelLand Cruiser 100 1.509e+04 5.586e+03 2.701 0.006925 **
## modelLand Cruiser 105 9.345e+03 1.507e+04 0.620 0.535218
## modelLand Cruiser 200 4.439e+04 4.719e+03 9.407 < 2e-16 ***
## modelLand Cruiser 76 4.002e+04 1.507e+04 2.655 0.007954 **
## modelLand Cruiser 80 1.556e+04 7.766e+03 2.003 0.045185 *
## modelLand Cruiser Prado 1.350e+04 4.533e+03 2.978 0.002909 **
## modelLandMark NA NA NA NA
## modelLanos -3.717e+02 5.722e+03 -0.065 0.948207
## modelLatitude 4.618e+02 2.783e+04 0.017 0.986760
## modelLeaf -7.985e+02 7.905e+03 -0.101 0.919545
## modelLegacy 5.081e+03 1.488e+04 0.341 0.732785
## modelLeganza 1.108e+04 1.175e+04 0.944 0.345438
## modelLegend -3.829e+03 1.777e+04 -0.215 0.829429
## modelLeon -6.626e+03 7.159e+03 -0.926 0.354680
## modelLHS 5.716e+03 2.050e+04 0.279 0.780367
## modelLinea -1.936e+04 1.187e+04 -1.630 0.103035
## modelLite Ace 1.948e+04 1.510e+04 1.291 0.196909
## modelLogan -6.765e+03 2.409e+04 -0.281 0.778814
## modelLS 400 8.100e+03 1.774e+04 0.457 0.648013
## modelLS 430 2.223e+03 1.774e+04 0.125 0.900328
## modelLS 460 7.002e+03 1.098e+04 0.638 0.523691
## modelLT ïàññ. -4.650e+03 9.430e+03 -0.493 0.621925
## modelLumina -1.051e+04 1.190e+04 -0.883 0.377100
## modelLupo -1.045e+04 1.184e+04 -0.882 0.377614
## modelLX 450 1.572e+04 1.174e+04 1.339 0.180661
## modelLX 470 1.606e+03 1.134e+04 0.142 0.887432
## modelLX 570 3.030e+04 1.091e+04 2.776 0.005518 **
## modelM11 -1.534e+02 1.170e+04 -0.013 0.989539
## modelM35 -6.052e+04 2.051e+04 -2.951 0.003177 **
## modelM37 -5.665e+04 2.050e+04 -2.763 0.005742 **
## modelM5 3.714e+04 1.529e+04 2.429 0.015155 *
## modelM6 6.046e+04 2.048e+04 2.952 0.003168 **
## modelMacan -4.016e+04 1.075e+04 -3.737 0.000187 ***
## modelMagentis 2.111e+03 4.016e+03 0.526 0.599059
## modelMalibu -3.385e+03 1.185e+04 -0.286 0.775125
## modelManta 2.119e+04 1.597e+04 1.327 0.184660
## modelMaple C81 NA NA NA NA
## modelMark II 2.597e+04 1.505e+04 1.725 0.084573 .
## modelMaster ãðóç. 6.237e+02 2.436e+04 0.026 0.979572
## modelMaster ïàññ. 1.324e+03 2.592e+04 0.051 0.959266
## modelMatiz -6.015e+03 6.303e+03 -0.954 0.339987
## modelMatrix 8.330e+03 1.505e+04 0.553 0.580043
## modelMaxima 8.978e+03 4.533e+03 1.981 0.047647 *
## modelMB ãðóç. 1.741e+04 2.300e+04 0.757 0.449046
## modelMDX -6.388e+03 1.588e+04 -0.402 0.687459
## modelMegane -3.685e+02 2.382e+04 -0.015 0.987657
## modelMicra -4.991e+03 4.803e+03 -1.039 0.298790
## modelMK 3.446e+03 9.453e+03 0.365 0.715469
## modelMK-2 2.844e+02 1.323e+04 0.022 0.982847
## modelMK Cross NA NA NA NA
## modelMKX -1.744e+04 1.626e+04 -1.073 0.283475
## modelML 250 1.671e+04 1.976e+04 0.846 0.397638
## modelML 270 3.408e+03 1.976e+04 0.173 0.863040
## modelML 280 9.509e+03 2.302e+04 0.413 0.679492
## modelML 320 6.922e+03 1.842e+04 0.376 0.707041
## modelML 350 1.698e+04 1.818e+04 0.934 0.350333
## modelML 400 4.022e+03 1.976e+04 0.204 0.838695
## modelML 430 4.903e+03 2.300e+04 0.213 0.831162
## modelML 500 2.554e+04 2.062e+04 1.238 0.215593
## modelML 550 1.362e+04 2.302e+04 0.592 0.554022
## modelML 63 AMG 2.823e+04 1.902e+04 1.484 0.137925
## modelModel S NA NA NA NA
## modelModus -4.724e+03 2.780e+04 -0.170 0.865054
## modelMohave 5.690e+03 1.467e+04 0.388 0.698134
## modelMondeo -6.570e+03 4.109e+03 -1.599 0.109907
## modelMPV 1.471e+04 2.281e+04 0.645 0.518922
## modelMulsanne NA NA NA NA
## modelMultivan 7.486e+03 6.829e+03 1.096 0.273020
## modelMurano 1.183e+03 4.621e+03 0.256 0.797887
## modelMustang 7.416e+03 6.122e+03 1.211 0.225820
## modelMustang GT 2.476e+04 1.076e+04 2.301 0.021392 *
## modelNavara -2.458e+03 1.063e+04 -0.231 0.817092
## modelNavigator -1.045e+04 1.626e+04 -0.642 0.520577
## modelNemo ãðóç. -1.410e+04 1.322e+04 -1.067 0.286178
## modelNemo ïàññ. -9.825e+03 1.322e+04 -0.743 0.457307
## modelNeon 6.237e+03 2.050e+04 0.304 0.760988
## modelNew Beetle -7.159e+03 1.183e+04 -0.605 0.545029
## modelNexia -1.239e+03 6.537e+03 -0.190 0.849621
## modelNitro -9.033e+03 2.055e+04 -0.440 0.660228
## modelNiva -1.830e+04 7.297e+03 -2.508 0.012168 *
## modelNote -3.703e+03 4.434e+03 -0.835 0.403595
## modelNubira 7.659e+03 7.121e+03 1.076 0.282162
## modelNV -8.559e+03 1.069e+04 -0.801 0.423234
## modelNX 200 9.558e+03 1.457e+04 0.656 0.511849
## modelNX 300 1.945e+04 1.780e+04 1.092 0.274668
## modelÒàâðèÿ-Íîâà 3.453e+03 1.495e+04 0.231 0.817342
## modelOctavia 8.585e+03 6.602e+03 1.300 0.193488
## modelOctavia A5 4.053e+03 6.219e+03 0.652 0.514644
## modelOctavia A7 6.328e+03 6.718e+03 0.942 0.346186
## modelOctavia Scout 2.696e+03 8.829e+03 0.305 0.760121
## modelOctavia Tour 5.771e+03 6.471e+03 0.892 0.372497
## modelOmega 1.298e+04 6.938e+03 1.871 0.061368 .
## modelOne -3.855e+03 2.048e+04 -0.188 0.850692
## modelOpirus 4.626e+03 1.473e+04 0.314 0.753521
## modelOptima 3.544e+03 1.473e+04 0.241 0.809903
## modelOrion 6.646e+02 1.078e+04 0.062 0.950843
## modelOutback 6.301e+03 1.494e+04 0.422 0.673185
## modelOutlander -4.628e+03 1.481e+04 -0.313 0.754583
## modelOutlander XL -3.559e+03 1.486e+04 -0.240 0.810714
## modelPaceman NA NA NA NA
## modelPacifica -6.705e+03 2.054e+04 -0.326 0.744132
## modelPajero 2.338e+03 1.571e+04 0.149 0.881684
## modelPajero Pinin -5.744e+03 2.050e+04 -0.280 0.779280
## modelPajero Sport -2.586e+03 1.482e+04 -0.174 0.861516
## modelPajero Wagon 8.956e+01 1.470e+04 0.006 0.995139
## modelPanamera NA NA NA NA
## modelPanda -9.158e+03 1.183e+04 -0.774 0.438942
## modelPartner ãðóç. -1.414e+04 9.034e+03 -1.565 0.117610
## modelPartner ïàññ. -7.873e+03 8.945e+03 -0.880 0.378808
## modelPassat B2 1.054e+04 1.026e+04 1.028 0.304154
## modelPassat B3 5.656e+03 6.874e+03 0.823 0.410685
## modelPassat B4 1.723e+03 7.000e+03 0.246 0.805578
## modelPassat B5 -6.145e+03 6.230e+03 -0.986 0.324049
## modelPassat B6 -9.284e+03 6.198e+03 -1.498 0.134190
## modelPassat B7 -6.657e+03 6.298e+03 -1.057 0.290580
## modelPassat B8 4.804e+03 8.799e+03 0.546 0.585084
## modelPassat CC -3.347e+03 6.732e+03 -0.497 0.619063
## modelPathfinder 3.538e+03 5.450e+03 0.649 0.516254
## modelPatriot -3.334e+04 1.585e+04 -2.104 0.035440 *
## modelPatrol 1.394e+04 4.625e+03 3.015 0.002581 **
## modelPhaeton 6.840e+02 8.120e+03 0.084 0.932869
## modelPhantom NA NA NA NA
## modelPhedra -5.675e+03 2.051e+04 -0.277 0.782084
## modelPicanto -3.884e+03 7.774e+03 -0.500 0.617421
## modelPilot -6.879e+03 1.594e+04 -0.432 0.666096
## modelPointer -1.433e+04 1.565e+04 -0.916 0.359845
## modelPolarsun Business Van -3.910e+03 2.052e+04 -0.191 0.848875
## modelPolo -1.501e+04 6.240e+03 -2.405 0.016200 *
## modelPony 2.222e+04 2.188e+04 1.016 0.309848
## modelPrelude 1.357e+03 1.776e+04 0.076 0.939100
## modelPremacy 1.138e+04 2.280e+04 0.499 0.617719
## modelPrevia 1.401e+04 1.503e+04 0.932 0.351375
## modelPrimastar ãðóç. -8.468e+03 1.069e+04 -0.792 0.428179
## modelPrimastar ïàññ. 3.442e+03 1.066e+04 0.323 0.746740
## modelPrimera 8.651e+03 4.191e+03 2.064 0.039039 *
## modelPrius 3.090e+03 8.254e+03 0.374 0.708148
## modelPro Ceed -2.841e+03 1.473e+04 -0.193 0.847052
## modelProbe 3.294e+03 1.485e+04 0.222 0.824441
## modelPT Cruiser -2.414e+03 1.623e+04 -0.149 0.881749
## modelPunto -1.830e+04 1.107e+04 -1.653 0.098432 .
## modelQ3 6.571e+03 9.215e+03 0.713 0.475789
## modelQ5 6.600e+03 7.681e+03 0.859 0.390227
## modelQ50 -4.644e+04 2.053e+04 -2.262 0.023720 *
## modelQ7 1.122e+04 6.882e+03 1.630 0.103081
## modelQ70 -4.729e+04 2.053e+04 -2.303 0.021277 *
## modelQashqai -4.355e+02 3.313e+03 -0.131 0.895445
## modelQashqai+2 -2.855e+03 1.469e+04 -0.194 0.845892
## modelQQ -6.933e+02 7.040e+03 -0.098 0.921555
## modelQubo ïàññ. -1.794e+04 1.327e+04 -1.352 0.176476
## modelQX50 -5.089e+04 1.771e+04 -2.873 0.004076 **
## modelQX70 -4.703e+04 1.525e+04 -3.085 0.002045 **
## modelQX80 NA NA NA NA
## modelR 320 7.022e+03 2.302e+04 0.305 0.760302
## modelR8 4.508e+04 9.729e+03 4.634 3.65e-06 ***
## modelRAM -4.385e+03 1.554e+04 -0.282 0.777832
## modelRam Van NA NA NA NA
## modelRange Rover 2.078e+04 2.784e+04 0.747 0.455380
## modelRange Rover Evoque -2.422e+03 2.835e+04 -0.085 0.931938
## modelRange Rover Sport 9.919e+03 2.797e+04 0.355 0.722856
## modelRanger -1.204e+04 7.300e+03 -1.649 0.099193 .
## modelRapid 9.237e+01 8.462e+03 0.011 0.991291
## modelRapide NA NA NA NA
## modelRav 4 2.898e+03 4.620e+03 0.627 0.530553
## modelRCZ NA NA NA NA
## modelRekord 2.151e+04 1.593e+04 1.350 0.177099
## modelRexton 1.876e+03 1.625e+04 0.115 0.908088
## modelRexton II 1.311e+03 1.505e+04 0.087 0.930584
## modelRexton W 2.715e+03 1.678e+04 0.162 0.871415
## modelRio -3.330e+03 3.908e+03 -0.852 0.394154
## modelRL -9.712e+03 1.780e+04 -0.546 0.585351
## modelRoadster NA NA NA NA
## modelRodius NA NA NA NA
## modelRoomster 8.871e+02 1.569e+04 0.057 0.954924
## modelRX-8 1.514e+04 1.884e+04 0.804 0.421629
## modelRX 200 -3.794e+03 1.457e+04 -0.260 0.794592
## modelRX 270 1.276e+04 1.457e+04 0.876 0.381310
## modelRX 300 -7.177e+03 1.125e+04 -0.638 0.523436
## modelRX 330 -7.456e+03 1.194e+04 -0.624 0.532346
## modelRX 350 1.835e+03 1.077e+04 0.170 0.864756
## modelRX 400 -9.596e+03 1.783e+04 -0.538 0.590396
## modelRX 450 4.139e+03 1.783e+04 0.232 0.816418
## modelS-Guard 1.379e+05 2.061e+04 6.690 2.38e-11 ***
## modelS-Type -7.133e+03 1.774e+04 -0.402 0.687620
## modelS 140 2.211e+04 1.903e+04 1.162 0.245357
## modelS 250 4.393e+04 2.301e+04 1.909 0.056298 .
## modelS 280 5.192e+04 2.061e+04 2.519 0.011792 *
## modelS 300 1.777e+04 2.301e+04 0.772 0.439978
## modelS 320 1.740e+04 1.842e+04 0.945 0.344941
## modelS 350 2.695e+04 1.800e+04 1.497 0.134513
## modelS 400 3.523e+04 1.858e+04 1.896 0.057971 .
## modelS 420 2.335e+04 2.302e+04 1.014 0.310468
## modelS 430 1.918e+04 2.062e+04 0.930 0.352300
## modelS 500 3.705e+04 1.797e+04 2.061 0.039300 *
## modelS 55 1.243e+04 2.306e+04 0.539 0.589783
## modelS 550 1.351e+04 1.830e+04 0.738 0.460476
## modelS 600 1.019e+05 1.869e+04 5.452 5.13e-08 ***
## modelS 63 AMG 1.268e+05 1.881e+04 6.738 1.71e-11 ***
## modelS 65 AMG 4.766e+04 2.061e+04 2.312 0.020791 *
## modelS2000 NA NA NA NA
## modelS4 1.920e+03 1.212e+04 0.158 0.874104
## modelS40 -8.140e+03 1.068e+04 -0.762 0.445963
## modelS5 4.486e+03 1.588e+04 0.282 0.777641
## modelS6 NA NA NA NA
## modelS60 -7.148e+03 1.066e+04 -0.670 0.502672
## modelS8 -1.203e+01 1.063e+04 -0.001 0.999097
## modelS80 -7.228e+03 8.888e+03 -0.813 0.416115
## modelSafari -2.780e+04 2.052e+04 -1.355 0.175590
## modelSafe NA NA NA NA
## modelSaibao NA NA NA NA
## modelSamurai 1.072e+04 1.565e+04 0.685 0.493297
## modelSandero -7.570e+03 2.447e+04 -0.309 0.757048
## modelSandero StepWay -9.726e+03 2.788e+04 -0.349 0.727185
## modelSanta FE 1.049e+04 1.670e+04 0.628 0.529817
## modelSavana NA NA NA NA
## modelSC 430 NA NA NA NA
## modelScenic -8.318e+02 2.399e+04 -0.035 0.972345
## modelScion 3.993e+03 1.501e+04 0.266 0.790269
## modelScirocco -6.793e+03 8.412e+03 -0.808 0.419369
## modelScorpio 7.257e+03 4.945e+03 1.467 0.142286
## modelScudo ãðóç. -1.806e+04 1.191e+04 -1.516 0.129520
## modelScudo ïàññ. -1.426e+04 9.532e+03 -1.496 0.134605
## modelSebring -3.043e+03 1.622e+04 -0.188 0.851246
## modelSens -1.853e+03 5.832e+03 -0.318 0.750645
## modelSentra -1.269e+03 7.831e+03 -0.162 0.871242
## modelSephia 1.106e+04 8.805e+03 1.256 0.208981
## modelSequoia 2.223e+04 1.508e+04 1.475 0.140350
## modelSharan -3.604e+03 7.412e+03 -0.486 0.626835
## modelShuma 5.521e+03 1.474e+04 0.375 0.707894
## modelShuttle NA NA NA NA
## modelSienna 2.276e+04 1.105e+04 2.060 0.039469 *
## modelSierra 7.552e+03 5.535e+03 1.364 0.172506
## modelSL 500 (550) 2.081e+04 2.303e+04 0.903 0.366312
## modelSL 55 AMG 3.364e+04 2.303e+04 1.461 0.144081
## modelSLK 200 1.143e+04 2.063e+04 0.554 0.579392
## modelSLK 350 5.104e+03 2.299e+04 0.222 0.824348
## modelSM5 NA NA NA NA
## modelSmart 4.509e+03 2.302e+04 0.196 0.844749
## modelSolaris 2.340e+03 2.185e+04 0.107 0.914743
## modelSolenza -4.149e+03 2.664e+04 -0.156 0.876216
## modelSonata 1.452e+04 1.666e+04 0.871 0.383557
## modelSorento 4.492e+02 3.306e+03 0.136 0.891915
## modelSoul -2.456e+03 7.038e+03 -0.349 0.727136
## modelSpace Star -2.333e+02 1.587e+04 -0.015 0.988276
## modelSpace Wagon 1.337e+04 2.049e+04 0.652 0.514279
## modelSpaceback -7.593e+02 1.191e+04 -0.064 0.949151
## modelSplash -3.962e+03 1.573e+04 -0.252 0.801088
## modelSportage NA NA NA NA
## modelSprinter 208 ïàññ. 1.558e+04 2.060e+04 0.756 0.449377
## modelSprinter 210 ãðóç. 1.400e+04 2.304e+04 0.608 0.543463
## modelSprinter 211 ïàññ. 1.079e+04 2.304e+04 0.469 0.639366
## modelSprinter 212 ïàññ. 1.373e+04 1.973e+04 0.696 0.486501
## modelSprinter 213 ïàññ. 8.979e+03 2.063e+04 0.435 0.663346
## modelSprinter 310 ïàññ. 1.276e+03 2.299e+04 0.055 0.955746
## modelSprinter 311 ïàññ. 3.472e+03 2.298e+04 0.151 0.879909
## modelSprinter 312 ãðóç. 1.354e+04 2.064e+04 0.656 0.511905
## modelSprinter 312 ïàññ. 1.912e+04 1.975e+04 0.968 0.333160
## modelSprinter 313 ãðóç. 5.840e+03 1.884e+04 0.310 0.756580
## modelSprinter 313 ïàññ. 1.383e+04 1.848e+04 0.748 0.454266
## modelSprinter 315 ïàññ. 9.859e+03 2.302e+04 0.428 0.668523
## modelSprinter 316 ãðóç. 8.591e+03 2.304e+04 0.373 0.709231
## modelSprinter 316 ïàññ. 1.115e+04 2.302e+04 0.484 0.628280
## modelSprinter 318 ïàññ. 2.198e+04 2.064e+04 1.065 0.286900
## modelSprinter 319 ãðóç. 8.744e+03 2.303e+04 0.380 0.704168
## modelSprinter 319 ïàññ. 1.434e+05 2.301e+04 6.235 4.75e-10 ***
## modelSprinter 324 ïàññ. 1.854e+05 2.304e+04 8.046 9.73e-16 ***
## modelSprinter ãðóç. 1.232e+04 2.304e+04 0.535 0.592938
## modelSRX NA NA NA NA
## modelStanza 2.103e+04 1.480e+04 1.421 0.155350
## modelStilo -1.066e+04 1.675e+04 -0.637 0.524334
## modelStratus 3.649e+03 2.050e+04 0.178 0.858706
## modelSunny 1.405e+04 7.855e+03 1.789 0.073669 .
## modelSuperb 8.229e+03 6.345e+03 1.297 0.194724
## modelSwift 9.024e+01 7.633e+03 0.012 0.990567
## modelSX4 -1.224e+03 7.905e+03 -0.155 0.876982
## modelSymbol -3.563e+03 2.417e+04 -0.147 0.882777
## modelSyncro -7.686e+03 1.570e+04 -0.490 0.624482
## modelT2 (Transporter) 6.649e+02 1.572e+04 0.042 0.966251
## modelT3 (Transporter) 2.157e+03 1.189e+04 0.181 0.856101
## modelT4 (Transporter) ãðóç -4.119e+03 7.879e+03 -0.523 0.601194
## modelT4 (Transporter) ïàññ. -3.265e+03 6.408e+03 -0.509 0.610452
## modelT5 (Transporter) ãðóç -1.379e+04 6.482e+03 -2.127 0.033439 *
## modelT5 (Transporter) ïàññ. -1.029e+04 6.306e+03 -1.631 0.102896
## modelT6 (Transporter) ãðóç -1.599e+04 7.890e+03 -2.026 0.042777 *
## modelT6 (Transporter) ïàññ. -9.461e+03 8.849e+03 -1.069 0.285043
## modelTacoma 1.179e+04 9.302e+03 1.267 0.205135
## modelTacuma -1.045e+04 8.864e+03 -1.179 0.238475
## modelTaurus 1.529e+03 1.486e+04 0.103 0.918050
## modelTeana 3.656e+03 5.139e+03 0.711 0.476857
## modelTempra -2.845e+03 1.673e+04 -0.170 0.864982
## modelTerios NA NA NA NA
## modelTerracan 7.195e+03 2.200e+04 0.327 0.743668
## modelTerrano -2.754e+02 1.054e+04 -0.026 0.979153
## modelThema NA NA NA NA
## modelTiggo NA NA NA NA
## modelTigra 3.748e+03 1.591e+04 0.236 0.813743
## modelTiguan -9.136e+03 7.044e+03 -1.297 0.194667
## modelTIIDA -1.514e+03 4.872e+03 -0.311 0.756029
## modelTipo -5.685e+03 1.106e+04 -0.514 0.607168
## modelTL -7.983e+03 1.628e+04 -0.490 0.623996
## modelTLX 6.961e+03 2.054e+04 0.339 0.734764
## modelToledo NA NA NA NA
## modelTouareg 9.131e+02 6.393e+03 0.143 0.886426
## modelTouran -9.957e+03 6.856e+03 -1.452 0.146449
## modelTourneo Connect ïàññ. -1.621e+04 7.921e+03 -2.046 0.040789 *
## modelTourneo Courier -1.773e+04 1.483e+04 -1.196 0.231780
## modelTown Car NA NA NA NA
## modelTrafic ãðóç. -4.533e+03 2.395e+04 -0.189 0.849922
## modelTrafic ïàññ. 7.322e+02 2.394e+04 0.031 0.975600
## modelTransit ãðóç. -1.004e+04 4.672e+03 -2.149 0.031698 *
## modelTransit Connect ãðóç. -1.803e+04 5.799e+03 -3.109 0.001884 **
## modelTransit Connect ïàññ. -1.363e+04 5.275e+03 -2.584 0.009774 **
## modelTransit Custom -1.309e+04 1.484e+04 -0.882 0.377991
## modelTransit ïàññ. NA NA NA NA
## modelTribeca 5.448e+03 1.508e+04 0.361 0.717886
## modelTribute 1.750e+04 2.283e+04 0.767 0.443299
## modelTrooper NA NA NA NA
## modelTT NA NA NA NA
## modelTucson 8.964e+03 1.665e+04 0.538 0.590429
## modelTundra 1.280e+04 7.657e+03 1.671 0.094762 .
## modelUno NA NA NA NA
## modelUp -1.902e+04 1.186e+04 -1.604 0.108745
## modelV 250 3.104e+04 1.833e+04 1.693 0.090468 .
## modelV40 -1.105e+04 1.068e+04 -1.035 0.300873
## modelV5 NA NA NA NA
## modelVaneo 4.407e+03 2.301e+04 0.192 0.848099
## modelVanette ïàññ. 1.186e+04 1.481e+04 0.800 0.423471
## modelVectra A 1.486e+04 7.355e+03 2.021 0.043343 *
## modelVectra B 8.039e+03 6.897e+03 1.166 0.243800
## modelVectra C 2.420e+03 6.885e+03 0.351 0.725229
## modelVento NA NA NA NA
## modelVenza 7.694e+03 6.613e+03 1.163 0.244722
## modelViano ïàññ. 2.082e+04 1.885e+04 1.105 0.269314
## modelVida NA NA NA NA
## modelVirage NA NA NA NA
## modelVista 1.422e+04 1.500e+04 0.948 0.343173
## modelVitara NA NA NA NA
## modelVito ãðóç. 2.527e+03 1.806e+04 0.140 0.888690
## modelVito ïàññ. 7.559e+03 1.794e+04 0.421 0.673506
## modelVivaro ãðóç. -4.642e+03 7.057e+03 -0.658 0.510729
## modelVivaro ïàññ. 1.001e+03 6.957e+03 0.144 0.885637
## modelVolt NA NA NA NA
## modelVoyager NA NA NA NA
## modelWrangler NA NA NA NA
## modelX-Trail NA NA NA NA
## modelX-Type -1.981e+04 1.677e+04 -1.181 0.237456
## modelX1 1.137e+04 1.519e+04 0.748 0.454229
## modelX3 1.665e+04 1.515e+04 1.099 0.271937
## modelX5 1.626e+04 1.463e+04 1.111 0.266511
## modelX5 M 2.915e+04 1.512e+04 1.928 0.053870 .
## modelX6 2.266e+04 1.474e+04 1.538 0.124148
## modelX6 M 6.120e+04 1.627e+04 3.761 0.000170 ***
## modelXantia -2.338e+03 1.777e+04 -0.132 0.895296
## modelXC60 -3.547e+03 9.708e+03 -0.365 0.714811
## modelXC70 -7.068e+03 9.706e+03 -0.728 0.466513
## modelXC90 NA NA NA NA
## modelXE 1.269e+03 1.774e+04 0.072 0.942960
## modelXedos 6 2.306e+04 1.903e+04 1.212 0.225595
## modelXedos 9 2.344e+04 2.036e+04 1.151 0.249634
## modelXenon NA NA NA NA
## modelXF -2.963e+03 1.527e+04 -0.194 0.846176
## modelXJR-S -6.139e+03 2.051e+04 -0.299 0.764743
## modelXKR NA NA NA NA
## modelXsara 6.073e+02 1.776e+04 0.034 0.972725
## modelXsara Picasso NA NA NA NA
## modelXV NA NA NA NA
## modelYaris NA NA NA NA
## modelYeti NA NA NA NA
## modelZ3 4.893e+03 2.052e+04 0.238 0.811500
## modelZ4 1.679e+04 1.592e+04 1.054 0.291705
## modelZafira NA NA NA NA
## modelZDX NA NA NA NA
## drivefront 9.816e+02 8.426e+02 1.165 0.244079
## drivefull 5.920e+03 1.060e+03 5.586 2.39e-08 ***
## driverear -1.891e+03 1.157e+03 -1.634 0.102202
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 14460 on 8244 degrees of freedom
## (434 observations deleted due to missingness)
## Multiple R-squared: 0.6741, Adjusted R-squared: 0.6387
## F-statistic: 19.01 on 897 and 8244 DF, p-value: < 2.2e-16
lm2$coefficients
## (Intercept) carAlfa Romeo
## -2.015805e+06 -7.942165e+03
## carAro carAston Martin
## -9.787049e+03 1.005115e+05
## carAudi carBentley
## -3.961125e+03 5.183110e+05
## carBMW carBogdan
## -1.204393e+04 -2.112371e+04
## carBuick carBYD
## 2.957075e+03 -1.625001e+04
## carCadillac carChery
## -4.289479e+03 -1.939635e+04
## carChevrolet carChrysler
## -1.956536e+03 -5.662228e+03
## carCitroen carDacia
## -8.106994e+03 -9.191727e+03
## carDadi carDaewoo
## -2.166529e+04 -1.499068e+04
## carDaihatsu carDodge
## -1.734503e+04 -3.518781e+03
## carËUAZ carFAW
## -7.287777e+03 -2.337219e+04
## carFerrari carFiat
## 1.027055e+05 1.510086e+03
## carFord carGAZ
## -2.058545e+03 1.343998e+04
## carGeely carGMC
## -2.265925e+04 1.077852e+04
## carGreat Wall carGroz
## -1.946351e+04 -1.408636e+04
## carHafei carHonda
## -1.555737e+04 -1.038419e+03
## carHuanghai carHummer
## -1.881125e+04 -5.461666e+03
## carHyundai carInfiniti
## -2.340053e+04 5.416771e+04
## carIsuzu carJAC
## 5.746168e+03 -2.384780e+04
## carJaguar carJeep
## 1.029319e+04 1.926307e+04
## carKia carLamborghini
## -1.290726e+04 9.831541e+04
## carLancia carLand Rover
## -5.558033e+03 7.140521e+03
## carLexus carLifan
## -2.245556e+01 -3.598762e+04
## carLincoln carMaserati
## 1.047675e+04 7.976814e+04
## carMazda carMercedes-Benz
## -2.599602e+04 -1.398999e+04
## carMercury carMG
## 4.073957e+03 -4.571640e+04
## carMINI carMitsubishi
## -6.121570e+03 -9.335848e+03
## carMoskvich-AZLK carMoskvich-Izh
## 1.784745e+04 -1.547534e+04
## carNissan carOpel
## -1.257233e+04 -1.211088e+04
## carOther-Retro carPeugeot
## 9.192389e+03 -6.783008e+03
## carPorsche carRenault
## 3.335021e+04 -1.264236e+04
## carRolls-Royce carRover
## 4.454470e+04 -1.668860e+04
## carSaab carSamand
## -3.149610e+03 -1.556205e+04
## carSamsung carSeat
## -1.015655e+04 -6.119103e+03
## carSkoda carSMA
## -1.641449e+04 -1.708640e+04
## carSmart carSsangYong
## -7.890806e+03 -1.815419e+04
## carSubaru carSuzuki
## -1.744039e+04 -1.367737e+04
## carTATA carTesla
## -2.392990e+04 4.273280e+04
## carToyota carUAZ
## -1.450525e+04 -1.834952e+04
## carVAZ carVolkswagen
## -1.641384e+04 -7.290719e+02
## carVolvo carWartburg
## 2.219615e+03 -1.360923e+03
## carZAZ carZX
## -2.184397e+04 -1.409197e+04
## bodyhatch bodyother
## -2.157732e+02 1.378778e+03
## bodysedan bodyvagon
## -1.706157e+03 -2.340800e+03
## bodyvan mileage
## 9.956673e+02 -2.831547e+01
## engV engTypeGas
## -1.785899e+00 -2.194121e+03
## engTypeOther engTypePetrol
## -2.615642e+03 -1.612055e+03
## year model1.3
## 1.017121e+03 NA
## model10 model100
## NA 8.975389e+03
## model106 model107
## 2.575587e+03 -1.278899e+04
## model11 model1102 Òàâðèÿ
## 9.670344e+03 9.368368e+03
## model1103 Ñëàâóòà model110557
## 5.574713e+03 3.148887e+03
## model1117 model1118
## -4.961790e+03 -1.111375e+02
## model1119 model116
## -2.427669e+03 4.288834e+03
## model118 model120
## 2.828867e+03 -5.244380e+03
## model125 model1301
## -2.384118e+03 -1.351512e+04
## model1302 model147
## -4.221697e+03 -1.447912e+02
## model156 model159
## -3.256779e+03 -4.709199e+02
## model19 model190
## 1.234978e+04 2.559759e+04
## model2 model200
## 6.248855e+03 1.967759e+04
## model2008 model205
## -7.385904e+03 4.251714e+03
## model206 model207
## -5.962000e+03 -8.701179e+03
## model208 model21
## -1.212169e+04 1.496667e+04
## model210 model2101
## 1.455309e+04 2.535232e+04
## model2102 model2103
## 2.690069e+04 3.079019e+04
## model2104 model2105
## 7.032116e+03 1.679815e+04
## model2106 model2107
## 2.039302e+04 6.593476e+03
## model2108 model2109
## 1.224311e+04 5.945474e+03
## model2109 (Áàëòèêà) model21093
## 1.470787e+03 1.318806e+03
## model21099 model2110
## 2.539204e+03 1.748788e+03
## model2111 model2112
## 2.895002e+03 6.617887e+02
## model2113 model2114
## -3.315906e+03 -3.911610e+03
## model2115 model2121
## -5.689691e+02 2.405346e+03
## model2123 model2140
## -1.328756e+03 -9.673352e+03
## model2141 model2170
## -2.230392e+04 -9.484257e+02
## model2171 model2172
## -2.521737e+03 -3.228472e+03
## model2190 Ãðàíòà model220
## -8.921414e+03 1.336325e+04
## model230 model24
## 2.197434e+04 3.034399e+03
## model240 model2410
## 9.291199e+03 -1.283579e+04
## model25 model250
## 1.835024e+04 1.951043e+04
## model2705 GAZåëü model2715
## -2.100357e+04 1.533610e+04
## model2717 model2752 Ñîáîëü
## NA -3.112197e+04
## model3 model300
## 1.457995e+04 2.397207e+04
## model300 C model300 M
## 3.805426e+03 -1.051273e+03
## model3008 model301
## -7.038425e+03 -1.156384e+04
## model306 model307
## -2.918710e+02 -3.206407e+03
## model308 model31029
## -9.650786e+03 -1.642708e+04
## model3110 model31105
## -2.512222e+04 -2.590185e+04
## model3151 model31512
## -1.227691e+04 3.223647e+03
## model31514 model316
## -1.126393e+04 1.376114e+04
## model3163 model318
## 6.111661e+03 1.161867e+04
## model320 model3221 GAZåëü
## 1.028819e+04 -2.809397e+04
## model32213 model323
## -2.256771e+04 2.285563e+04
## model324 model325
## 2.463964e+04 1.102297e+04
## model328 model33
## 1.721304e+04 7.129367e+03
## model330 model3302 GAZåëü
## 8.267213e+03 -2.904811e+04
## model335 model340
## 1.329931e+04 9.011096e+03
## model350 model350Z
## 2.703802e+04 8.224211e+03
## model3741 model4 Series Gran Coupe
## -6.179043e+03 2.394016e+04
## model403 model405
## 5.582242e+03 2.972865e+03
## model406 model407
## 2.654412e+03 -2.679016e+03
## model412 model428
## NA 2.055314e+04
## model452 ïàññ. model458 Italia
## 2.539417e+04 7.412481e+04
## model469 model469Á
## 1.519221e+04 1.360633e+04
## model4Runner model5
## 2.634370e+04 1.650595e+04
## model5 Series model5 Series GT
## 1.157145e+04 2.421017e+04
## model500 model500 L
## -1.960643e+04 -1.651113e+04
## model5008 model508
## -3.520776e+03 -2.935815e+03
## model520 model523
## 1.805388e+04 1.398656e+04
## model524 model525
## 2.194079e+04 1.395680e+04
## model528 model530
## 1.561676e+04 1.211881e+04
## model535 model540
## 1.523754e+04 1.769523e+04
## model545 model550
## 1.631037e+04 4.178779e+04
## model6 model6 MPS
## 1.772826e+04 1.030939e+04
## model6 Series Gran Coupe model605
## 6.259630e+04 1.188382e+04
## model607 model626
## -3.670591e+03 2.508646e+04
## model630 model640
## 1.270153e+03 5.485658e+04
## model645 model650
## 1.601120e+04 1.452817e+04
## model730 model735
## 2.009454e+04 1.636195e+04
## model740 model745
## 1.844440e+04 1.397763e+04
## model75 model750
## 9.626506e+03 3.698365e+04
## model760 model80
## 1.842108e+04 7.858956e+03
## model850 model9
## -9.926691e+02 1.732866e+04
## model9-May model90
## NA 4.602083e+03
## model911 model965
## 2.088128e+03 4.507216e+04
## model968 model969 Âîëûíü
## 1.813727e+04 -7.395161e+03
## model969Ì modelA 140
## NA 4.139461e+03
## modelA 150 modelA 170
## 4.252292e+03 4.351774e+03
## modelA 180 modelA1
## 9.475842e+03 -7.814162e+03
## modelA3 modelA4
## -4.967233e+03 -8.821618e+02
## modelA4 Allroad modelA5
## 1.476780e+03 3.964348e+03
## modelA6 modelA6 Allroad
## -1.201862e+03 -2.327747e+03
## modelA7 modelA8
## 2.679591e+04 5.186580e+03
## modelAcadia modelAccent
## -2.580547e+04 7.904987e+03
## modelAccord modelActyon
## -5.610312e+03 -2.345552e+03
## modelActyon Sports modelAgila
## -5.343059e+03 7.118466e+03
## modelAlmera modelAlpina
## 3.438038e+02 -1.940547e+04
## modelAltea modelAltea XL
## -7.988014e+03 -4.035927e+03
## modelAltima modelAmarok
## 2.974996e+03 -1.581237e+04
## modelAmpera modelAmulet
## 4.050196e+03 2.185499e+03
## modelAntara modelArmada
## -1.247371e+04 5.230682e+03
## modelAscona modelAstra F
## 1.880128e+04 1.092521e+04
## modelAstra G modelAstra H
## 2.214073e+03 -1.658568e+03
## modelAstra J modelAstro ïàññ.
## -6.006250e+03 -1.166465e+04
## modelASX modelAuris
## -2.960439e+03 3.372013e+01
## modelAurora modelAvalon
## NA 1.049047e+04
## modelAvenger modelAvensis
## -8.783481e+03 6.341098e+03
## modelAveo modelAygo
## -1.340004e+04 -5.489799e+03
## modelB-Max modelB 170
## -1.651707e+04 6.529066e+03
## modelB 180 modelB 200
## 4.154229e+03 3.739951e+03
## modelBDD modelBeat
## 4.974416e+03 -3.438434e+03
## modelBeetle modelBentayga
## -6.128149e+03 -1.948120e+05
## modelBerlingo ãðóç. modelBerlingo ïàññ.
## -9.099984e+03 -8.325977e+03
## modelBesta modelBipper ïàññ.
## 9.199104e+03 -1.196952e+04
## modelBluebird modelBora
## 2.335426e+04 -4.968743e+03
## modelBoxer ãðóç. modelBoxer ïàññ.
## -3.486750e+03 4.391780e+03
## modelBravo modelC-Class
## -6.677771e+03 1.480877e+04
## modelC-Elysee modelC-Max
## -1.482398e+04 -1.177333e+04
## modelC1 modelC3
## -1.172353e+04 -8.730503e+03
## modelC3 Picasso modelC30
## -8.754201e+03 -2.045160e+03
## modelC4 modelC4 Picasso
## -7.222688e+03 -2.500344e+03
## modelC5 modelCabrio
## -2.513134e+03 -2.926646e+03
## modelCaddy modelCaddy ãðóç.
## -1.733642e+04 -1.642612e+04
## modelCaddy ïàññ. modelCaliber
## -1.323214e+04 -9.797078e+03
## modelCalibra modelCalifornia
## 1.280380e+04 NA
## modelCamaro modelCamry
## 2.188595e+04 8.770679e+03
## modelCaptiva modelCaptur
## -1.121740e+04 -2.923462e+03
## modelCaravelle modelCarens
## -6.296203e+03 -1.666636e+03
## modelCarina modelCarisma
## 1.659918e+04 3.070521e+03
## modelCarnival modelCayenne
## 5.705863e+02 -2.613263e+04
## modelCayman modelCeed
## -2.599823e+04 -6.697569e+02
## modelCefiro modelCelica
## 9.672923e+03 9.869136e+03
## modelCentury modelCerato
## NA -5.769328e+02
## modelChallenger modelCherokee
## 2.356920e+04 -2.713786e+04
## modelCinquecento modelCity
## -6.961650e+03 -1.382141e+03
## modelCivic modelCK
## -8.603677e+03 4.114651e+03
## modelCK-2 modelCK1
## 1.307988e+03 4.923656e+03
## modelCL 180 modelCL 500
## 1.536086e+04 1.926923e+04
## modelCL 55 AMG modelCL 550
## 2.669960e+04 2.837341e+04
## modelCL 63 AMG modelCLA-Class
## 4.682603e+04 2.212788e+04
## modelCLA 200 modelCLA 220
## 1.740845e+04 2.609976e+04
## modelClarus modelCLC 180
## 8.730931e+03 1.089261e+04
## modelCLC 200 modelClio
## 7.602439e+03 3.638160e+02
## modelCLK 200 modelCLK 220
## 9.499886e+03 8.478406e+03
## modelCLK 230 modelCLK 240
## 6.620562e+03 1.231198e+04
## modelCLK 280 modelCLK 320
## 1.406420e+04 1.314610e+04
## modelCLK 430 modelCLS 350
## 9.941288e+03 1.732940e+04
## modelCLS 400 modelCLS 500
## 7.568349e+04 4.297879e+04
## modelCLS 63 AMG modelCobalt
## 4.910483e+04 -1.306408e+04
## modelColt modelCombo ãðóç.
## -3.576099e+03 -5.077903e+03
## modelCombo ïàññ. modelCompass
## -1.899481e+03 -3.389942e+04
## modelContinental modelCooper
## -4.613645e+05 -1.278165e+03
## modelCooper S modelCordoba
## -3.405569e+03 -2.465377e+03
## modelCorolla modelCorolla Verso
## 5.480827e+03 9.041233e+03
## modelCorsa modelCorvette
## 1.355613e+03 3.278407e+04
## modelCountryman modelCoupe
## -2.041692e+03 9.473582e+03
## modelCourier modelCR-V
## -1.301140e+04 -9.668443e+03
## modelCross Touran modelCrossEastar
## -9.268824e+03 8.085330e+03
## modelCrossfire modelCrosstour
## -6.867158e+03 -7.854605e+03
## modelCruze modelCT
## -1.190764e+04 -2.455112e+03
## modelCuore modelCX-5
## 5.672239e+03 1.731173e+04
## modelCX-7 modelCX-9
## 1.065163e+04 1.339689e+04
## modelD-Max modelDaimler
## -2.525046e+04 1.500214e+03
## modelDB9 modelDefender
## -5.686783e+04 1.818386e+04
## modelDiscovery modelDiscovery Sport
## -1.078200e+04 9.233338e+03
## modelDoblo ãðóç. modelDoblo ïàññ.
## -1.974255e+04 -1.645655e+04
## modelDoblo Panorama modelDokker ïàññ.
## -1.438557e+04 -6.720881e+03
## modelDS3 modelDS4
## -9.107876e+03 -8.754697e+03
## modelDS5 modelDucato ãðóç.
## 3.943023e+02 -1.651160e+04
## modelDucato ïàññ. modelDurango
## 1.703038e+03 -2.904543e+03
## modelDuster modelE-Class
## -7.853842e+03 1.569605e+04
## modelEastar modelEclipse
## 3.418207e+03 3.651614e+03
## modelÊëàññè÷åñêèå modelEL
## NA NA
## modelElantra modelElara
## 1.031500e+04 2.975231e+03
## modelElgrand modelEmgrand 7 (EC7)
## 4.267035e+03 2.544754e+03
## modelEmgrand 8 modelEmgrand X7
## 3.235818e+03 3.680717e+03
## modelEos modelEpica
## -1.090428e+04 -1.114783e+04
## modelES 200 modelES 300
## -1.236989e+04 -3.211030e+03
## modelES 330 modelES 350
## -2.559182e+03 -2.523610e+03
## modelEscalade modelEscort
## 6.569081e+04 -1.146303e+03
## modelEscort van modelEspace
## -3.172720e+03 1.805410e+03
## modelEspero modelEvanda
## 1.449884e+04 -8.447332e+03
## modelEX 37 modelExpert ïàññ.
## -5.811366e+04 -5.474545e+03
## modelExplorer modelExpress ïàññ.
## 1.842543e+04 1.271759e+03
## modelF-150 modelF-350
## 4.235489e+03 7.256237e+03
## modelF3 modelF3R
## -2.136587e+03 -6.276804e+03
## modelFabia modelFelicia
## 1.641833e+03 9.798527e+03
## modelFiesta modelFiorino ãðóç.
## -1.466759e+04 -2.765640e+04
## modelFiorino ïàññ. modelFJ Cruiser
## -1.916436e+04 1.799277e+04
## modelFluence modelFlying Spur
## -2.513698e+03 -3.523013e+05
## modelFocus modelForester
## -1.250363e+04 4.733203e+03
## modelForfour modelFortuner
## -5.174661e+03 4.076704e+03
## modelFortwo modelForza
## -5.557003e+03 -1.039689e+03
## modelFreelander modelFrontera
## -1.764845e+04 5.744162e+03
## modelFusion modelFX 30
## -1.308699e+04 -4.826327e+04
## modelFX 35 modelFX 37
## -6.063929e+04 -5.345515e+04
## modelFX 45 modelG 320
## -6.299756e+04 2.576585e+04
## modelG 350 modelG 500
## 2.561485e+04 5.291434e+04
## modelG 55 AMG modelG 63 AMG
## 4.676762e+04 1.353880e+05
## modelG25 modelG35
## -4.966103e+04 -6.034805e+04
## modelG37 modelGalant
## -5.490682e+04 7.093908e+03
## modelGalaxy modelGallardo
## -9.442919e+03 NA
## modelGalloper modelGC6
## 9.695658e+03 -1.309902e+03
## modelGenesis modelGentra
## -2.275688e+03 -4.779917e+03
## modelGetz modelGiulietta
## 8.368760e+03 7.074017e+03
## modelGL 320 modelGL 350
## 1.799033e+04 4.121718e+04
## modelGL 420 modelGL 450
## 1.368425e+04 1.483229e+04
## modelGL 500 modelGL 550
## 2.332436e+04 3.215936e+03
## modelGLC-Class modelGLE-Class
## 1.402985e+04 2.698361e+04
## modelGLK 220 modelGLK 300
## 1.332306e+04 1.991678e+04
## modelGloria modelGLS 350
## 1.117409e+04 5.467057e+04
## modelGLS 400 modelGLS 500
## 5.764460e+04 3.197985e+04
## modelGLS 63 modelGolf GTI
## 1.703239e+05 -1.791311e+04
## modelGolf II modelGolf III
## 5.463621e+03 -2.155253e+03
## modelGolf IV modelGolf Plus
## -7.074478e+03 -1.074232e+04
## modelGolf V modelGolf Variant
## -1.118868e+04 -1.106535e+04
## modelGolf VI modelGolf VII
## -1.251549e+04 -7.962867e+03
## modelGran Move modelGranada
## 1.036010e+04 1.760306e+04
## modelGrand C4 Picasso modelGrand Cherokee
## -5.616887e+03 -2.326746e+04
## modelGrand Marquis modelGrand Scenic
## NA -2.696481e+03
## modelGrand Vitara modelGrand Voyager
## -7.201845e+02 -7.617905e+03
## modelGrande Punto modelGrandeur
## -1.822506e+04 1.729475e+04
## modelGrandis modelGranTurismo
## -3.282379e+03 NA
## modelGS 250 modelGS 300
## 1.575834e+04 -7.339496e+02
## modelGS 350 modelGT-R
## -6.076176e+03 7.407638e+04
## modelGX modelH 100 ïàññ.
## 5.043867e+03 1.614451e+04
## modelH 200 ãðóç. modelH 200 ïàññ.
## 2.084791e+04 1.202272e+04
## modelH1 ãðóç. modelH1 ïàññ.
## 1.328309e+04 1.636812e+04
## modelH2 modelH3
## 1.956982e+04 NA
## modelHaval modelHiace ïàññ.
## -5.527343e+02 1.725416e+04
## modelHighlander modelHilux
## 1.234679e+04 1.085491e+04
## modelHover modelHR-V
## 9.085809e+02 -1.570696e+04
## modeli10 modeli20
## 4.855204e+03 5.308515e+03
## modelI3 modeli30
## 2.422900e+04 6.616773e+03
## modelÏàòðèîò modelIbiza
## NA -8.827052e+03
## modelÏðèîðà modelIgnis
## NA 7.795718e+03
## modelImpreza modelImpreza WRX STI
## 2.914079e+03 1.015904e+04
## modelInsight modelInsignia
## -1.315039e+04 4.019280e+03
## modelIntrepid modelIQ
## 4.257639e+03 1.526041e+03
## modelIS 200 modelIS 250
## -8.430073e+02 -2.320247e+03
## modelIS 300 modelIX35
## -2.024790e+03 9.393626e+03
## modelix55 (Veracruz) modelJ2
## 1.428950e+04 -3.557444e+03
## modelJaggi modelJazz
## -1.417595e+02 -1.727155e+04
## modelJetta modelJimny
## -6.355871e+03 -3.014418e+03
## modelJuke modelJuke Nismo
## -8.515198e+02 -1.455819e+03
## modelJumper ãðóç. modelJumpy ãðóç.
## -7.019322e+03 -7.175486e+03
## modelJumpy ïàññ. modelKA
## -3.649269e+03 -8.229193e+03
## modelKadett modelKangoo ãðóç.
## 1.395187e+04 -7.830248e+03
## modelKangoo ïàññ. modelKimo
## -2.577282e+03 3.543525e+02
## modelKizashi modelKoleos
## -1.143671e+04 -4.484351e+03
## modelKorando modelKoup
## 2.834652e+03 -3.290440e+03
## modelKubistar modelKuga
## -2.698486e+03 -1.122344e+04
## modelKyron modelL 200
## -6.707519e+02 -7.779300e+03
## modelLacetti modelLaguna
## -1.170334e+04 1.782708e+03
## modelLancer modelLancer Evolution
## -1.149961e+03 -4.170682e+03
## modelLancer X modelLancer X Sportback
## -3.229476e+03 -4.965942e+03
## modelLand Cruiser 100 modelLand Cruiser 105
## 1.508912e+04 9.345253e+03
## modelLand Cruiser 200 modelLand Cruiser 76
## 4.439472e+04 4.001899e+04
## modelLand Cruiser 80 modelLand Cruiser Prado
## 1.555726e+04 1.349907e+04
## modelLandMark modelLanos
## NA -3.716825e+02
## modelLatitude modelLeaf
## 4.617616e+02 -7.984877e+02
## modelLegacy modelLeganza
## 5.080783e+03 1.108488e+04
## modelLegend modelLeon
## -3.828954e+03 -6.625961e+03
## modelLHS modelLinea
## 5.716398e+03 -1.935985e+04
## modelLite Ace modelLogan
## 1.948295e+04 -6.765290e+03
## modelLS 400 modelLS 430
## 8.100410e+03 2.222570e+03
## modelLS 460 modelLT ïàññ.
## 7.001913e+03 -4.650315e+03
## modelLumina modelLupo
## -1.051189e+04 -1.044561e+04
## modelLX 450 modelLX 470
## 1.571546e+04 1.605708e+03
## modelLX 570 modelM11
## 3.029534e+04 -1.533505e+02
## modelM35 modelM37
## -6.051995e+04 -5.664668e+04
## modelM5 modelM6
## 3.713927e+04 6.045520e+04
## modelMacan modelMagentis
## -4.016110e+04 2.111429e+03
## modelMalibu modelManta
## -3.384599e+03 2.118927e+04
## modelMaple C81 modelMark II
## NA 2.596703e+04
## modelMaster ãðóç. modelMaster ïàññ.
## 6.236672e+02 1.323793e+03
## modelMatiz modelMatrix
## -6.014645e+03 8.329827e+03
## modelMaxima modelMB ãðóç.
## 8.978287e+03 1.741319e+04
## modelMDX modelMegane
## -6.387544e+03 -3.684902e+02
## modelMicra modelMK
## -4.990905e+03 3.445759e+03
## modelMK-2 modelMK Cross
## 2.843684e+02 NA
## modelMKX modelML 250
## -1.744473e+04 1.671148e+04
## modelML 270 modelML 280
## 3.407993e+03 9.509264e+03
## modelML 320 modelML 350
## 6.921552e+03 1.697740e+04
## modelML 400 modelML 430
## 4.021601e+03 4.903130e+03
## modelML 500 modelML 550
## 2.553701e+04 1.362058e+04
## modelML 63 AMG modelModel S
## 2.822643e+04 NA
## modelModus modelMohave
## -4.724482e+03 5.690023e+03
## modelMondeo modelMPV
## -6.570072e+03 1.471332e+04
## modelMulsanne modelMultivan
## NA 7.486311e+03
## modelMurano modelMustang
## 1.183281e+03 7.415583e+03
## modelMustang GT modelNavara
## 2.475622e+04 -2.457620e+03
## modelNavigator modelNemo ãðóç.
## -1.044970e+04 -1.409568e+04
## modelNemo ïàññ. modelNeon
## -9.824794e+03 6.236766e+03
## modelNew Beetle modelNexia
## -7.158777e+03 -1.239419e+03
## modelNitro modelNiva
## -9.032795e+03 -1.829995e+04
## modelNote modelNubira
## -3.703135e+03 7.659035e+03
## modelNV modelNX 200
## -8.558637e+03 9.558150e+03
## modelNX 300 modelÒàâðèÿ-Íîâà
## 1.944592e+04 3.452689e+03
## modelOctavia modelOctavia A5
## 8.584945e+03 4.052923e+03
## modelOctavia A7 modelOctavia Scout
## 6.328464e+03 2.695649e+03
## modelOctavia Tour modelOmega
## 5.771053e+03 1.298088e+04
## modelOne modelOpirus
## -3.854708e+03 4.626242e+03
## modelOptima modelOrion
## 3.544130e+03 6.646261e+02
## modelOutback modelOutlander
## 6.300614e+03 -4.628348e+03
## modelOutlander XL modelPaceman
## -3.559265e+03 NA
## modelPacifica modelPajero
## -6.705203e+03 2.338248e+03
## modelPajero Pinin modelPajero Sport
## -5.744469e+03 -2.585741e+03
## modelPajero Wagon modelPanamera
## 8.956267e+01 NA
## modelPanda modelPartner ãðóç.
## -9.157502e+03 -1.413794e+04
## modelPartner ïàññ. modelPassat B2
## -7.873268e+03 1.054357e+04
## modelPassat B3 modelPassat B4
## 5.655785e+03 1.723118e+03
## modelPassat B5 modelPassat B6
## -6.144644e+03 -9.284409e+03
## modelPassat B7 modelPassat B8
## -6.656788e+03 4.803942e+03
## modelPassat CC modelPathfinder
## -3.347196e+03 3.537869e+03
## modelPatriot modelPatrol
## -3.333588e+04 1.394270e+04
## modelPhaeton modelPhantom
## 6.840094e+02 NA
## modelPhedra modelPicanto
## -5.674639e+03 -3.883569e+03
## modelPilot modelPointer
## -6.878877e+03 -1.433031e+04
## modelPolarsun Business Van modelPolo
## -3.910353e+03 -1.500558e+04
## modelPony modelPrelude
## 2.221852e+04 1.357014e+03
## modelPremacy modelPrevia
## 1.138184e+04 1.400967e+04
## modelPrimastar ãðóç. modelPrimastar ïàññ.
## -8.468127e+03 3.442398e+03
## modelPrimera modelPrius
## 8.650502e+03 3.089916e+03
## modelPro Ceed modelProbe
## -2.840774e+03 3.293683e+03
## modelPT Cruiser modelPunto
## -2.413748e+03 -1.830240e+04
## modelQ3 modelQ5
## 6.571100e+03 6.599914e+03
## modelQ50 modelQ7
## -4.644030e+04 1.122025e+04
## modelQ70 modelQashqai
## -4.729024e+04 -4.354543e+02
## modelQashqai+2 modelQQ
## -2.854642e+03 -6.932892e+02
## modelQubo ïàññ. modelQX50
## -1.793993e+04 -5.089151e+04
## modelQX70 modelQX80
## -4.703081e+04 NA
## modelR 320 modelR8
## 7.021928e+03 4.507958e+04
## modelRAM modelRam Van
## -4.385443e+03 NA
## modelRange Rover modelRange Rover Evoque
## 2.078340e+04 -2.421513e+03
## modelRange Rover Sport modelRanger
## 9.918506e+03 -1.203664e+04
## modelRapid modelRapide
## 9.237125e+01 NA
## modelRav 4 modelRCZ
## 2.897523e+03 NA
## modelRekord modelRexton
## 2.150627e+04 1.875845e+03
## modelRexton II modelRexton W
## 1.311416e+03 2.715465e+03
## modelRio modelRL
## -3.330156e+03 -9.711918e+03
## modelRoadster modelRodius
## NA NA
## modelRoomster modelRX-8
## 8.870826e+02 1.514165e+04
## modelRX 200 modelRX 270
## -3.793780e+03 1.275785e+04
## modelRX 300 modelRX 330
## -7.176608e+03 -7.455629e+03
## modelRX 350 modelRX 400
## 1.834800e+03 -9.596406e+03
## modelRX 450 modelS-Guard
## 4.138872e+03 1.379064e+05
## modelS-Type modelS 140
## -7.132891e+03 2.210890e+04
## modelS 250 modelS 280
## 4.392917e+04 5.192391e+04
## modelS 300 modelS 320
## 1.776959e+04 1.739522e+04
## modelS 350 modelS 400
## 2.694631e+04 3.522564e+04
## modelS 420 modelS 430
## 2.334580e+04 1.918064e+04
## modelS 500 modelS 55
## 3.705033e+04 1.243183e+04
## modelS 550 modelS 600
## 1.350789e+04 1.019062e+05
## modelS 63 AMG modelS 65 AMG
## 1.267669e+05 4.766120e+04
## modelS2000 modelS4
## NA 1.920316e+03
## modelS40 modelS5
## -8.139687e+03 4.485830e+03
## modelS6 modelS60
## NA -7.148008e+03
## modelS8 modelS80
## -1.202619e+01 -7.228142e+03
## modelSafari modelSafe
## -2.779967e+04 NA
## modelSaibao modelSamurai
## NA 1.072259e+04
## modelSandero modelSandero StepWay
## -7.569776e+03 -9.725745e+03
## modelSanta FE modelSavana
## 1.049160e+04 NA
## modelSC 430 modelScenic
## NA -8.318207e+02
## modelScion modelScirocco
## 3.992611e+03 -6.792981e+03
## modelScorpio modelScudo ãðóç.
## 7.256556e+03 -1.805510e+04
## modelScudo ïàññ. modelSebring
## -1.426285e+04 -3.042666e+03
## modelSens modelSentra
## -1.853459e+03 -1.269245e+03
## modelSephia modelSequoia
## 1.106318e+04 2.223015e+04
## modelSharan modelShuma
## -3.603920e+03 5.521257e+03
## modelShuttle modelSienna
## NA 2.276384e+04
## modelSierra modelSL 500 (550)
## 7.552047e+03 2.080972e+04
## modelSL 55 AMG modelSLK 200
## 3.363800e+04 1.143415e+04
## modelSLK 350 modelSM5
## 5.103555e+03 NA
## modelSmart modelSolaris
## 4.508794e+03 2.339518e+03
## modelSolenza modelSonata
## -4.149290e+03 1.451638e+04
## modelSorento modelSoul
## 4.492001e+02 -2.455960e+03
## modelSpace Star modelSpace Wagon
## -2.332689e+02 1.336672e+04
## modelSpaceback modelSplash
## -7.592860e+02 -3.961986e+03
## modelSportage modelSprinter 208 ïàññ.
## NA 1.558110e+04
## modelSprinter 210 ãðóç. modelSprinter 211 ïàññ.
## 1.399751e+04 1.079488e+04
## modelSprinter 212 ïàññ. modelSprinter 213 ïàññ.
## 1.373048e+04 8.979255e+03
## modelSprinter 310 ïàññ. modelSprinter 311 ïàññ.
## 1.275897e+03 3.471797e+03
## modelSprinter 312 ãðóç. modelSprinter 312 ïàññ.
## 1.353798e+04 1.911753e+04
## modelSprinter 313 ãðóç. modelSprinter 313 ïàññ.
## 5.839637e+03 1.383235e+04
## modelSprinter 315 ïàññ. modelSprinter 316 ãðóç.
## 9.858695e+03 8.591404e+03
## modelSprinter 316 ïàññ. modelSprinter 318 ïàññ.
## 1.114715e+04 2.198349e+04
## modelSprinter 319 ãðóç. modelSprinter 319 ïàññ.
## 8.743535e+03 1.434322e+05
## modelSprinter 324 ïàññ. modelSprinter ãðóç.
## 1.853828e+05 1.231758e+04
## modelSRX modelStanza
## NA 2.102533e+04
## modelStilo modelStratus
## -1.066244e+04 3.649115e+03
## modelSunny modelSuperb
## 1.405147e+04 8.228549e+03
## modelSwift modelSX4
## 9.024449e+01 -1.223629e+03
## modelSymbol modelSyncro
## -3.563283e+03 -7.686182e+03
## modelT2 (Transporter) modelT3 (Transporter)
## 6.649366e+02 2.156902e+03
## modelT4 (Transporter) ãðóç modelT4 (Transporter) ïàññ.
## -4.118608e+03 -3.264624e+03
## modelT5 (Transporter) ãðóç modelT5 (Transporter) ïàññ.
## -1.378834e+04 -1.028640e+04
## modelT6 (Transporter) ãðóç modelT6 (Transporter) ïàññ.
## -1.598636e+04 -9.460789e+03
## modelTacoma modelTacuma
## 1.178658e+04 -1.044970e+04
## modelTaurus modelTeana
## 1.528943e+03 3.656082e+03
## modelTempra modelTerios
## -2.845158e+03 NA
## modelTerracan modelTerrano
## 7.194734e+03 -2.754237e+02
## modelThema modelTiggo
## NA NA
## modelTigra modelTiguan
## 3.748222e+03 -9.135645e+03
## modelTIIDA modelTipo
## -1.513847e+03 -5.685410e+03
## modelTL modelTLX
## -7.982642e+03 6.960768e+03
## modelToledo modelTouareg
## NA 9.131180e+02
## modelTouran modelTourneo Connect ïàññ.
## -9.956878e+03 -1.620579e+04
## modelTourneo Courier modelTown Car
## -1.773166e+04 NA
## modelTrafic ãðóç. modelTrafic ïàññ.
## -4.532623e+03 7.322224e+02
## modelTransit ãðóç. modelTransit Connect ãðóç.
## -1.003779e+04 -1.802763e+04
## modelTransit Connect ïàññ. modelTransit Custom
## -1.363341e+04 -1.308600e+04
## modelTransit ïàññ. modelTribeca
## NA 5.447939e+03
## modelTribute modelTrooper
## 1.749969e+04 NA
## modelTT modelTucson
## NA 8.963939e+03
## modelTundra modelUno
## 1.279526e+04 NA
## modelUp modelV 250
## -1.902086e+04 3.104002e+04
## modelV40 modelV5
## -1.104534e+04 NA
## modelVaneo modelVanette ïàññ.
## 4.406689e+03 1.185568e+04
## modelVectra A modelVectra B
## 1.486285e+04 8.039145e+03
## modelVectra C modelVento
## 2.420183e+03 NA
## modelVenza modelViano ïàññ.
## 7.693691e+03 2.082080e+04
## modelVida modelVirage
## NA NA
## modelVista modelVitara
## 1.422371e+04 NA
## modelVito ãðóç. modelVito ïàññ.
## 2.527196e+03 7.559191e+03
## modelVivaro ãðóç. modelVivaro ïàññ.
## -4.641814e+03 1.000597e+03
## modelVolt modelVoyager
## NA NA
## modelWrangler modelX-Trail
## NA NA
## modelX-Type modelX1
## -1.980953e+04 1.137119e+04
## modelX3 modelX5
## 1.664610e+04 1.625746e+04
## modelX5 M modelX6
## 2.915127e+04 2.266048e+04
## modelX6 M modelXantia
## 6.119778e+04 -2.338361e+03
## modelXC60 modelXC70
## -3.547372e+03 -7.067776e+03
## modelXC90 modelXE
## NA 1.269169e+03
## modelXedos 6 modelXedos 9
## 2.305923e+04 2.344024e+04
## modelXenon modelXF
## NA -2.962705e+03
## modelXJR-S modelXKR
## -6.139425e+03 NA
## modelXsara modelXsara Picasso
## 6.073262e+02 NA
## modelXV modelYaris
## NA NA
## modelYeti modelZ3
## NA 4.893203e+03
## modelZ4 modelZafira
## 1.678831e+04 NA
## modelZDX drivefront
## NA 9.815673e+02
## drivefull driverear
## 5.919524e+03 -1.891308e+03
Model 3:
Independant variable : car, body, mileage , engV, engType, year, drive Dependant variable : Price
Price = a1body + a2mileage + a3engV + a4year + a5*drive
model3 <- price ~ body + mileage + engV + engType + year + drive
lm3 <- lm(model3, data = car)
summary(lm3)
##
## Call:
## lm(formula = model3, data = car)
##
## Residuals:
## Min 1Q Median 3Q Max
## -44779 -7281 -1767 3628 513451
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -1.776e+06 7.686e+04 -23.100 < 2e-16 ***
## bodyhatch -1.353e+03 1.028e+03 -1.316 0.188048
## bodyother 3.383e+03 1.013e+03 3.340 0.000842 ***
## bodysedan 1.459e+03 8.570e+02 1.703 0.088661 .
## bodyvagon -2.135e+03 1.079e+03 -1.980 0.047772 *
## bodyvan -8.229e+02 1.063e+03 -0.774 0.438742
## mileage -3.507e+01 2.696e+00 -13.007 < 2e-16 ***
## engV 1.610e+02 3.625e+01 4.442 9.04e-06 ***
## engTypeGas -5.061e+03 6.863e+02 -7.374 1.80e-13 ***
## engTypeOther -2.555e+03 1.317e+03 -1.940 0.052447 .
## engTypePetrol -1.607e+03 5.719e+02 -2.811 0.004953 **
## year 8.939e+02 3.816e+01 23.423 < 2e-16 ***
## drivefront -3.309e+03 1.068e+03 -3.097 0.001958 **
## drivefull 1.527e+04 1.202e+03 12.702 < 2e-16 ***
## driverear 6.875e+03 1.182e+03 5.818 6.16e-09 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 20370 on 9127 degrees of freedom
## (434 observations deleted due to missingness)
## Multiple R-squared: 0.2841, Adjusted R-squared: 0.283
## F-statistic: 258.7 on 14 and 9127 DF, p-value: < 2.2e-16
Conclusion : if p values is less than 0.05, then we can conclude that the variable has significant influence on the dependant variable. So in this case we can see that price of the car is dependant on mileage, engV, year and drive.
lm3$coefficients
## (Intercept) bodyhatch bodyother bodysedan bodyvagon
## -1.775587e+06 -1.352740e+03 3.383328e+03 1.459139e+03 -2.135348e+03
## bodyvan mileage engV engTypeGas engTypeOther
## -8.229218e+02 -3.507133e+01 1.610203e+02 -5.061318e+03 -2.554650e+03
## engTypePetrol year drivefront drivefull driverear
## -1.607488e+03 8.939098e+02 -3.308648e+03 1.527086e+04 6.874516e+03
Logistic Regression
lm4 <- glm(registration~price+mileage+engV+year,family=binomial(link='logit'),data=car)
## Warning: glm.fit: fitted probabilities numerically 0 or 1 occurred
summary(lm4)
##
## Call:
## glm(formula = registration ~ price + mileage + engV + year, family = binomial(link = "logit"),
## data = car)
##
## Deviance Residuals:
## Min 1Q Median 3Q Max
## -4.5706 0.0355 0.1768 0.3496 2.8079
##
## Coefficients:
## Estimate Std. Error z value Pr(>|z|)
## (Intercept) 6.342e+01 1.545e+01 4.105 4.04e-05 ***
## price 3.067e-04 1.694e-05 18.104 < 2e-16 ***
## mileage -6.822e-03 4.915e-04 -13.881 < 2e-16 ***
## engV -1.894e-03 5.431e-03 -0.349 0.727
## year -3.062e-02 7.704e-03 -3.975 7.03e-05 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## (Dispersion parameter for binomial family taken to be 1)
##
## Null deviance: 4041.7 on 9141 degrees of freedom
## Residual deviance: 3069.5 on 9137 degrees of freedom
## (434 observations deleted due to missingness)
## AIC: 3079.5
##
## Number of Fisher Scoring iterations: 9
lm4$coefficients
## (Intercept) price mileage engV year
## 63.4230602821 0.0003066927 -0.0068224185 -0.0018937914 -0.0306238097
Depending on p value , we note that registration is dependant on price, mileage, year.
Insights Based on Regression Analysis
1 ) Price is strongly dependant on Mileage and Prive is negatively related to mileage 2 ) Price is strongly dependant on engV and price is positively related to engV 3 ) Price is strongly dependant on year and price is positively related to year 4 ) Price is strongly dependant on drive and price is positively related to drive 5 ) Hence we conclude that price of car is strongly dependant on mileage of the car, engV of the car, year of production of the car.