ABCDEFGHIJKLMNOPQ
1
Regression analysis
2
3
4
BrandPriceMileageEngineVYear
5
Mercedes-Benz
 $ 222,000.00 16.32016
Goal: Predict the price of a used car,depending on its specification
6
Mercedes-Benz
 $ 177,000.00 15.52016
7
Mercedes-Benz
 $ 177,777.00 15.52016
1. Brand, as a BMW is more expensive than a Toyota
8
Mercedes-Benz
 $ 199,999.00 15.52016
2. Mileage, as a more a car is driven, the cheaper it must be
9
Mercedes-Benz
 $ 199,999.00 15.52016
3. Engine volume, as sports cars have larger engines than economy cars
10
Mercedes-Benz
 $ 199,999.00 15.52016
4. Year of production, as the older the car, the cheaper it is
11
Mercedes-Benz
 $ 199,999.00 15.52016
12
Mercedes-Benz
 $ 185,555.00 14.72016
13
Mercedes-Benz
 $ 187,555.00 14.72016
Data Cleaning Steps
14
Mercedes-Benz
 $ 189,999.00 14.72016
1. Removed rows that were missing price
15
Mercedes-Benz
 $ 129,999.00 14.672016
2. Replaced NULLS with 0s in mileage column
16
Mercedes-Benz
 $ 154,999.00 14.62016
3. Remove NULLS in Engine Volume colume
17
Toyota $ 99,999.00 14.52016
4. Removed extreme values in Engine Volume column which seems unreasonable
18
Toyota $ 99,999.00 14.52016
5. Price is the dependent variable
19
Toyota $ 99,999.00 14.52016
20
Toyota $ 100,000.00 14.52016
21
Toyota $ 102,999.00 14.52016
22
Toyota $ 103,999.00 14.52016
23
Toyota $ 103,999.00 14.52016
24
Toyota $ 195,000.00 14.52016
25
Toyota $ 195,000.00 14.52016
26
BMW $ 139,000.00 14.42016
27
Mercedes-Benz
 $ 124,000.00 142016
28
Mercedes-Benz
 $ 109,000.00 13.52016
29
Volkswagen $ 66,346.00 132016
30
Volkswagen $ 67,622.55 132016
31
Volkswagen $ 71,138.00 132016
32
Volkswagen $ 72,000.00 132016
33
Audi $ 80,999.00 132016
34
Audi $ 81,500.00 132016
35
BMW $ 86,999.00 132016
36
BMW $ 86,999.00 132016
37
Audi $ 92,222.00 132016
38
Mercedes-Benz
 $ 99,000.00 132016
39
Mercedes-Benz
 $ 99,000.00 132016
40
Mercedes-Benz
 $ 99,999.00 132016
41
BMW $ 99,999.00 132016
42
Mercedes-Benz
 $ 103,333.00 132016
43
Mercedes-Benz
 $ 107,777.00 132016
44
Mercedes-Benz
 $ 107,999.00 132016
45
Mercedes-Benz
 $ 109,999.00 132016
46
Mercedes-Benz
 $ 110,000.00 132016
47
Mercedes-Benz
 $ 111,999.00 132016
48
Mercedes-Benz
 $ 111,999.00 132016
49
Mercedes-Benz
 $ 114,999.00 132016
50
Mercedes-Benz
 $ 124,000.00 132016
51
Mercedes-Benz
 $ 124,999.00 132016
52
Mercedes-Benz
 $ 138,000.00 132016
53
Mercedes-Benz
 $ 159,999.00 132016
54
Mercedes-Benz
 $ 173,333.00 132016
55
Mercedes-Benz
 $ 99,999.00 12.992016
56
Mercedes-Benz
 $ 114,999.00 12.992016
57
Audi $ 81,999.00 12.982016
58
Mercedes-Benz
 $ 105,999.00 12.982016
59
Mercedes-Benz
 $ 107,999.00 12.982016
60
Mercedes-Benz
 $ 109,999.00 12.982016
61
Mercedes-Benz
 $ 109,999.00 12.982016
62
Toyota $ 43,999.00 12.82016
63
Toyota $ 25,749.75 12.52016
64
Toyota $ 28,787.85 12.52016
65
Toyota $ 41,900.00 12.52016
66
BMW $ 65,000.00 12.52016
67
BMW $ 69,999.00 12.52016
68
Mercedes-Benz
 $ 97,555.00 12.52016
69
Mitsubishi $ 33,000.00 12.42016
70
Mitsubishi $ 36,000.00 12.42016
71
Toyota $ 38,233.00 12.42016
72
Mitsubishi $ 40,800.00 12.42016
73
Mitsubishi $ 40,990.00 12.42016
74
Mitsubishi $ 46,000.00 12.42016
75
Mercedes-Benz
 $ 47,600.00 12.22016
76
Mercedes-Benz
 $ 47,600.00 12.22016
77
Mercedes-Benz
 $ 47,600.00 12.22016
78
Mercedes-Benz
 $ 47,600.00 12.22016
79
Mercedes-Benz
 $ 58,999.00 12.22016
80
Mercedes-Benz
 $ 62,999.00 12.22016
81
Mercedes-Benz
 $ 69,999.00 12.22016
82
Mercedes-Benz
 $ 70,999.00 12.22016
83
Mercedes-Benz
 $ 71,999.00 12.22016
84
Mercedes-Benz
 $ 71,999.00 12.22016
85
Mercedes-Benz
 $ 87,777.00 12.22016
86
Mercedes-Benz
 $ 102,800.00 12.22016
87
Mercedes-Benz
 $ 107,000.00 12.22016
88
Mercedes-Benz
 $ 109,999.00 12.22016
89
Mitsubishi $ 25,000.00 122016
90
Mitsubishi $ 28,500.00 122016
91
Volkswagen $ 34,899.14 122016
92
Toyota $ 35,138.29 122016
93
BMW $ 37,976.25 122016
94
Volkswagen $ 38,365.00 122016
95
Volkswagen $ 39,615.00 122016
96
BMW $ 40,755.00 122016
97
BMW $ 43,163.25 122016
98
BMW $ 43,719.00 122016
99
BMW $ 47,500.00 122016
100
BMW $ 48,535.50 122016