Assignment 8

Objective

Predict Customer Attrition using the Credit Card data from the AER package, using the classification algorithm from the rpart package.

Data Prep

Created a new binary variable CreditCardData2 by classifying observations with 0 Customer Attrition as 0, and with one or more Customer Attrition as 1.
Split the data (10127 observations), into training and validation datasets (70%/30% , 425/176)

The Tree

Two Interpretations From The Tree

Most Likely Attrited Customer

Total Transaction Count <55
Total Revolving Balance Less than 614
Total Amount Changed for Q1-Q4 Less than 0.65

Unlikely Attrited Customer

Total Transaction Count <55
Total Transaction Amount>=5423

Variable Importance

Interesting how 12 Months of inactivity Would be perceived by many as a predictor for customer attrition. However, the data shows that it is not a good predictor.

Model Accuracy

Using the validation data, it is observed that the model is able to:

It is able to predit correctly 83.9% of Existing Customers
Misclassify Attrited Customers as Existing Customers 15.2% of the time

## 
##  
##    Cell Contents
## |-------------------------|
## |                       N |
## | Chi-square contribution |
## |           N / Row Total |
## |           N / Col Total |
## |         N / Table Total |
## |-------------------------|
## 
##  
## Total Observations in Table:  2990 
## 
##  
##                                | validation_tree$AttritionFlag_Predicted 
## validation_tree$Attrition_Flag | Attrited Customer | Existing Customer |         Row Total | 
## -------------------------------|-------------------|-------------------|-------------------|
##              Attrited Customer |               364 |               118 |               482 | 
##                                |          1155.572 |           206.873 |                   | 
##                                |             0.755 |             0.245 |             0.161 | 
##                                |             0.802 |             0.047 |                   | 
##                                |             0.122 |             0.039 |                   | 
## -------------------------------|-------------------|-------------------|-------------------|
##              Existing Customer |                90 |              2418 |              2508 | 
##                                |           222.084 |            39.758 |                   | 
##                                |             0.036 |             0.964 |             0.839 | 
##                                |             0.198 |             0.953 |                   | 
##                                |             0.030 |             0.809 |                   | 
## -------------------------------|-------------------|-------------------|-------------------|
##                   Column Total |               454 |              2536 |              2990 | 
##                                |             0.152 |             0.848 |                   | 
## -------------------------------|-------------------|-------------------|-------------------|
## 
##  
## Statistics for All Table Factors
## 
## 
## Pearson's Chi-squared test 
## ------------------------------------------------------------
## Chi^2 =  1624.287     d.f. =  1     p =  0 
## 
## Pearson's Chi-squared test with Yates' continuity correction 
## ------------------------------------------------------------
## Chi^2 =  1618.706     d.f. =  1     p =  0 
## 
##