Analyze and determine based on the different Cluster Centroid Table (Gender and attrition) why is this company is losing customers (attrition rate) by using the primary attribute of gender and attribution rate to identify patterns/reasons that people are leaving ( analyze the data results and identify anomalies or reasons tobelieve people are leaving the company (lack of benefits, high APR, age group)

Cluster Gender- Centroid Table

Attrition_Flag = Existing Customer	0.40642299558831985	0.34651853857666076	0.04646089695683667	-0.05849446376321965	-2.26684981973214
Gender IF Formula = 0	-0.8998864733010554	1.0593221123109953	0.296505224996324	0.3792545637912702	-0.19611083349902125
Gender IF Formula = 1	0.8998864733010554	-1.059322112310995	-0.29650522499632387	-0.3792545637912701	0.1961108334990214
Education_Level = High School	-0.017365214249262153	0.03896145968923756	-0.08716734024387109	0.08985178809261189	-0.023599680313709407
Education_Level = Graduate	0.01119420955107936	-0.011612379249734314	0.05377965725757062	-0.02296707027062603	-0.023881830589205
Education_Level = College	0.006962056544905426	-0.006004526428249789	0.010768222414990416	0.08559750359619234	-0.017174997870030267
Education_Level = Post-Graduate	-0.00280613502949536	-0.00523897763084981	0.05541247383814439	-0.028778466025440583	0.0030944806464838024
Education_Level = Doctorate	-0.013127745033441222	-0.018842252268868237	-0.01253355824198353	0.003131401621426915	0.09870334730731062
Marital_Status = Married	0.006097251554986961	0.0427189351649831	-0.18162631915466135	-0.2606233464560296	-0.04129265767458644
Marital_Status = Single	-2.6168873221580377E-4	-0.04083948013306821	0.12719163063071748	0.27408346549614954	0.03864027058262853
Income_Category = $60K - $80K	-0.3997595832821113	0.47320865452813354	0.09077533221117735	0.3320274649206055	-0.09109525993704
Income_Category = Less than $40K	0.576144759118605	-0.6592106451811695	-0.26591201962993366	-0.30410454358587125	0.10938658682962352
Income_Category = $80K - $120K	-0.4220379397876091	0.5068728266977144	0.1565133485215232	0.10603756044713705	-0.12089794629702524
Income_Category = $40K - $60K	0.023123503307060506	-0.02604788780505242	0.0041479552880528915	-0.1323561547402383	0.007120713336927685
Card_Category = Blue	0.2650200490374682	0.2668897812382585	-3.746490387758109	-3.7464903877581084	0.2609174893201091
Card_Category = Gold	-0.10594088220702672	-0.1059408822070267	-0.10594088220702673	9.438282740047635	-0.10594088220702674
Card_Category = Silver	-0.23750112035053295	-0.23750112035053295	4.080701067840974	-0.23750112035053292	-0.2375011203505329
CLIENTNUM	0.0035208973294359445	0.026301648997988168	0.04245683577279528	-0.0023273671364326285	-0.10087562406899138
Customer_Age	0.019926905416705352	-0.03370516303237224	-0.06060712882060275	-0.11171323092126874	0.06321755809190265
Dependent_count	-0.020475544707321672	-0.006320877803296378	0.06510770820664206	0.24674065780778795	0.03579162985566756
Months_on_book	0.008911075885801988	-0.023477831175893454	-0.0505669982661895	-0.04575793152454618	0.060677575655537316
Total_Relationship_Count	0.0667318596182562	0.10106092849343819	-0.2827102361017817	-0.5291223549389344	-0.33213111560244046
Months_Inactive_12_mon	-0.04853391248853742	-0.0697045757372462	-0.07152839045250944	-0.03471479717673657	0.37916397539291163
Contacts_Count_12_mon	-0.13244509802345264	-0.0294706893212774	-0.007508163587226352	-0.055101428918173	0.5118549451376053
Credit_Limit	-0.47343956388694597	0.3106681448720876	1.8707578358628953	2.206790676358501	-0.2912857138021394
Total_Revolving_Bal	0.1148012916392522	0.11629191197873157	0.05623075013036477	0.26764410281385786	-0.7321354249528362
Avg_Open_To_Buy	-0.48361979065924454	0.30012989403762275	1.8651705655085697	2.1821107220599227	-0.22541607708734618
Total_Amt_Chng_Q4_Q1	0.03882451954466719	0.09940006206276546	0.018101079880774425	0.05332936819016557	-0.40961893300987195
Total_Trans_Amt	0.050529356694400444	0.01925013302783286	0.6532178935144505	0.9590321731726119	-0.5609441468848255
Total_Trans_Ct	0.24765595628511117	-0.01287642775243468	0.4224942705734706	0.675029040805476	-0.9842399978700045
Total_Ct_Chng_Q4_Q1	0.1670334322275544	0.10924287772750285	-0.024099019726096967	-0.014436845171825991	-0.8233889190748798
Avg_Utilization_Ratio	0.43492668888955394	-0.20870298076338387	-0.7941451014410771	-0.7870428140164677	-0.4243900911223078

Cluster Attrition - Centroid Tab

Attributes	Cluster 0	Clsuter 1	Cluster 2	Cluster 3	Cluster 4
Attrition Flag IF Formula = 0	0.427233	0.051435	-2.30146	0.434464	-0.05849
Attrition Flag IF Formula = 1	-0.42723	-0.05144	2.301456	-0.43446	0.058494
Gender = M	0.981201	0.292862	-0.12247	-0.61952	0.379255
Education_Level = High School	0.028531	-0.08261	-0.02406	-0.00315	0.089852
Education_Level = Graduate	-0.00931	0.05378	-0.02427	0.007693	-0.02297
Education_Level = College	-0.02738	0.010768	-0.01547	0.018719	0.085598
Education_Level = Post-Graduate	6.17E-04	0.047179	0.020685	-0.01145	-0.02878
Education_Level = Doctorate	-0.01828	-0.01253	0.075796	-0.01046	0.003131
Marital_Status = Married	0.056039	-0.18527	-0.04067	0.004453	-0.26062
Marital_Status = Single	-0.05841	0.130921	0.032173	0.005523	0.274083
Income_Category = $60K - $80K	0.644873	0.090775	-0.07308	-0.39976	0.332027
Income_Category = Less than $40K	-0.73642	-0.26211	0.082201	0.473212	-0.3041
Income_Category = $80K - $120K	0.658686	0.156513	-0.03619	-0.42204	0.106038
Income_Category = $40K - $60K	-0.33488	-6.20E-04	-0.01927	0.218947	-0.13236
Card_Category = Blue	0.26689	-3.74649	0.258771	0.266059	-3.74649
Card_Category = Gold	-0.10594	-0.10594	-0.10594	-0.10594	9.438283
Card_Category = Silver	-0.2375	4.080701	-0.2375	-0.2375	-0.2375
CLIENTNUM	0.03115	0.042247	-0.1108	0.009742	-0.00233
Customer_Age	-0.02126	-0.06015	0.04536	0.008815	-0.11171
Dependent_count	0.067306	0.063707	0.040152	-0.06745	0.246741
Months_on_book	-0.01883	-0.04943	0.03802	0.00681	-0.04576
Total_Relationship_Count	0.13248	-0.28388	-0.34009	0.065894	-0.52912
Months_Inactive_12_mon	-0.07595	-0.07153	0.355329	-0.05257	-0.03471
Contacts_Count_12_mon	-0.03766	-0.01244	0.466738	-0.11705	-0.0551
Credit_Limit	0.508504	1.869154	-0.2127	-0.51704	2.206791
Total_Revolving_Bal	0.095958	0.059956	-0.61521	0.115801	0.267644
Avg_Open_To_Buy	0.499737	1.863232	-0.15736	-0.5273	2.182111
Total_Amt_Chng_Q4_Q1	0.08459	0.015845	-0.32447	0.043592	0.053329
Total_Trans_Amt	-0.00696	0.659254	-0.45752	0.047738	0.959032
Total_Trans_Ct	-0.0199	0.427359	-0.90068	0.224884	0.675029
Total_Ct_Chng_Q4_Q1	0.123564	-0.02306	-0.70257	0.141265	-0.01444
Avg_Utilization_Ratio	-0.34747	-0.79338	-0.37358	0.440987	-0.78704

Cluster Model

Cluster 0: 3027 items

Cluster 1: 550 items

Cluster 2: 1483 items

Cluster 3: 4829 items

Cluster 4: 111 items Total number of items: 10000