Project Title : Analyzing the Relationship between the prices of the car and other variables.

Name : R Sai Harshini

Email : harshini9898@gmail.com

College : IITM

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)

  1. To Read the dataset in R and visualize the length and breadth of your dataset.

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

Checking the type of varibales

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 ...
  1. To create a descriptive statistics (min, max, median etc) of each variable.
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
  1. To create two-way contingency tables for the categorical variables in the dataset
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.

Histogram for car variable

library(lattice)
histogram(~car, data = car,main = "Distribution of Manufacturing Brand of the cars", xlab="Car Brand", ylab = "Number of cars", col='blue' ) 

Histogram for price variable

histogram(~price, data = car,main = "Distribution of Price of cars", xlab="Price", ylab = "Number of cars",col='yellow' ) 

histogram for body variable

histogram(~body, data = car,main = "Distribution of body type of the cars", xlab="Body type", ylab="Number of cars",col='green' ) 

histogram for mileage variable

histogram(~mileage, data = car,main = "Distribution of Mileage", xlab="Mileage", ylab="Number of cars",col='red') 

histogram for engV variable

histogram(~engV, data = car,main = "Distribution of Engine Volume", xlab="Engine Volume",ylab="Number of cars", col='purple' ) 

histogram for year variable

histogram(~year, data = car,main = "Distribution of year of Production", xlab="Year",ylab="Number of cars", col='orange' ) 

  1. To draw suitable plot for the data fields.

Price vs Mileage

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")

Price vs engV

scatterplot(car$engV, car$price,main="Scatterplot of Price vs Engine Volume",
     xlab="Engine Volume", ylab="Price")

price vs Year

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))

  1. To create a correlation matrix.
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.

  1. To create a scatter plot matrix for the data set
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").

  1. To run a suitable test to check the hypothesis for your suitable assumptions(using cortest)

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

To find out on what variables the variable registration( whether the car is regosterd in Ukraine ot not) depends on.

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.