Research Project: Bank Data

Srishti Puri

3/24/2021

Research Question: What makes a client subscribe for a term deposit?

Results and Recommendations

Outcome by the Dataset

## 
##        no       yes 
## 0.8873458 0.1126542

Exploratory Data Analysis

Univariate Analysis

Profiling the client list.

##              var frequency percentage cumulative_perc
## 1         admin.     10422      25.30           25.30
## 2    blue-collar      9254      22.47           47.77
## 3     technician      6743      16.37           64.14
## 4       services      3969       9.64           73.78
## 5     management      2924       7.10           80.88
## 6        retired      1720       4.18           85.06
## 7   entrepreneur      1456       3.54           88.60
## 8  self-employed      1421       3.45           92.05
## 9      housemaid      1060       2.57           94.62
## 10    unemployed      1014       2.46           97.08
## 11       student       875       2.12           99.20
## 12       unknown       330       0.80          100.00

Marital Status

##        var frequency percentage cumulative_perc
## 1  married     24928      60.52           60.52
## 2   single     11568      28.09           88.61
## 3 divorced      4612      11.20           99.81
## 4  unknown        80       0.19          100.00

Education Level

##                   var frequency percentage cumulative_perc
## 1   university.degree     12168      29.54           29.54
## 2         high.school      9515      23.10           52.64
## 3            basic.9y      6045      14.68           67.32
## 4 professional.course      5243      12.73           80.05
## 5            basic.4y      4176      10.14           90.19
## 6            basic.6y      2292       5.56           95.75
## 7             unknown      1731       4.20           99.95
## 8          illiterate        18       0.04          100.00

Default in Credit

##       var frequency percentage cumulative_perc
## 1      no     32588      79.12           79.12
## 2 unknown      8597      20.87           99.99
## 3     yes         3       0.01          100.00

Housing Loan

##       var frequency percentage cumulative_perc
## 1     yes     21576      52.38           52.38
## 2      no     18622      45.21           97.59
## 3 unknown       990       2.40          100.00

Bank Loan

##       var frequency percentage cumulative_perc
## 1      no     33950      82.43           82.43
## 2     yes      6248      15.17           97.60
## 3 unknown       990       2.40          100.00

Contact

##         var frequency percentage cumulative_perc
## 1  cellular     26144      63.47           63.47
## 2 telephone     15044      36.53          100.00

Month

##    var frequency percentage cumulative_perc
## 1  may     13769      33.43           33.43
## 2  jul      7174      17.42           50.85
## 3  aug      6178      15.00           65.85
## 4  jun      5318      12.91           78.76
## 5  nov      4101       9.96           88.72
## 6  apr      2632       6.39           95.11
## 7  oct       718       1.74           96.85
## 8  sep       570       1.38           98.23
## 9  mar       546       1.33           99.56
## 10 dec       182       0.44          100.00

Day of Week

##   var frequency percentage cumulative_perc
## 1 thu      8623      20.94           20.94
## 2 mon      8514      20.67           41.61
## 3 wed      8134      19.75           61.36
## 4 tue      8090      19.64           81.00
## 5 fri      7827      19.00          100.00

Poutcome

##           var frequency percentage cumulative_perc
## 1 nonexistent     35563      86.34           86.34
## 2     failure      4252      10.32           96.66
## 3     success      1373       3.33          100.00

Chi Square Test

Job and Yes

## 
##  
##    Cell Contents
## |-------------------------|
## |                       N |
## | Chi-square contribution |
## |           N / Row Total |
## |           N / Col Total |
## |         N / Table Total |
## |-------------------------|
## 
##  
## Total Observations in Table:  41188 
## 
##  
##               | bank$y 
##      bank$job |        no |       yes | Row Total | 
## --------------|-----------|-----------|-----------|
##        admin. |      9070 |      1352 |     10422 | 
##               |     3.423 |    26.961 |           | 
##               |     0.870 |     0.130 |     0.253 | 
##               |     0.248 |     0.291 |           | 
##               |     0.220 |     0.033 |           | 
## --------------|-----------|-----------|-----------|
##   blue-collar |      8616 |       638 |      9254 | 
##               |    19.926 |   156.951 |           | 
##               |     0.931 |     0.069 |     0.225 | 
##               |     0.236 |     0.138 |           | 
##               |     0.209 |     0.015 |           | 
## --------------|-----------|-----------|-----------|
##  entrepreneur |      1332 |       124 |      1456 | 
##               |     1.240 |     9.767 |           | 
##               |     0.915 |     0.085 |     0.035 | 
##               |     0.036 |     0.027 |           | 
##               |     0.032 |     0.003 |           | 
## --------------|-----------|-----------|-----------|
##     housemaid |       954 |       106 |      1060 | 
##               |     0.191 |     1.507 |           | 
##               |     0.900 |     0.100 |     0.026 | 
##               |     0.026 |     0.023 |           | 
##               |     0.023 |     0.003 |           | 
## --------------|-----------|-----------|-----------|
##    management |      2596 |       328 |      2924 | 
##               |     0.001 |     0.006 |           | 
##               |     0.888 |     0.112 |     0.071 | 
##               |     0.071 |     0.071 |           | 
##               |     0.063 |     0.008 |           | 
## --------------|-----------|-----------|-----------|
##       retired |      1286 |       434 |      1720 | 
##               |    37.814 |   297.849 |           | 
##               |     0.748 |     0.252 |     0.042 | 
##               |     0.035 |     0.094 |           | 
##               |     0.031 |     0.011 |           | 
## --------------|-----------|-----------|-----------|
## self-employed |      1272 |       149 |      1421 | 
##               |     0.097 |     0.767 |           | 
##               |     0.895 |     0.105 |     0.035 | 
##               |     0.035 |     0.032 |           | 
##               |     0.031 |     0.004 |           | 
## --------------|-----------|-----------|-----------|
##      services |      3646 |       323 |      3969 | 
##               |     4.375 |    34.458 |           | 
##               |     0.919 |     0.081 |     0.096 | 
##               |     0.100 |     0.070 |           | 
##               |     0.089 |     0.008 |           | 
## --------------|-----------|-----------|-----------|
##       student |       600 |       275 |       875 | 
##               |    40.090 |   315.775 |           | 
##               |     0.686 |     0.314 |     0.021 | 
##               |     0.016 |     0.059 |           | 
##               |     0.015 |     0.007 |           | 
## --------------|-----------|-----------|-----------|
##    technician |      6013 |       730 |      6743 | 
##               |     0.147 |     1.156 |           | 
##               |     0.892 |     0.108 |     0.164 | 
##               |     0.165 |     0.157 |           | 
##               |     0.146 |     0.018 |           | 
## --------------|-----------|-----------|-----------|
##    unemployed |       870 |       144 |      1014 | 
##               |     0.985 |     7.758 |           | 
##               |     0.858 |     0.142 |     0.025 | 
##               |     0.024 |     0.031 |           | 
##               |     0.021 |     0.003 |           | 
## --------------|-----------|-----------|-----------|
##       unknown |       293 |        37 |       330 | 
##               |     0.000 |     0.001 |           | 
##               |     0.888 |     0.112 |     0.008 | 
##               |     0.008 |     0.008 |           | 
##               |     0.007 |     0.001 |           | 
## --------------|-----------|-----------|-----------|
##  Column Total |     36548 |      4640 |     41188 | 
##               |     0.887 |     0.113 |           | 
## --------------|-----------|-----------|-----------|
## 
##  
## Statistics for All Table Factors
## 
## 
## Pearson's Chi-squared test 
## ------------------------------------------------------------
## Chi^2 =  961.2424     d.f. =  11     p =  4.189763e-199 
## 
## 
## 

Marital and Yes

## 
##  
##    Cell Contents
## |-------------------------|
## |                       N |
## | Chi-square contribution |
## |           N / Row Total |
## |           N / Col Total |
## |         N / Table Total |
## |-------------------------|
## 
##  
## Total Observations in Table:  41188 
## 
##  
##              | bank$y 
## bank$marital |        no |       yes | Row Total | 
## -------------|-----------|-----------|-----------|
##     divorced |      4136 |       476 |      4612 | 
##              |     0.464 |     3.652 |           | 
##              |     0.897 |     0.103 |     0.112 | 
##              |     0.113 |     0.103 |           | 
##              |     0.100 |     0.012 |           | 
## -------------|-----------|-----------|-----------|
##      married |     22396 |      2532 |     24928 | 
##              |     3.450 |    27.174 |           | 
##              |     0.898 |     0.102 |     0.605 | 
##              |     0.613 |     0.546 |           | 
##              |     0.544 |     0.061 |           | 
## -------------|-----------|-----------|-----------|
##       single |      9948 |      1620 |     11568 | 
##              |     9.778 |    77.021 |           | 
##              |     0.860 |     0.140 |     0.281 | 
##              |     0.272 |     0.349 |           | 
##              |     0.242 |     0.039 |           | 
## -------------|-----------|-----------|-----------|
##      unknown |        68 |        12 |        80 | 
##              |     0.126 |     0.990 |           | 
##              |     0.850 |     0.150 |     0.002 | 
##              |     0.002 |     0.003 |           | 
##              |     0.002 |     0.000 |           | 
## -------------|-----------|-----------|-----------|
## Column Total |     36548 |      4640 |     41188 | 
##              |     0.887 |     0.113 |           | 
## -------------|-----------|-----------|-----------|
## 
##  
## Statistics for All Table Factors
## 
## 
## Pearson's Chi-squared test 
## ------------------------------------------------------------
## Chi^2 =  122.6552     d.f. =  3     p =  2.068015e-26 
## 
## 
## 

Education and Yes

## 
##  
##    Cell Contents
## |-------------------------|
## |                       N |
## | Chi-square contribution |
## |           N / Row Total |
## |           N / Col Total |
## |         N / Table Total |
## |-------------------------|
## 
##  
## Total Observations in Table:  41188 
## 
##  
##                     | bank$y 
##      bank$education |        no |       yes | Row Total | 
## --------------------|-----------|-----------|-----------|
##            basic.4y |      3748 |       428 |      4176 | 
##                     |     0.486 |     3.829 |           | 
##                     |     0.898 |     0.102 |     0.101 | 
##                     |     0.103 |     0.092 |           | 
##                     |     0.091 |     0.010 |           | 
## --------------------|-----------|-----------|-----------|
##            basic.6y |      2104 |       188 |      2292 | 
##                     |     2.423 |    19.088 |           | 
##                     |     0.918 |     0.082 |     0.056 | 
##                     |     0.058 |     0.041 |           | 
##                     |     0.051 |     0.005 |           | 
## --------------------|-----------|-----------|-----------|
##            basic.9y |      5572 |       473 |      6045 | 
##                     |     8.065 |    63.527 |           | 
##                     |     0.922 |     0.078 |     0.147 | 
##                     |     0.152 |     0.102 |           | 
##                     |     0.135 |     0.011 |           | 
## --------------------|-----------|-----------|-----------|
##         high.school |      8484 |      1031 |      9515 | 
##                     |     0.198 |     1.561 |           | 
##                     |     0.892 |     0.108 |     0.231 | 
##                     |     0.232 |     0.222 |           | 
##                     |     0.206 |     0.025 |           | 
## --------------------|-----------|-----------|-----------|
##          illiterate |        14 |         4 |        18 | 
##                     |     0.244 |     1.918 |           | 
##                     |     0.778 |     0.222 |     0.000 | 
##                     |     0.000 |     0.001 |           | 
##                     |     0.000 |     0.000 |           | 
## --------------------|-----------|-----------|-----------|
## professional.course |      4648 |       595 |      5243 | 
##                     |     0.004 |     0.032 |           | 
##                     |     0.887 |     0.113 |     0.127 | 
##                     |     0.127 |     0.128 |           | 
##                     |     0.113 |     0.014 |           | 
## --------------------|-----------|-----------|-----------|
##   university.degree |     10498 |      1670 |     12168 | 
##                     |     8.292 |    65.317 |           | 
##                     |     0.863 |     0.137 |     0.295 | 
##                     |     0.287 |     0.360 |           | 
##                     |     0.255 |     0.041 |           | 
## --------------------|-----------|-----------|-----------|
##             unknown |      1480 |       251 |      1731 | 
##                     |     2.041 |    16.079 |           | 
##                     |     0.855 |     0.145 |     0.042 | 
##                     |     0.040 |     0.054 |           | 
##                     |     0.036 |     0.006 |           | 
## --------------------|-----------|-----------|-----------|
##        Column Total |     36548 |      4640 |     41188 | 
##                     |     0.887 |     0.113 |           | 
## --------------------|-----------|-----------|-----------|
## 
##  
## Statistics for All Table Factors
## 
## 
## Pearson's Chi-squared test 
## ------------------------------------------------------------
## Chi^2 =  193.1059     d.f. =  7     p =  3.305189e-38 
## 
## 
## 

Default in Credit and Yes

## 
##  
##    Cell Contents
## |-------------------------|
## |                       N |
## | Chi-square contribution |
## |           N / Row Total |
## |           N / Col Total |
## |         N / Table Total |
## |-------------------------|
## 
##  
## Total Observations in Table:  41188 
## 
##  
##              | bank$y 
## bank$default |        no |       yes | Row Total | 
## -------------|-----------|-----------|-----------|
##           no |     28391 |      4197 |     32588 | 
##              |     9.562 |    75.315 |           | 
##              |     0.871 |     0.129 |     0.791 | 
##              |     0.777 |     0.905 |           | 
##              |     0.689 |     0.102 |           | 
## -------------|-----------|-----------|-----------|
##      unknown |      8154 |       443 |      8597 | 
##              |    36.198 |   285.122 |           | 
##              |     0.948 |     0.052 |     0.209 | 
##              |     0.223 |     0.095 |           | 
##              |     0.198 |     0.011 |           | 
## -------------|-----------|-----------|-----------|
##          yes |         3 |         0 |         3 | 
##              |     0.043 |     0.338 |           | 
##              |     1.000 |     0.000 |     0.000 | 
##              |     0.000 |     0.000 |           | 
##              |     0.000 |     0.000 |           | 
## -------------|-----------|-----------|-----------|
## Column Total |     36548 |      4640 |     41188 | 
##              |     0.887 |     0.113 |           | 
## -------------|-----------|-----------|-----------|
## 
##  
## Statistics for All Table Factors
## 
## 
## Pearson's Chi-squared test 
## ------------------------------------------------------------
## Chi^2 =  406.5775     d.f. =  2     p =  5.161958e-89 
## 
## 
## 

Contact Type and Yes

## 
##  
##    Cell Contents
## |-------------------------|
## |                       N |
## | Chi-square contribution |
## |           N / Row Total |
## |           N / Col Total |
## |         N / Table Total |
## |-------------------------|
## 
##  
## Total Observations in Table:  41188 
## 
##  
##              | bank$y 
## bank$contact |        no |       yes | Row Total | 
## -------------|-----------|-----------|-----------|
##     cellular |     22291 |      3853 |     26144 | 
##              |    35.521 |   279.790 |           | 
##              |     0.853 |     0.147 |     0.635 | 
##              |     0.610 |     0.830 |           | 
##              |     0.541 |     0.094 |           | 
## -------------|-----------|-----------|-----------|
##    telephone |     14257 |       787 |     15044 | 
##              |    61.730 |   486.229 |           | 
##              |     0.948 |     0.052 |     0.365 | 
##              |     0.390 |     0.170 |           | 
##              |     0.346 |     0.019 |           | 
## -------------|-----------|-----------|-----------|
## Column Total |     36548 |      4640 |     41188 | 
##              |     0.887 |     0.113 |           | 
## -------------|-----------|-----------|-----------|
## 
##  
## Statistics for All Table Factors
## 
## 
## Pearson's Chi-squared test 
## ------------------------------------------------------------
## Chi^2 =  863.2691     d.f. =  1     p =  9.481264e-190 
## 
## Pearson's Chi-squared test with Yates' continuity correction 
## ------------------------------------------------------------
## Chi^2 =  862.3184     d.f. =  1     p =  1.525986e-189 
## 
## 

Month and Yes

## 
##  
##    Cell Contents
## |-------------------------|
## |                       N |
## | Chi-square contribution |
## |           N / Row Total |
## |           N / Col Total |
## |         N / Table Total |
## |-------------------------|
## 
##  
## Total Observations in Table:  41188 
## 
##  
##              | bank$y 
##   bank$month |        no |       yes | Row Total | 
## -------------|-----------|-----------|-----------|
##          apr |      2093 |       539 |      2632 | 
##              |    25.178 |   198.321 |           | 
##              |     0.795 |     0.205 |     0.064 | 
##              |     0.057 |     0.116 |           | 
##              |     0.051 |     0.013 |           | 
## -------------|-----------|-----------|-----------|
##          aug |      5523 |       655 |      6178 | 
##              |     0.306 |     2.413 |           | 
##              |     0.894 |     0.106 |     0.150 | 
##              |     0.151 |     0.141 |           | 
##              |     0.134 |     0.016 |           | 
## -------------|-----------|-----------|-----------|
##          dec |        93 |        89 |       182 | 
##              |    29.052 |   228.836 |           | 
##              |     0.511 |     0.489 |     0.004 | 
##              |     0.003 |     0.019 |           | 
##              |     0.002 |     0.002 |           | 
## -------------|-----------|-----------|-----------|
##          jul |      6525 |       649 |      7174 | 
##              |     3.980 |    31.353 |           | 
##              |     0.910 |     0.090 |     0.174 | 
##              |     0.179 |     0.140 |           | 
##              |     0.158 |     0.016 |           | 
## -------------|-----------|-----------|-----------|
##          jun |      4759 |       559 |      5318 | 
##              |     0.341 |     2.683 |           | 
##              |     0.895 |     0.105 |     0.129 | 
##              |     0.130 |     0.120 |           | 
##              |     0.116 |     0.014 |           | 
## -------------|-----------|-----------|-----------|
##          mar |       270 |       276 |       546 | 
##              |    94.958 |   747.959 |           | 
##              |     0.495 |     0.505 |     0.013 | 
##              |     0.007 |     0.059 |           | 
##              |     0.007 |     0.007 |           | 
## -------------|-----------|-----------|-----------|
##          may |     12883 |       886 |     13769 | 
##              |    36.210 |   285.214 |           | 
##              |     0.936 |     0.064 |     0.334 | 
##              |     0.352 |     0.191 |           | 
##              |     0.313 |     0.022 |           | 
## -------------|-----------|-----------|-----------|
##          nov |      3685 |       416 |      4101 | 
##              |     0.581 |     4.579 |           | 
##              |     0.899 |     0.101 |     0.100 | 
##              |     0.101 |     0.090 |           | 
##              |     0.089 |     0.010 |           | 
## -------------|-----------|-----------|-----------|
##          oct |       403 |       315 |       718 | 
##              |    86.028 |   677.617 |           | 
##              |     0.561 |     0.439 |     0.017 | 
##              |     0.011 |     0.068 |           | 
##              |     0.010 |     0.008 |           | 
## -------------|-----------|-----------|-----------|
##          sep |       314 |       256 |       570 | 
##              |    72.723 |   572.818 |           | 
##              |     0.551 |     0.449 |     0.014 | 
##              |     0.009 |     0.055 |           | 
##              |     0.008 |     0.006 |           | 
## -------------|-----------|-----------|-----------|
## Column Total |     36548 |      4640 |     41188 | 
##              |     0.887 |     0.113 |           | 
## -------------|-----------|-----------|-----------|
## 
##  
## Statistics for All Table Factors
## 
## 
## Pearson's Chi-squared test 
## ------------------------------------------------------------
## Chi^2 =  3101.149     d.f. =  9     p =  0 
## 
## 
## 

Day of Week and Yes

## 
##  
##    Cell Contents
## |-------------------------|
## |                       N |
## | Chi-square contribution |
## |           N / Row Total |
## |           N / Col Total |
## |         N / Table Total |
## |-------------------------|
## 
##  
## Total Observations in Table:  41188 
## 
##  
##                  | bank$y 
## bank$day_of_week |        no |       yes | Row Total | 
## -----------------|-----------|-----------|-----------|
##              fri |      6981 |       846 |      7827 | 
##                  |     0.184 |     1.449 |           | 
##                  |     0.892 |     0.108 |     0.190 | 
##                  |     0.191 |     0.182 |           | 
##                  |     0.169 |     0.021 |           | 
## -----------------|-----------|-----------|-----------|
##              mon |      7667 |       847 |      8514 | 
##                  |     1.664 |    13.111 |           | 
##                  |     0.901 |     0.099 |     0.207 | 
##                  |     0.210 |     0.183 |           | 
##                  |     0.186 |     0.021 |           | 
## -----------------|-----------|-----------|-----------|
##              thu |      7578 |      1045 |      8623 | 
##                  |     0.708 |     5.574 |           | 
##                  |     0.879 |     0.121 |     0.209 | 
##                  |     0.207 |     0.225 |           | 
##                  |     0.184 |     0.025 |           | 
## -----------------|-----------|-----------|-----------|
##              tue |      7137 |       953 |      8090 | 
##                  |     0.241 |     1.901 |           | 
##                  |     0.882 |     0.118 |     0.196 | 
##                  |     0.195 |     0.205 |           | 
##                  |     0.173 |     0.023 |           | 
## -----------------|-----------|-----------|-----------|
##              wed |      7185 |       949 |      8134 | 
##                  |     0.148 |     1.165 |           | 
##                  |     0.883 |     0.117 |     0.197 | 
##                  |     0.197 |     0.205 |           | 
##                  |     0.174 |     0.023 |           | 
## -----------------|-----------|-----------|-----------|
##     Column Total |     36548 |      4640 |     41188 | 
##                  |     0.887 |     0.113 |           | 
## -----------------|-----------|-----------|-----------|
## 
##  
## Statistics for All Table Factors
## 
## 
## Pearson's Chi-squared test 
## ------------------------------------------------------------
## Chi^2 =  26.14494     d.f. =  4     p =  2.958482e-05 
## 
## 
## 

Poutcome and Yes

## 
##  
##    Cell Contents
## |-------------------------|
## |                       N |
## | Chi-square contribution |
## |           N / Row Total |
## |           N / Col Total |
## |         N / Table Total |
## |-------------------------|
## 
##  
## Total Observations in Table:  41188 
## 
##  
##               | bank$y 
## bank$poutcome |        no |       yes | Row Total | 
## --------------|-----------|-----------|-----------|
##       failure |      3647 |       605 |      4252 | 
##               |     4.207 |    33.141 |           | 
##               |     0.858 |     0.142 |     0.103 | 
##               |     0.100 |     0.130 |           | 
##               |     0.089 |     0.015 |           | 
## --------------|-----------|-----------|-----------|
##   nonexistent |     32422 |      3141 |     35563 | 
##               |    23.728 |   186.899 |           | 
##               |     0.912 |     0.088 |     0.863 | 
##               |     0.887 |     0.677 |           | 
##               |     0.787 |     0.076 |           | 
## --------------|-----------|-----------|-----------|
##       success |       479 |       894 |      1373 | 
##               |   448.651 |  3533.897 |           | 
##               |     0.349 |     0.651 |     0.033 | 
##               |     0.013 |     0.193 |           | 
##               |     0.012 |     0.022 |           | 
## --------------|-----------|-----------|-----------|
##  Column Total |     36548 |      4640 |     41188 | 
##               |     0.887 |     0.113 |           | 
## --------------|-----------|-----------|-----------|
## 
##  
## Statistics for All Table Factors
## 
## 
## Pearson's Chi-squared test 
## ------------------------------------------------------------
## Chi^2 =  4230.524     d.f. =  2     p =  0 
## 
## 
## 

Age Distribution

##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   17.00   32.00   38.00   40.02   47.00   98.00

Age vs Subscription

T tests

Duration and Y

Campaign and Y

Pdays and Y

Previous and Y

Employee Variation Rate and Y

Therefore, when employee variation rate is negative, i.e., when the client deals the less variation in the employees contacting him/her, s/he is more likely to open term deposits.

Consumer Price Index and Y

## 
##  Welch Two Sample t-test
## 
## data:  bank$cons.price.idx by bank$y
## t = 24.082, df = 5472.5, p-value < 2.2e-16
## alternative hypothesis: true difference in means is not equal to 0
## 99 percent confidence interval:
##  0.2226894 0.2760528
## sample estimates:
##  mean in group no mean in group yes 
##          93.60376          93.35439

Consumer Confidence Index and Y

## 
##  Welch Two Sample t-test
## 
## data:  bank$cons.conf.idx by bank$y
## t = -8.6365, df = 5258.3, p-value < 2.2e-16
## alternative hypothesis: true difference in means is not equal to 0
## 99 percent confidence interval:
##  -1.0429877 -0.5636368
## sample estimates:
##  mean in group no mean in group yes 
##         -40.59310         -39.78978

Euribor 3 month rate and Y

Number of Employees and Y