Re-done Bike Sales Data.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	ID	Marital Status	Gender	Income	Children	Education	Occupation	Home Owner	Cars	Commute Distance	Region	Age	Purchased Bike	New Marital Status	New Gender
2	12496	M	F	$ 40,000.00	1	Bachelors	Skilled Manual	Yes	0	0-1 Miles	Europe	42	No	Married	Female
3	24107	M	M	$ 30,000.00	3	Partial College	Clerical	Yes	1	0-1 Miles	Europe	43	No	Married	Male
4	14177	M	M	$ 80,000.00	5	Partial College	Professional	No	2	2-5 Miles	Europe	60	No	Married	Male
5	24381	S	M	$ 70,000.00	0	Bachelors	Professional	Yes	1	5-10 Miles	Pacific	41	Yes	Single	Male
6	25597	S	M	$ 30,000.00	0	Bachelors	Clerical	No	0	0-1 Miles	Europe	36	Yes	Single	Male
7	13507	M	F	$ 10,000.00	2	Partial College	Manual	Yes	0	1-2 Miles	Europe	50	No	Married	Female
8	27974	S	M	$ 160,000.00	2	High School	Management	Yes	4	0-1 Miles	Pacific	33	Yes	Single	Male
9	19364	M	M	$ 40,000.00	1	Bachelors	Skilled Manual	Yes	0	0-1 Miles	Europe	43	Yes	Married	Male
10	22155	M	M	$ 20,000.00	2	Partial High School	Clerical	Yes	2	5-10 Miles	Pacific	58	No	Married	Male
11	19280	M	M	$ 120,000.00	2	Partial College	Manual	Yes	1	0-1 Miles	Europe	40	Yes	Married	Male
12	22173	M	F	$ 30,000.00	3	High School	Skilled Manual	No	2	1-2 Miles	Pacific	54	Yes	Married	Female
13	12697	S	F	$ 90,000.00	0	Bachelors	Professional	No	4	Above 10 Miles	Pacific	36	No	Single	Female
14	11434	M	M	$ 170,000.00	5	Partial College	Professional	Yes	0	0-1 Miles	Europe	55	No	Married	Male
15	25323	M	M	$ 40,000.00	2	Partial College	Clerical	Yes	1	1-2 Miles	Europe	35	Yes	Married	Male
16	23542	S	M	$ 60,000.00	1	Partial College	Skilled Manual	No	1	0-1 Miles	Pacific	45	Yes	Single	Male
17	20870	S	F	$ 10,000.00	2	High School	Manual	Yes	1	0-1 Miles	Europe	38	Yes	Single	Female
18	23316	S	M	$ 30,000.00	3	Partial College	Clerical	No	2	1-2 Miles	Pacific	59	Yes	Single	Male
19	12610	M	F	$ 30,000.00	1	Bachelors	Clerical	Yes	0	0-1 Miles	Europe	47	No	Married	Female
20	27183	S	M	$ 40,000.00	2	Partial College	Clerical	Yes	1	1-2 Miles	Europe	35	Yes	Single	Male
21	25940	S	M	$ 20,000.00	2	Partial High School	Clerical	Yes	2	5-10 Miles	Pacific	55	Yes	Single	Male
22	25598	M	F	$ 40,000.00	0	Graduate Degree	Clerical	Yes	0	0-1 Miles	Europe	36	Yes	Married	Female
23	21564	S	F	$ 80,000.00	0	Bachelors	Professional	Yes	4	Above 10 Miles	Pacific	35	No	Single	Female
24	19193	S	M	$ 40,000.00	2	Partial College	Clerical	Yes	0	1-2 Miles	Europe	35	Yes	Single	Male
25	26412	M	F	$ 80,000.00	5	High School	Management	No	3	5-10 Miles	Europe	56	No	Married	Female
26	27184	S	M	$ 40,000.00	2	Partial College	Clerical	No	1	0-1 Miles	Europe	34	No	Single	Male
27	12590	S	M	$ 30,000.00	1	Bachelors	Clerical	Yes	0	0-1 Miles	Europe	63	No	Single	Male
28	17841	S	M	$ 30,000.00	0	Partial College	Clerical	No	1	0-1 Miles	Europe	29	Yes	Single	Male
29	18283	S	F	$ 100,000.00	0	Bachelors	Professional	No	1	5-10 Miles	Pacific	40	No	Single	Female
30	18299	M	M	$ 70,000.00	5	Partial College	Skilled Manual	Yes	2	5-10 Miles	Pacific	44	No	Married	Male
31	16466	S	F	$ 20,000.00	0	Partial High School	Manual	No	2	0-1 Miles	Europe	32	Yes	Single	Female
32	19273	M	F	$ 20,000.00	2	Partial College	Manual	Yes	0	0-1 Miles	Europe	63	No	Married	Female
33	22400	M	M	$ 10,000.00	0	Partial College	Manual	No	1	0-1 Miles	Pacific	26	Yes	Married	Male
34	20942	S	F	$ 20,000.00	0	High School	Manual	No	1	5-10 Miles	Europe	31	No	Single	Female
35	18484	S	M	$ 80,000.00	2	High School	Skilled Manual	No	2	1-2 Miles	Pacific	50	Yes	Single	Male
36	12291	S	M	$ 90,000.00	5	Partial College	Professional	No	2	2-5 Miles	Europe	62	Yes	Single	Male
37	28380	S	F	$ 10,000.00	5	Partial High School	Manual	No	2	0-1 Miles	Europe	41	No	Single	Female
38	17891	M	F	$ 10,000.00	2	Partial College	Manual	Yes	1	0-1 Miles	Europe	50	Yes	Married	Female
39	27832	S	F	$ 30,000.00	0	Partial College	Clerical	No	1	2-5 Miles	Europe	30	No	Single	Female
40	26863	S	M	$ 20,000.00	0	High School	Manual	No	1	2-5 Miles	Europe	28	No	Single	Male
41	16259	S	F	$ 10,000.00	4	Partial High School	Manual	Yes	2	0-1 Miles	Europe	40	Yes	Single	Female
42	27803	S	F	$ 30,000.00	2	Partial College	Clerical	No	0	0-1 Miles	Europe	43	No	Single	Female
43	14347	S	F	$ 40,000.00	2	Bachelors	Management	Yes	2	5-10 Miles	Pacific	65	Yes	Single	Female
44	17703	M	F	$ 10,000.00	1	Graduate Degree	Manual	Yes	0	0-1 Miles	Europe	40	No	Married	Female
45	17185	M	F	$ 170,000.00	4	Partial College	Professional	No	3	5-10 Miles	Europe	48	Yes	Married	Female
46	29380	M	F	$ 20,000.00	3	High School	Manual	Yes	0	0-1 Miles	Europe	41	Yes	Married	Female
47	23986	M	F	$ 20,000.00	1	Bachelors	Clerical	Yes	0	0-1 Miles	Europe	66	Yes	Married	Female
48	24466	M	F	$ 60,000.00	1	Partial College	Skilled Manual	Yes	1	5-10 Miles	Pacific	46	Yes	Married	Female
49	29097	S	F	$ 40,000.00	2	Partial College	Skilled Manual	Yes	2	5-10 Miles	Pacific	52	Yes	Single	Female
50	19487	M	M	$ 30,000.00	2	Partial College	Clerical	No	2	0-1 Miles	Europe	42	No	Married	Male
51	14939	S	M	$ 40,000.00	0	Bachelors	Clerical	Yes	0	0-1 Miles	Europe	39	Yes	Single	Male
52	13826	S	F	$ 30,000.00	0	Partial College	Clerical	No	1	0-1 Miles	Europe	28	No	Single	Female
53	20619	S	M	$ 80,000.00	0	Bachelors	Professional	No	4	Above 10 Miles	Pacific	35	No	Single	Male
54	12558	M	F	$ 20,000.00	1	Bachelors	Clerical	Yes	0	0-1 Miles	Europe	65	No	Married	Female
55	24871	S	F	$ 90,000.00	4	High School	Management	No	3	5-10 Miles	Europe	56	No	Single	Female
56	17319	S	F	$ 70,000.00	0	Bachelors	Professional	No	1	5-10 Miles	Pacific	42	No	Single	Female
57	28906	M	M	$ 80,000.00	4	High School	Professional	Yes	2	Above 10 Miles	Europe	54	No	Married	Male
58	12808	M	M	$ 40,000.00	0	Bachelors	Clerical	Yes	0	0-1 Miles	Europe	38	Yes	Married	Male
59	20567	M	M	$ 130,000.00	4	Partial College	Professional	No	4	5-10 Miles	Europe	61	Yes	Married	Male
60	25502	M	F	$ 40,000.00	1	Bachelors	Skilled Manual	Yes	0	0-1 Miles	Europe	43	Yes	Married	Female
61	15580	M	M	$ 60,000.00	2	Bachelors	Professional	Yes	1	2-5 Miles	Pacific	38	Yes	Married	Male
62	24185	S	F	$ 10,000.00	1	High School	Manual	No	1	1-2 Miles	Europe	45	No	Single	Female
63	19291	S	F	$ 10,000.00	2	High School	Manual	Yes	0	0-1 Miles	Europe	35	No	Single	Female
64	16713	M	M	$ 40,000.00	2	Bachelors	Management	Yes	1	0-1 Miles	Pacific	52	Yes	Married	Male
65	16185	S	M	$ 60,000.00	4	Bachelors	Professional	Yes	3	Above 10 Miles	Pacific	41	No	Single	Male
66	14927	M	F	$ 30,000.00	1	Bachelors	Clerical	Yes	0	0-1 Miles	Europe	37	Yes	Married	Female
67	29337	S	M	$ 30,000.00	2	Partial College	Clerical	Yes	2	5-10 Miles	Pacific	68	No	Single	Male
68	29355	M	F	$ 40,000.00	0	Graduate Degree	Clerical	Yes	0	0-1 Miles	Europe	37	Yes	Married	Female
69	25303	S	M	$ 30,000.00	0	High School	Manual	Yes	1	2-5 Miles	Europe	33	Yes	Single	Male
70	14813	S	F	$ 20,000.00	4	High School	Manual	Yes	1	0-1 Miles	Europe	43	Yes	Single	Female
71	16438	M	F	$ 10,000.00	0	Partial High School	Manual	No	2	0-1 Miles	Europe	30	No	Married	Female
72	14238	M	M	$ 120,000.00	0	Partial High School	Professional	Yes	4	Above 10 Miles	Pacific	36	Yes	Married	Male
73	16200	S	F	$ 10,000.00	0	Partial High School	Manual	No	2	0-1 Miles	Europe	35	No	Single	Female
74	24857	M	F	$ 130,000.00	3	High School	Professional	Yes	4	0-1 Miles	Europe	52	No	Married	Female
75	26956	S	F	$ 20,000.00	0	Partial College	Manual	No	1	2-5 Miles	Europe	36	Yes	Single	Female
76	14517	M	F	$ 20,000.00	3	High School	Skilled Manual	No	2	1-2 Miles	Pacific	62	No	Married	Female
77	12678	S	F	$ 130,000.00	4	High School	Management	Yes	4	0-1 Miles	Pacific	31	No	Single	Female
78	16188	S	F	$ 20,000.00	0	Partial High School	Manual	No	2	1-2 Miles	Europe	26	No	Single	Female
79	27969	M	M	$ 80,000.00	0	Bachelors	Professional	Yes	2	Above 10 Miles	Pacific	29	Yes	Married	Male
80	15752	M	M	$ 80,000.00	2	High School	Skilled Manual	No	2	1-2 Miles	Pacific	50	Yes	Married	Male
81	27745	S	M	$ 40,000.00	2	Bachelors	Management	Yes	2	5-10 Miles	Pacific	63	Yes	Single	Male
82	20828	M	F	$ 30,000.00	4	Graduate Degree	Clerical	Yes	0	0-1 Miles	Europe	45	Yes	Married	Female
83	19461	S	F	$ 10,000.00	4	Partial High School	Manual	Yes	2	0-1 Miles	Europe	40	No	Single	Female
84	26941	M	M	$ 30,000.00	0	Bachelors	Clerical	Yes	0	0-1 Miles	Europe	47	Yes	Married	Male
85	28412	S	M	$ 20,000.00	0	High School	Manual	No	1	2-5 Miles	Europe	29	No	Single	Male
86	24485	S	M	$ 40,000.00	2	Bachelors	Management	No	1	5-10 Miles	Pacific	52	Yes	Single	Male
87	16514	S	M	$ 10,000.00	0	Partial College	Manual	Yes	1	1-2 Miles	Pacific	26	Yes	Single	Male
88	17191	S	M	$ 130,000.00	3	Partial College	Professional	No	3	0-1 Miles	Europe	51	Yes	Single	Male
89	19608	M	M	$ 80,000.00	5	Bachelors	Professional	Yes	4	1-2 Miles	Pacific	40	No	Married	Male
90	24119	S	M	$ 30,000.00	0	Partial College	Clerical	No	1	2-5 Miles	Europe	29	No	Single	Male
91	25458	M	M	$ 20,000.00	1	High School	Manual	No	1	1-2 Miles	Europe	40	Yes	Married	Male
92	26886	S	F	$ 30,000.00	0	Partial College	Clerical	No	1	0-1 Miles	Europe	29	Yes	Single	Female
93	28436	S	M	$ 30,000.00	0	Partial College	Clerical	No	1	0-1 Miles	Europe	30	Yes	Single	Male
94	19562	S	F	$ 60,000.00	2	Bachelors	Professional	Yes	1	2-5 Miles	Pacific	37	Yes	Single	Female
95	15608	S	F	$ 30,000.00	0	Partial College	Clerical	No	1	2-5 Miles	Europe	33	No	Single	Female
96	16487	S	F	$ 30,000.00	3	High School	Skilled Manual	Yes	2	5-10 Miles	Pacific	55	No	Single	Female
97	17197	S	F	$ 90,000.00	5	Partial College	Professional	Yes	2	Above 10 Miles	Europe	62	No	Single	Female
98	12507	M	M	$ 30,000.00	1	Partial College	Clerical	Yes	1	0-1 Miles	Europe	43	No	Married	Male
99	23940	M	M	$ 40,000.00	1	Bachelors	Skilled Manual	Yes	1	0-1 Miles	Europe	44	Yes	Married	Male
100	19441	M	M	$ 40,000.00	0	Graduate Degree	Clerical	Yes	0	0-1 Miles	Europe	25	Yes	Married	Male