BankChurners summary statistics

This report analyzes the BankChurners dataset using descriptive statistics

Import data

BankChurners <- read.csv("BankChurners.csv")

Summary statistics

summary(BankChurners)
##    CLIENTNUM           Attrition_Flag   Customer_Age         Gender     
##  Min.   :708082083   Length   :10127   Min.   :26.00   Length   :10127  
##  1st Qu.:713036770   N.unique :    2   1st Qu.:41.00   N.unique :    2  
##  Median :717926358   N.blank  :    0   Median :46.00   N.blank  :    0  
##  Mean   :739177606   Min.nchar:   17   Mean   :46.33   Min.nchar:    1  
##  3rd Qu.:773143533   Max.nchar:   17   3rd Qu.:52.00   Max.nchar:    1  
##  Max.   :828343083                     Max.   :73.00                    
##  Dependent_count  Education_Level    Marital_Status   Income_Category 
##  Min.   :0.000   Length   :10127   Length   :10127   Length   :10127  
##  1st Qu.:1.000   N.unique :    7   N.unique :    4   N.unique :    6  
##  Median :2.000   N.blank  :    0   N.blank  :    0   N.blank  :    0  
##  Mean   :2.346   Min.nchar:    7   Min.nchar:    6   Min.nchar:    7  
##  3rd Qu.:3.000   Max.nchar:   13   Max.nchar:    8   Max.nchar:   14  
##  Max.   :5.000                                                        
##    Card_Category   Months_on_book  Total_Relationship_Count
##  Length   :10127   Min.   :13.00   Min.   :1.000           
##  N.unique :    4   1st Qu.:31.00   1st Qu.:3.000           
##  N.blank  :    0   Median :36.00   Median :4.000           
##  Min.nchar:    4   Mean   :35.93   Mean   :3.813           
##  Max.nchar:    8   3rd Qu.:40.00   3rd Qu.:5.000           
##                    Max.   :56.00   Max.   :6.000           
##  Months_Inactive_12_mon Contacts_Count_12_mon  Credit_Limit  
##  Min.   :0.000          Min.   :0.000         Min.   : 1438  
##  1st Qu.:2.000          1st Qu.:2.000         1st Qu.: 2555  
##  Median :2.000          Median :2.000         Median : 4549  
##  Mean   :2.341          Mean   :2.455         Mean   : 8632  
##  3rd Qu.:3.000          3rd Qu.:3.000         3rd Qu.:11068  
##  Max.   :6.000          Max.   :6.000         Max.   :34516  
##  Total_Revolving_Bal Avg_Open_To_Buy Total_Amt_Chng_Q4_Q1 Total_Trans_Amt
##  Min.   :   0        Min.   :    3   Min.   :0.0000       Min.   :  510  
##  1st Qu.: 359        1st Qu.: 1325   1st Qu.:0.6310       1st Qu.: 2156  
##  Median :1276        Median : 3474   Median :0.7360       Median : 3899  
##  Mean   :1163        Mean   : 7469   Mean   :0.7599       Mean   : 4404  
##  3rd Qu.:1784        3rd Qu.: 9859   3rd Qu.:0.8590       3rd Qu.: 4741  
##  Max.   :2517        Max.   :34516   Max.   :3.3970       Max.   :18484  
##  Total_Trans_Ct   Total_Ct_Chng_Q4_Q1 Avg_Utilization_Ratio
##  Min.   : 10.00   Min.   :0.0000      Min.   :0.0000       
##  1st Qu.: 45.00   1st Qu.:0.5820      1st Qu.:0.0230       
##  Median : 67.00   Median :0.7020      Median :0.1760       
##  Mean   : 64.86   Mean   :0.7122      Mean   :0.2749       
##  3rd Qu.: 81.00   3rd Qu.:0.8180      3rd Qu.:0.5030       
##  Max.   :139.00   Max.   :3.7140      Max.   :0.9990       
##  Naive_Bayes_Classifier_Attrition_Flag_Card_Category_Contacts_Count_12_mon_Dependent_count_Education_Level_Months_Inactive_12_mon_1
##  Min.   :7.660e-06                                                                                                                 
##  1st Qu.:9.898e-05                                                                                                                 
##  Median :1.815e-04                                                                                                                 
##  Mean   :1.600e-01                                                                                                                 
##  3rd Qu.:3.373e-04                                                                                                                 
##  Max.   :9.996e-01                                                                                                                 
##  Naive_Bayes_Classifier_Attrition_Flag_Card_Category_Contacts_Count_12_mon_Dependent_count_Education_Level_Months_Inactive_12_mon_2
##  Min.   :0.00042                                                                                                                   
##  1st Qu.:0.99966                                                                                                                   
##  Median :0.99982                                                                                                                   
##  Mean   :0.84000                                                                                                                   
##  3rd Qu.:0.99990                                                                                                                   
##  Max.   :0.99999

Average age

mean(BankChurners$Customer_Age)
## [1] 46.32596

Average credit limit

library(formattable)
currency(mean(BankChurners$Credit_Limit))
## [1] $8,631.95