02 Churn-Dataset.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	customerID	tenure	PhoneService	MultipleLines	InternetService	Contract	PaymentMethod	MonthlyCharges	TotalCharges	# of Admin ticket	# of Tech Tickets	Churn	Loyalty
2	ABC1	1	No	No phone service	DSL	Month-to-month	Electronic check	29.85	29.85	0	0	No	< 1 year
3	ABC2	34	Yes	No	DSL	One year	Mailed check	56.95	1889.5	0	0	No	< 3 years
4	ABC3	2	Yes	No	DSL	Month-to-month	Mailed check	53.85	108.15	0	0	Yes	< 1 year
5	ABC4	45	No	No phone service	DSL	One year	Bank transfer (automatic)	42.3	1840.75	0	3	No	< 4 years
6	ABC5	2	Yes	No	Fiber optic	Month-to-month	Electronic check	70.7	151.65	0	0	Yes	< 1 year
7	ABC6	8	Yes	Yes	Fiber optic	Month-to-month	Electronic check	99.65	820.5	0	0	Yes	< 1 year
8	ABC7	22	Yes	Yes	Fiber optic	Month-to-month	Credit card (automatic)	89.1	1949.4	0	0	No	< 2 years
9	ABC8	10	No	No phone service	DSL	Month-to-month	Mailed check	29.75	301.9	0	0	No	< 1 year
10	ABC9	28	Yes	Yes	Fiber optic	Month-to-month	Electronic check	104.8	3046.05	0	2	Yes	< 3 years
11	ABC10	62	Yes	No	DSL	One year	Bank transfer (automatic)	56.15	3487.95	0	0	No	< 6 years
12	ABC11	13	Yes	No	DSL	Month-to-month	Mailed check	49.95	587.45	1	0	No	< 2 years
13	ABC12	16	Yes	No	No	Two year	Credit card (automatic)	18.95	326.8	0	0	No	< 2 years
14	ABC13	58	Yes	Yes	Fiber optic	One year	Credit card (automatic)	100.35	5681.1	0	0	No	< 5 years
15	ABC14	49	Yes	Yes	Fiber optic	Month-to-month	Bank transfer (automatic)	103.7	5036.3	5	4	Yes	< 5 years
16	ABC15	25	Yes	No	Fiber optic	Month-to-month	Electronic check	105.5	2686.05	0	0	No	< 3 years
17	ABC16	69	Yes	Yes	Fiber optic	Two year	Credit card (automatic)	113.25	7895.15	0	0	No	< 6 years
18	ABC17	52	Yes	No	No	One year	Mailed check	20.65	1022.95	0	0	No	< 5 years
19	ABC18	71	Yes	Yes	Fiber optic	Two year	Bank transfer (automatic)	106.7	7382.25	0	4	No	< 6 years
20	ABC19	10	Yes	No	DSL	Month-to-month	Credit card (automatic)	55.2	528.35	0	0	Yes	< 1 year
21	ABC20	21	Yes	No	Fiber optic	Month-to-month	Electronic check	90.05	1862.9	0	0	No	< 2 years
22	ABC21	1	No	No phone service	DSL	Month-to-month	Electronic check	39.65	39.65	0	0	Yes	< 1 year
23	ABC22	12	Yes	No	No	One year	Bank transfer (automatic)	19.8	202.25	2	0	No	< 2 years
24	ABC23	1	Yes	No	No	Month-to-month	Mailed check	20.15	20.15	4	0	Yes	< 1 year
25	ABC24	58	Yes	Yes	DSL	Two year	Credit card (automatic)	59.9	3505.1	1	0	No	< 5 years
26	ABC25	49	Yes	No	DSL	Month-to-month	Credit card (automatic)	59.6	2970.3	0	3	No	< 5 years
27	ABC26	30	Yes	No	DSL	Month-to-month	Bank transfer (automatic)	55.3	1530.6	0	0	No	< 3 years
28	ABC27	47	Yes	Yes	Fiber optic	Month-to-month	Electronic check	99.35	4749.15	0	4	Yes	< 4 years
29	ABC28	1	No	No phone service	DSL	Month-to-month	Electronic check	30.2	30.2	0	0	Yes	< 1 year
30	ABC29	72	Yes	Yes	DSL	Two year	Credit card (automatic)	90.25	6369.45	1	0	No	< 6 years
31	ABC30	17	Yes	No	DSL	Month-to-month	Mailed check	64.7	1093.1	0	0	Yes	< 2 years
32	ABC31	71	Yes	Yes	Fiber optic	Two year	Credit card (automatic)	96.35	6766.95	0	0	No	< 6 years
33	ABC32	2	Yes	No	Fiber optic	Month-to-month	Credit card (automatic)	95.5	181.65	0	0	No	< 1 year
34	ABC33	27	Yes	No	DSL	One year	Mailed check	66.15	1874.45	0	0	No	< 3 years
35	ABC34	1	Yes	No	No	Month-to-month	Bank transfer (automatic)	20.2	20.2	0	0	No	< 1 year
36	ABC35	1	Yes	No	DSL	Month-to-month	Bank transfer (automatic)	45.25	45.25	0	0	No	< 1 year
37	ABC36	72	Yes	Yes	Fiber optic	Two year	Bank transfer (automatic)	99.9	7251.7	0	0	No	< 6 years
38	ABC37	5	Yes	No	Fiber optic	Month-to-month	Electronic check	69.7	316.9	0	0	Yes	< 1 year
39	ABC38	46	Yes	No	Fiber optic	Month-to-month	Credit card (automatic)	74.8	3548.3	3	0	No	< 4 years
40	ABC39	34	Yes	Yes	Fiber optic	Month-to-month	Electronic check	106.35	3549.25	0	4	Yes	< 3 years
41	ABC40	11	Yes	Yes	Fiber optic	Month-to-month	Bank transfer (automatic)	97.85	1105.4	0	2	Yes	< 1 year
42	ABC41	10	Yes	No	DSL	One year	Mailed check	49.55	475.7	5	0	No	< 1 year
43	ABC42	70	Yes	Yes	DSL	Two year	Credit card (automatic)	69.2	4872.35	0	0	No	< 6 years
44	ABC43	17	Yes	No	No	One year	Mailed check	20.75	418.25	0	0	No	< 2 years
45	ABC44	63	Yes	Yes	DSL	Two year	Credit card (automatic)	79.85	4861.45	0	0	No	< 6 years
46	ABC45	13	Yes	Yes	DSL	Month-to-month	Electronic check	76.2	981.45	4	0	No	< 2 years
47	ABC46	49	Yes	Yes	Fiber optic	Month-to-month	Electronic check	84.5	3906.7	0	3	No	< 5 years
48	ABC47	2	Yes	No	DSL	Month-to-month	Mailed check	49.25	97	0	0	No	< 1 year
49	ABC48	2	Yes	No	Fiber optic	Month-to-month	Electronic check	80.65	144.15	0	0	Yes	< 1 year
50	ABC49	52	Yes	Yes	DSL	Two year	Credit card (automatic)	79.75	4217.8	1	0	No	< 5 years
51	ABC50	69	Yes	Yes	DSL	Two year	Credit card (automatic)	64.15	4254.1	0	0	No	< 6 years
52	ABC51	43	Yes	Yes	Fiber optic	Month-to-month	Electronic check	90.25	3838.75	0	0	No	< 4 years
53	ABC52	15	Yes	No	Fiber optic	Month-to-month	Credit card (automatic)	99.1	1426.4	0	1	Yes	< 2 years
54	ABC53	25	Yes	Yes	DSL	Month-to-month	Credit card (automatic)	69.5	1752.65	4	0	No	< 3 years
55	ABC54	8	Yes	Yes	Fiber optic	Month-to-month	Credit card (automatic)	80.65	633.3	0	0	Yes	< 1 year
56	ABC55	60	Yes	No	DSL	One year	Credit card (automatic)	74.85	4456.35	0	0	No	< 6 years
57	ABC56	18	Yes	Yes	Fiber optic	Month-to-month	Electronic check	95.45	1752.55	0	1	Yes	< 2 years
58	ABC57	63	Yes	Yes	Fiber optic	One year	Credit card (automatic)	99.65	6311.2	0	0	No	< 6 years
59	ABC58	66	Yes	Yes	Fiber optic	One year	Electronic check	108.45	7076.35	3	0	No	< 6 years
60	ABC59	34	Yes	Yes	No	Two year	Credit card (automatic)	24.95	894.3	0	0	No	< 3 years
61	ABC60	72	Yes	Yes	Fiber optic	Two year	Credit card (automatic)	107.5	7853.7	0	0	No	< 6 years
62	ABC61	47	Yes	Yes	Fiber optic	Month-to-month	Electronic check	100.5	4707.1	0	0	No	< 4 years
63	ABC62	60	Yes	Yes	Fiber optic	Month-to-month	Bank transfer (automatic)	89.9	5450.7	0	0	No	< 6 years
64	ABC63	72	No	No phone service	DSL	Two year	Bank transfer (automatic)	42.1	2962	0	0	No	< 6 years
65	ABC64	18	Yes	No	DSL	One year	Credit card (automatic)	54.4	957.1	0	0	No	< 2 years
66	ABC65	9	Yes	Yes	Fiber optic	Month-to-month	Electronic check	94.4	857.25	0	0	Yes	< 1 year
67	ABC66	3	Yes	No	DSL	Month-to-month	Electronic check	75.3	244.1	0	0	No	< 1 year
68	ABC67	47	Yes	Yes	Fiber optic	One year	Electronic check	78.9	3650.35	0	3	No	< 4 years
69	ABC68	31	Yes	No	DSL	Two year	Mailed check	79.2	2497.2	3	0	No	< 3 years
70	ABC69	50	Yes	No	No	Two year	Bank transfer (automatic)	20.15	930.9	0	0	No	< 5 years
71	ABC70	10	Yes	No	Fiber optic	Month-to-month	Mailed check	79.85	887.35	0	0	No	< 1 year
72	ABC71	1	Yes	No	DSL	Month-to-month	Mailed check	49.05	49.05	0	0	No	< 1 year
73	ABC72	52	Yes	No	No	One year	Electronic check	20.4	1090.65	0	0	No	< 5 years
74	ABC73	64	Yes	Yes	Fiber optic	Two year	Bank transfer (automatic)	111.6	7099	0	0	No	< 6 years
75	ABC74	62	Yes	Yes	No	Two year	Bank transfer (automatic)	24.25	1424.6	0	0	No	< 6 years
76	ABC75	3	Yes	No	DSL	Month-to-month	Bank transfer (automatic)	64.5	177.4	0	0	No	< 1 year
77	ABC76	56	Yes	Yes	Fiber optic	One year	Electronic check	110.5	6139.5	0	0	No	< 5 years
78	ABC77	46	Yes	No	DSL	One year	Credit card (automatic)	55.65	2688.85	1	0	No	< 4 years
79	ABC78	8	Yes	No	DSL	Month-to-month	Mailed check	54.65	482.25	0	0	No	< 1 year
80	ABC79	30	Yes	No	DSL	Month-to-month	Electronic check	74.75	2111.3	0	0	No	< 3 years
81	ABC80	45	Yes	Yes	No	One year	Credit card (automatic)	25.9	1216.6	0	0	No	< 4 years
82	ABC81	1	Yes	No	Fiber optic	Month-to-month	Electronic check	79.35	79.35	2	0	Yes	< 1 year
83	ABC82	11	No	No phone service	DSL	Month-to-month	Electronic check	50.55	565.35	0	0	No	< 1 year
84	ABC83	7	Yes	No	Fiber optic	Month-to-month	Bank transfer (automatic)	75.15	496.9	5	0	Yes	< 1 year
85	ABC84	42	Yes	No	Fiber optic	Month-to-month	Bank transfer (automatic)	103.8	4327.5	0	0	No	< 4 years
86	ABC85	49	Yes	No	No	Two year	Bank transfer (automatic)	20.15	973.35	0	0	No	< 5 years
87	ABC86	9	Yes	Yes	Fiber optic	Month-to-month	Credit card (automatic)	99.3	918.75	0	0	No	< 1 year
88	ABC87	35	Yes	No	DSL	One year	Bank transfer (automatic)	62.15	2215.45	0	0	No	< 3 years
89	ABC88	48	Yes	No	No	Two year	Bank transfer (automatic)	20.65	1057	0	0	No	< 5 years
90	ABC89	46	Yes	No	No	Two year	Mailed check	19.95	927.1	0	0	No	< 4 years
91	ABC90	29	No	No phone service	DSL	Month-to-month	Mailed check	33.75	1009.25	0	0	No	< 3 years
92	ABC91	30	Yes	No	Fiber optic	Month-to-month	Bank transfer (automatic)	82.05	2570.2	0	0	No	< 3 years
93	ABC92	1	Yes	No	Fiber optic	Month-to-month	Electronic check	74.7	74.7	0	0	No	< 1 year
94	ABC93	66	Yes	Yes	DSL	Two year	Mailed check	84	5714.25	0	0	No	< 6 years
95	ABC94	65	Yes	Yes	Fiber optic	Month-to-month	Credit card (automatic)	111.05	7107	0	0	No	< 6 years
96	ABC95	72	Yes	Yes	Fiber optic	Two year	Bank transfer (automatic)	100.9	7459.05	0	0	No	< 6 years
97	ABC96	12	Yes	Yes	Fiber optic	Month-to-month	Electronic check	78.95	927.35	0	0	Yes	< 2 years
98	ABC97	71	Yes	Yes	DSL	One year	Credit card (automatic)	66.85	4748.7	0	0	No	< 6 years
99	ABC98	5	Yes	No	No	Month-to-month	Mailed check	21.05	113.85	5	0	Yes	< 1 year
100	ABC99	52	Yes	No	No	Two year	Bank transfer (automatic)	21	1107.2	0	0	No	< 5 years