Analysis

Random Forest Graph:

## 
##  
##    Cell Contents
## |-------------------------|
## |                       N |
## | Chi-square contribution |
## |           N / Row Total |
## |           N / Col Total |
## |         N / Table Total |
## |-------------------------|
## 
##  
## Total Observations in Table:  3009 
## 
##  
##                              | val$Attrition_Flag 
## val$predicted_Attrition_Flag | Attrited Customer | Existing Customer |         Row Total | 
## -----------------------------|-------------------|-------------------|-------------------|
##            Attrited Customer |               397 |                36 |               433 | 
##                              |          1520.599 |           294.348 |                   | 
##                              |             0.917 |             0.083 |             0.144 | 
##                              |             0.814 |             0.014 |                   | 
##                              |             0.132 |             0.012 |                   | 
## -----------------------------|-------------------|-------------------|-------------------|
##            Existing Customer |                91 |              2485 |              2576 | 
##                              |           255.598 |            49.477 |                   | 
##                              |             0.035 |             0.965 |             0.856 | 
##                              |             0.186 |             0.986 |                   | 
##                              |             0.030 |             0.826 |                   | 
## -----------------------------|-------------------|-------------------|-------------------|
##                 Column Total |               488 |              2521 |              3009 | 
##                              |             0.162 |             0.838 |                   | 
## -----------------------------|-------------------|-------------------|-------------------|
## 
## 

Conclusions:

  • 462 I predicted were going to leave
  • The cost of my program is 462 x 100 = $46,200
  • We will save 30% of 377 = 113.1 which had a value of $2,300 x 113.1 = $260,130
  • The net of this program is $260,130 from 2,994 employees
  • Per customer is $86.89 per customer