Car Pricing and Profitability Analytics.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Total Data	11914	11914	11914	11911	11845	11884	11914	11914	11908	11914	11914	11914	11914	11914	11914	11914
2	Missing Data	0	0	0	3	69	30	0	0	6	0	0	0	0	0	0	0
3
4
5		Make	Model	Year	Engine Fuel Type	Engine HP	Engine Cylinders	Transmission Type	Driven_Wheels	Number of Doors	Market Category	Vehicle Size	Vehicle Style	highway MPG	city mpg	Popularity	MSRP
6		Ford	Aerostar	1995	regular unleaded	135	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Cargo Minivan	22	16	5657	$ 2,000
7		Ford	Aerostar	1995	regular unleaded	135	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Passenger Minivan	22	15	5657	$ 2,000
8		Ford	Aerostar	1995	regular unleaded	155	6	AUTOMATIC	all wheel drive	3	N/A	Large	Passenger Minivan	18	14	5657	$ 2,000
9		Ford	Aerostar	1995	regular unleaded	135	6	AUTOMATIC	rear wheel drive	3	N/A	Large	Passenger Minivan	22	15	5657	$ 2,000
10		Ford	Aerostar	1996	regular unleaded	140	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Passenger Minivan	21	15	5657	$ 2,000
11		Ford	Aerostar	1996	regular unleaded	155	6	AUTOMATIC	all wheel drive	3	N/A	Large	Passenger Minivan	19	13	5657	$ 2,000
12		Ford	Aerostar	1996	regular unleaded	140	6	AUTOMATIC	rear wheel drive	3	N/A	Large	Passenger Minivan	21	15	5657	$ 2,000
13		Ford	Aerostar	1996	regular unleaded	140	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Cargo Minivan	22	16	5657	$ 2,000
14		Ford	Aerostar	1997	regular unleaded	140	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Cargo Minivan	21	15	5657	$ 2,000
15		Ford	Aerostar	1997	regular unleaded	140	6	AUTOMATIC	rear wheel drive	3	N/A	Large	Passenger Minivan	22	15	5657	$ 2,000
16		Ford	Aerostar	1997	regular unleaded	152	6	AUTOMATIC	all wheel drive	3	N/A	Large	Passenger Minivan	17	13	5657	$ 2,000
17		Ford	Aerostar	1997	regular unleaded	140	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Passenger Minivan	22	15	5657	$ 2,000
18		Ford	Aspire	1995	regular unleaded	63	4	MANUAL	front wheel drive	2	Hatchback	Compact	2dr Hatchback	38	31	5657	$ 2,000
19		Ford	Aspire	1995	regular unleaded	63	4	MANUAL	front wheel drive	2	Hatchback	Compact	2dr Hatchback	38	31	5657	$ 2,000
20		Ford	Aspire	1995	regular unleaded	63	4	MANUAL	front wheel drive	4	Hatchback	Compact	4dr Hatchback	38	31	5657	$ 2,000
21		Ford	Aspire	1996	regular unleaded	63	4	MANUAL	front wheel drive	4	Hatchback	Compact	4dr Hatchback	38	29	5657	$ 2,000
22		Ford	Aspire	1996	regular unleaded	63	4	MANUAL	front wheel drive	2	Hatchback	Compact	2dr Hatchback	38	29	5657	$ 2,000
23		Ford	Aspire	1997	regular unleaded	63	4	MANUAL	front wheel drive	2	Hatchback	Compact	2dr Hatchback	38	29	5657	$ 2,000
24		Ford	Aspire	1997	regular unleaded	63	4	MANUAL	front wheel drive	4	Hatchback	Compact	4dr Hatchback	38	29	5657	$ 2,000
25		Ford	Bronco II	1990	regular unleaded	140	6	MANUAL	rear wheel drive	2	N/A	Compact	2dr SUV	20	16	5657	$ 2,000
26		Ford	Bronco II	1990	regular unleaded	140	6	MANUAL	rear wheel drive	2	N/A	Compact	2dr SUV	20	16	5657	$ 2,000
27		Ford	Bronco II	1990	regular unleaded	140	6	MANUAL	four wheel drive	2	N/A	Compact	2dr SUV	20	15	5657	$ 2,000
28		Ford	Bronco II	1990	regular unleaded	140	6	MANUAL	four wheel drive	2	N/A	Compact	2dr SUV	20	15	5657	$ 2,000
29		Ford	Bronco II	1990	regular unleaded	140	6	MANUAL	four wheel drive	2	N/A	Compact	2dr SUV	20	15	5657	$ 2,000
30		Ford	Bronco II	1990	regular unleaded	140	6	MANUAL	rear wheel drive	2	N/A	Compact	2dr SUV	20	16	5657	$ 2,000
31		Ford	Bronco II	1990	regular unleaded	140	6	MANUAL	four wheel drive	2	N/A	Compact	2dr SUV	20	15	5657	$ 2,000
32		Ford	Bronco II	1990	regular unleaded	140	6	MANUAL	rear wheel drive	2	N/A	Compact	2dr SUV	20	16	5657	$ 2,000
33		Ford	Bronco	1994	regular unleaded	185	8	MANUAL	four wheel drive	2	N/A	Midsize	2dr SUV	16	12	5657	$ 2,308
34		Ford	Bronco	1994	regular unleaded	185	8	AUTOMATIC	four wheel drive	2	N/A	Midsize	2dr SUV	17	12	5657	$ 2,585
35		Ford	Bronco	1994	regular unleaded	185	8	MANUAL	four wheel drive	2	N/A	Midsize	2dr SUV	16	12	5657	$ 2,396
36		Ford	Bronco	1995	regular unleaded	205	8	MANUAL	four wheel drive	2	N/A	Midsize	2dr SUV	16	12	5657	$ 2,620
37		Ford	Bronco	1995	regular unleaded	205	8	AUTOMATIC	four wheel drive	2	N/A	Midsize	2dr SUV	17	12	5657	$ 2,872
38		Ford	Bronco	1995	regular unleaded	205	8	MANUAL	four wheel drive	2	N/A	Midsize	2dr SUV	16	12	5657	$ 2,474
39		Ford	Bronco	1996	regular unleaded	199	8	MANUAL	four wheel drive	2	N/A	Midsize	2dr SUV	16	13	5657	$ 2,774
40		Ford	Bronco	1996	regular unleaded	199	8	MANUAL	four wheel drive	2	N/A	Midsize	2dr SUV	16	13	5657	$ 2,996
41		Ford	Bronco	1996	regular unleaded	199	8	AUTOMATIC	four wheel drive	2	N/A	Midsize	2dr SUV	16	11	5657	$ 3,248
42		Ford	C-Max Hybrid	2015	regular unleaded	188	4	AUTOMATIC	front wheel drive	4	Hybrid	Compact	Wagon	37	42	5657	$ 27,170
43		Ford	C-Max Hybrid	2015	regular unleaded	188	4	AUTOMATIC	front wheel drive	4	Hybrid	Compact	Wagon	37	42	5657	$ 24,170
44		Ford	C-Max Hybrid	2016	regular unleaded	188	4	AUTOMATIC	front wheel drive	4	Hybrid	Compact	Wagon	37	42	5657	$ 24,170
45		Ford	C-Max Hybrid	2016	regular unleaded	188	4	AUTOMATIC	front wheel drive	4	Hybrid	Compact	Wagon	37	42	5657	$ 27,170
46		Ford	C-Max Hybrid	2017	regular unleaded	188	4	AUTOMATIC	front wheel drive	4	Hybrid	Compact	Wagon	37	42	5657	$ 24,120
47		Ford	C-Max Hybrid	2017	regular unleaded	188	4	AUTOMATIC	front wheel drive	4	Hybrid	Compact	Wagon	37	42	5657	$ 27,120
48		Ford	Contour SVT	1998	regular unleaded	195	6	MANUAL	front wheel drive	4	Factory Tuner,Performance	Midsize	Sedan	26	17	5657	$ 2,655
49		Ford	Contour SVT	1999	regular unleaded	200	6	MANUAL	front wheel drive	4	Factory Tuner,Performance	Midsize	Sedan	26	17	5657	$ 2,702
50		Ford	Contour SVT	2000	regular unleaded	200	6	MANUAL	front wheel drive	4	Factory Tuner,Performance	Midsize	Sedan	27	18	5657	$ 2,937
51		Ford	Contour	1998	regular unleaded	125	4	MANUAL	front wheel drive	4	N/A	Midsize	Sedan	32	21	5657	$ 2,000
52		Ford	Contour	1998	regular unleaded	125	4	MANUAL	front wheel drive	4	N/A	Midsize	Sedan	32	21	5657	$ 2,000
53		Ford	Contour	1998	regular unleaded	125	4	MANUAL	front wheel drive	4	N/A	Midsize	Sedan	32	21	5657	$ 2,000
54		Ford	Contour	1998	regular unleaded	125	4	MANUAL	front wheel drive	4	N/A	Midsize	Sedan	32	21	5657	$ 2,000
55		Ford	Contour	1999	regular unleaded	125	4	MANUAL	front wheel drive	4	N/A	Midsize	Sedan	31	21	5657	$ 2,000
56		Ford	Contour	1999	regular unleaded	125	4	MANUAL	front wheel drive	4	N/A	Midsize	Sedan	31	21	5657	$ 2,000
57		Ford	Contour	2000	regular unleaded	170	6	MANUAL	front wheel drive	4	N/A	Midsize	Sedan	27	18	5657	$ 2,000
58		Ford	Contour	2000	regular unleaded	125	4	MANUAL	front wheel drive	4	N/A	Midsize	Sedan	31	21	5657	$ 2,079
59		Ford	Crown Victoria	2009	flex-fuel (unleaded/E85)	224	8	AUTOMATIC	rear wheel drive	4	Flex Fuel	Large	Sedan	24	16	5657	$ 29,205
60		Ford	Crown Victoria	2010	flex-fuel (unleaded/E85)	224	8	AUTOMATIC	rear wheel drive	4	Flex Fuel	Large	Sedan	24	16	5657	$ 29,905
61		Ford	Crown Victoria	2011	flex-fuel (unleaded/E85)	239	8	AUTOMATIC	rear wheel drive	4	Flex Fuel	Large	Sedan	24	16	5657	$ 29,905
62		Ford	E-150	1996	regular unleaded	199	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Passenger Van	15	11	5657	$ 2,000
63		Ford	E-150	1996	regular unleaded	145	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Cargo Van	14	12	5657	$ 2,000
64		Ford	E-150	1996	regular unleaded	145	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Passenger Van	15	11	5657	$ 2,000
65		Ford	E-150	1996	regular unleaded	145	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Passenger Van	15	11	5657	$ 2,000
66		Ford	E-150	1996	regular unleaded	145	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Cargo Van	14	12	5657	$ 2,000
67		Ford	E-150	1997	regular unleaded	200	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Passenger Van	17	12	5657	$ 2,000
68		Ford	E-150	1997	regular unleaded	200	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Passenger Van	17	12	5657	$ 2,123
69		Ford	E-150	1997	regular unleaded	200	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Passenger Van	17	12	5657	$ 2,074
70		Ford	E-150	1997	regular unleaded	200	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Cargo Van	18	14	5657	$ 2,000
71		Ford	E-150	1998	regular unleaded	200	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Passenger Van	17	12	5657	$ 2,301
72		Ford	E-150	1998	regular unleaded	200	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Cargo Van	18	13	5657	$ 2,079
73		Ford	E-150	1998	regular unleaded	200	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Passenger Van	17	12	5657	$ 2,256
74		Ford	E-150	1998	regular unleaded	200	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Passenger Van	17	12	5657	$ 2,169
75		Ford	E-250	1996	regular unleaded	199	6	AUTOMATIC	rear wheel drive	3	N/A	Large	Cargo Van	13	11	5657	$ 2,000
76		Ford	E-250	1996	regular unleaded	145	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Cargo Van	13	11	5657	$ 2,000
77		Ford	E-250	1996	regular unleaded	199	6	AUTOMATIC	rear wheel drive	3	N/A	Large	Cargo Van	13	11	5657	$ 2,000
78		Ford	E-250	1996	regular unleaded	145	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Cargo Van	13	11	5657	$ 2,000
79		Ford	E-250	1997	regular unleaded	200	6	AUTOMATIC	rear wheel drive	3	N/A	Large	Cargo Van	17	12	5657	$ 2,000
80		Ford	E-250	1997	regular unleaded	200	6	AUTOMATIC	rear wheel drive	3	N/A	Large	Cargo Van	17	12	5657	$ 2,000
81		Ford	E-250	1997	regular unleaded	200	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Cargo Van	17	12	5657	$ 2,000
82		Ford	E-250	1997	regular unleaded	200	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Cargo Van	17	12	5657	$ 2,000
83		Ford	E-250	1998	regular unleaded	235	6	AUTOMATIC	rear wheel drive	3	N/A	Midsize	Cargo Van	17	13	5657	$ 2,080
84		Ford	E-250	1998	regular unleaded	235	6	AUTOMATIC	rear wheel drive	3	N/A	Large	Cargo Van	17	13	5657	$ 2,107
85		Ford	E-Series Van	2012	flex-fuel (unleaded/E85)	255	8	AUTOMATIC	rear wheel drive	3	Flex Fuel	Large	Cargo Van	16	12	5657	$ 31,460
86		Ford	E-Series Van	2012	flex-fuel (unleaded/E85)	225	8	AUTOMATIC	rear wheel drive	3	Flex Fuel	Midsize	Cargo Van	17	13	5657	$ 26,630
87		Ford	E-Series Van	2012	flex-fuel (unleaded/E85)	225	8	AUTOMATIC	rear wheel drive	3	Flex Fuel	Midsize	Cargo Van	17	13	5657	$ 27,630
88		Ford	E-Series Van	2012	flex-fuel (unleaded/E85)	225	8	AUTOMATIC	rear wheel drive	3	Flex Fuel	Large	Cargo Van	17	13	5657	$ 28,985
89		Ford	E-Series Van	2012	flex-fuel (unleaded/E85)	225	8	AUTOMATIC	rear wheel drive	3	Flex Fuel	Large	Cargo Van	17	13	5657	$ 27,840
90		Ford	E-Series Van	2012	flex-fuel (unleaded/E85)	255	8	AUTOMATIC	rear wheel drive	3	Flex Fuel	Midsize	Cargo Van	16	12	5657	$ 30,560
91		Ford	E-Series Van	2013	flex-fuel (unleaded/E85)	225	8	AUTOMATIC	rear wheel drive	3	Flex Fuel	Midsize	Cargo Van	17	13	5657	$ 27,325
92		Ford	E-Series Van	2013	flex-fuel (unleaded/E85)	255	8	AUTOMATIC	rear wheel drive	3	Flex Fuel	Midsize	Cargo Van	16	12	5657	$ 31,485
93		Ford	E-Series Van	2013	flex-fuel (unleaded/E85)	225	8	AUTOMATIC	rear wheel drive	3	Flex Fuel	Large	Cargo Van	17	13	5657	$ 30,145
94		Ford	E-Series Van	2013	flex-fuel (unleaded/E85)	225	8	AUTOMATIC	rear wheel drive	3	Flex Fuel	Midsize	Cargo Van	17	13	5657	$ 28,785
95		Ford	E-Series Van	2013	flex-fuel (unleaded/E85)	225	8	AUTOMATIC	rear wheel drive	3	Flex Fuel	Large	Cargo Van	17	13	5657	$ 28,540
96		Ford	E-Series Van	2013	flex-fuel (unleaded/E85)	255	8	AUTOMATIC	rear wheel drive	3	Flex Fuel	Large	Cargo Van	16	12	5657	$ 32,385
97		Ford	E-Series Van	2014	flex-fuel (unleaded/E85)	225	8	AUTOMATIC	rear wheel drive	3	Flex Fuel	Midsize	Cargo Van	16	13	5657	$ 28,600
98		Ford	E-Series Van	2014	flex-fuel (unleaded/E85)	255	8	AUTOMATIC	rear wheel drive	3	Flex Fuel	Midsize	Cargo Van	16	12	5657	$ 32,760
99		Ford	E-Series Van	2014	flex-fuel (unleaded/E85)	225	8	AUTOMATIC	rear wheel drive	3	Flex Fuel	Midsize	Cargo Van	16	13	5657	$ 30,060
100		Ford	E-Series Van	2014	flex-fuel (unleaded/E85)	225	8	AUTOMATIC	rear wheel drive	3	Flex Fuel	Large	Cargo Van	16	13	5657	$ 31,420