Analyzing Churn Rate in Telcom.Inc.xlsx

	B	C	D	P	Q
1
2	Total Customers	Churned Customers	Churn Rate %
3	6687	1796	26.86%
4
5
6
7
8
9
10
11				Intl Plan	yes
12
13				State	Churn Rate
14				CA	75.00%
15				IN	66.67%
16				NH	62.50%
17				KY	50.00%
18				LA	50.00%
19				TX	41.67%
20				NM	40.00%
21				CO	37.50%
22				AK	37.50%
23				OH	36.84%
24				DE	35.00%
25				HI	33.33%
26				NE	33.33%
27				PA	33.33%
28				ME	33.33%
29				MS	31.25%
30				MA	31.25%
31				MO	30.77%
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100