Financial Impact of the Model
- I predicted 495 people are going to leave
- The cost of my program is 495 x 100 = $49,500
- We will save 30% of 395 = 118.5, which as has value of 2300 x 118.5
= $272,550
- The net of this program is $223,050
- Per customer is $74.35 per customer
## Attrited Customer Existing Customer
## Customer_Age 0.0063327751 5.420322e-03
## Gender 0.0059138130 1.199533e-03
## Dependent_count 0.0004262869 5.000680e-04
## Education_Level -0.0005441620 5.075804e-05
## Marital_Status 0.0002757442 8.852183e-04
## Income_Category 0.0012782985 3.476720e-04
## Card_Category 0.0002402863 -1.972390e-05
## Months_on_book 0.0037350983 1.722361e-03
## Total_Relationship_Count 0.0286560848 2.867910e-02
## Months_Inactive_12_mon 0.0282719813 7.072025e-04
## Contacts_Count_12_mon 0.0140095815 4.387817e-03
## Credit_Limit 0.0146095519 1.752416e-02
## Total_Revolving_Bal 0.0680419908 4.907964e-02
## Avg_Open_To_Buy 0.0151861073 1.630671e-02
## Total_Amt_Chng_Q4_Q1 0.0326269543 7.453302e-03
## Total_Trans_Amt 0.1209026127 8.821248e-02
## Total_Trans_Ct 0.2338403587 9.299149e-02
## Total_Ct_Chng_Q4_Q1 0.0640227094 1.177788e-02
## Avg_Utilization_Ratio 0.0036395300 4.174077e-02
## MeanDecreaseAccuracy MeanDecreaseGini
## Customer_Age 5.567939e-03 67.228294
## Gender 1.956453e-03 17.270330
## Dependent_count 4.890673e-04 24.025164
## Education_Level -4.536942e-05 23.024890
## Marital_Status 7.867176e-04 17.159319
## Income_Category 4.970026e-04 20.682891
## Card_Category 2.034125e-05 4.463222
## Months_on_book 2.044793e-03 45.550518
## Total_Relationship_Count 2.867654e-02 134.894912
## Months_Inactive_12_mon 5.143671e-03 46.792452
## Contacts_Count_12_mon 5.936788e-03 56.080899
## Credit_Limit 1.706846e-02 65.019372
## Total_Revolving_Bal 5.213958e-02 205.866336
## Avg_Open_To_Buy 1.613262e-02 58.369614
## Total_Amt_Chng_Q4_Q1 1.150772e-02 121.544881
## Total_Trans_Amt 9.345712e-02 351.280589
## Total_Trans_Ct 1.156373e-01 317.046432
## Total_Ct_Chng_Q4_Q1 2.017858e-02 203.697067
## Avg_Utilization_Ratio 3.560203e-02 118.976656
## Attrited Customer Existing Customer class.error
## Attrited Customer 919 215 0.18959436
## Existing Customer 80 5835 0.01352494
## [1] "numeric"
##
##
## Cell Contents
## |-------------------------|
## | N |
## | Chi-square contribution |
## | N / Row Total |
## | N / Col Total |
## | N / Table Total |
## |-------------------------|
##
##
## Total Observations in Table: 3078
##
##
## | val$Attrition_Flag
## val$predicted_rf | Attrited Customer | Existing Customer | Row Total |
## ------------------|-------------------|-------------------|-------------------|
## Attrited Customer | 398 | 27 | 425 |
## | 1599.085 | 304.971 | |
## | 0.936 | 0.064 | 0.138 |
## | 0.807 | 0.010 | |
## | 0.129 | 0.009 | |
## ------------------|-------------------|-------------------|-------------------|
## Existing Customer | 95 | 2558 | 2653 |
## | 256.167 | 48.855 | |
## | 0.036 | 0.964 | 0.862 |
## | 0.193 | 0.990 | |
## | 0.031 | 0.831 | |
## ------------------|-------------------|-------------------|-------------------|
## Column Total | 493 | 2585 | 3078 |
## | 0.160 | 0.840 | |
## ------------------|-------------------|-------------------|-------------------|
##
##
