+1443 776-2705 panelessays@gmail.com

Telecom Customer Churn Prediction Assessment

Customer Churn is a burning problem for Telecom companies. In this project, we simulate one such case of customer churn where we work on a data of postpaid customers with a contract. The data has information about the customer usage behavior, contract details and the payment details. The data also indicates which were the customers who canceled their service. Based on this past data, we need to build a model which can predict whether a customer will cancel their service in the future or not.

You are expected to do the following : 

  1. EDA (16 Marks) 
    • How does the data looks like, Univariate and bivariate analysis. Plots and charts which illustrate the relationships between variables (4 Marks)
    • Look out for outliers and missing values (4 Marks)
    • Check for multicollinearity & treat it (4 Marks)
    • Summarize the insights you get from EDA  (4 Marks)
  2. Build Models and compare them to get to the best one (39 Marks) 
    • Logistic Regression (8 Marks)
    • KNN (8 Marks)
    • Naive Bayes (8 Marks) (is it applicable here? comment and if it is not applicable, how can you build an NB model in this case?) 
    • Model Comparison using Model Performance metrics & Interpretation (15 Marks)
  3. Actionable Insights (5 marks) 
    • Interpretation & Recommendations from the best model

Please note the following:

  • Your submission should have two files – 1) report in PDF format with a word limit of 3000 words, 2) R Code file. Appendices are not counted in the word limit.
  • You must give the sources of data presented. Do not refer to blogs; Wikipedia etc.

Description

Variables
Churn 1 if customer cancelled service, 0 if not
AccountWeeks number of weeks customer has had active account
ContractRenewal 1 if customer recently renewed contract, 0 if not
DataPlan 1 if customer has data plan, 0 if not
DataUsage gigabytes of monthly data usage
CustServCalls number of calls into customer service
DayMins average daytime minutes per month
DayCalls average number of daytime calls
MonthlyCharge average monthly bill
OverageFee largest overage fee in last 12 months
RoamMins average number of roaming minutes

Data

Churn AccountWeeks ContractRenewal DataPlan DataUsage CustServCalls DayMins DayCalls MonthlyCharge OverageFee RoamMins
0 128 1 1 2.70 1 265.1 110 89.0 9.87 10.0
0 107 1 1 3.70 1 161.6 123 82.0 9.78 13.7
0 137 1 0 0.00 0 243.4 114 52.0 6.06 12.2
0 84 0 0 0.00 2 299.4 71 57.0 3.10 6.6
0 75 0 0 0.00 3 166.7 113 41.0 7.42 10.1
0 118 0 0 0.00 0 223.4 98 57.0 11.03 6.3
0 121 1 1 2.03 3 218.2 88 87.3 17.43 7.5
0 147 0 0 0.00 0 157.0 79 36.0 5.16 7.1
0 117 1 0 0.19 1 184.5 97 63.9 17.58 8.7
0 141 0 1 3.02 0 258.6 84 93.2 11.10 11.2
1 65 1 0 0.29 4 129.1 137 44.9 11.43 12.7
0 74 1 0 0.34 0 187.7 127 49.4 8.17 9.1
0 168 1 0 0.00 1 128.8 96 31.0 5.25 11.2
0 95 1 0 0.44 3 156.6 88 52.4 12.38 12.3
0 62 1 0 0.00 4 120.7 70 47.0 15.36 13.1
1 161 1 0 0.00 4 332.9 67 84.0 15.89 5.4
0 85 1 1 3.73 1 196.4 139 95.3 14.05 13.8
0 93 1 0 0.00 3 190.7 114 51.0 10.91 8.1
0 76 1 1 2.70 1 189.7 66 78.0 10.64 10.0
0 73 1 0 0.00 1 224.4 90 52.0 7.98 13.0
0 147 1 0 0.31 0 155.1 117 50.1 11.99 10.6
1 77 1 0 0.00 5 62.4 89 26.0 8.50 5.7
0 130 1 0 0.00 0 183.0 112 38.0 3.65 9.5
0 111 1 0 0.39 2 110.4 103 34.9 6.87 7.7
0 132 1 0 0.00 0 81.1 86 35.0 12.26 10.3
0 174 1 0 0.00 3 124.3 76 45.0 13.86 15.5
0 57 1 1 2.57 0 213.0 115 78.7 9.56 9.5
0 54 1 0 0.00 3 134.3 73 37.0 7.78 14.7
0 20 1 0 0.32 0 190.0 109 58.2 12.91 6.3
0 49 1 0 0.21 1 119.3 117 41.1 10.76 11.1
0 142 1 0 0.00 2 84.8 95 27.0 6.84 14.2
0 75 1 0 0.00 1 226.1 105 56.0 10.08 10.3
0 172 1 0 0.00 3 212.0 121 39.0 1.56 12.6
1 12 1 0 0.00 1 249.6 118 64.0 12.62 11.8
0 57 1 1 2.24 0 176.8 94 69.4 9.75 8.3
0 72 1 1 3.97 3 220.0 80 95.7 10.87 14.7
0 36 1 1 3.92 0 146.3 128 78.2 8.13 14.5
0 78 1 0 0.00 1 130.8 64 42.0 11.19 10.0
0 136 0 1 2.84 3 203.9 106 79.4 9.38 10.5
0 149 1 0 0.00 1 140.4 94 47.0 13.59 11.1
0 98 1 0 0.30 3 126.3 102 39.0 8.34 9.4
1 135 0 1 3.94 0 173.1 85 86.4 10.20 14.6
0 34 1 0 0.00 2 124.8 82 46.0 14.11 10.0
0 160 1 0 0.38 3 85.8 77 32.8 8.27 9.2
0 64 1 0 0.24 1 154.0 67 48.4 11.29 3.5
0 59 1 1 2.30 2 120.9 97 62.0 10.65 8.5
0 65 1 0 0.00 3 211.3 120 50.0 8.13 13.2
0 142 1 0 0.35 2 187.0 133 47.5 6.73 7.4
1 119 1 0 0.00 5 159.1 114 47.0 11.57 8.8
0 97 1 1 2.97 1 133.2 135 71.7 10.86 11.0
0 52 1 0 0.32 3 191.9 108 59.2 13.49 7.8
0 60 1 0 0.00 1 220.6 57 56.0 10.56 6.8
0 10 1 0 0.00 2 186.1 112 48.0 9.51 11.4
0 96 1 0 0.21 2 160.2 117 52.1 13.38 9.3
1 87 1 0 0.00 5 151.0 83 45.0 10.99 9.7
0 81 1 0 0.11 1 175.5 67 53.1 12.47 10.2
0 141 1 0 0.00 1 126.9 98 37.0 9.00 8.0
1 121 1 1 1.57 3 198.4 129 56.7 3.77 5.8
0 68 1 0 0.00 3 148.8 70 47.0 12.33 12.1
0 125 1 0 0.00 1 229.3 103 55.0 8.87 12.0
0 174 1 0 0.00 1 192.1 97 48.0 8.50 11.4
0 116 1 1 3.13 2 268.6 83 92.3 8.91 11.6
0 74 1 1 3.94 2 193.7 91 93.4 12.31 14.6
0 149 1 1 3.40 3 180.7 92 81.0 9.39 12.6
0 38 1 0 0.00 2 131.2 98 37.0 8.15 8.2
0 40 1 1 1.67 2 148.1 74 56.7 8.48 6.2
0 43 0 0 0.00 0 251.5 105 61.0 10.64 9.3
0 113 0 0 0.00 0 125.2 93 39.0 10.32 8.3
0 126 1 0 0.00 1 211.6 70 55.0 10.85 7.8
1 150 1 0 0.00 4 178.9 101 45.0 8.46 13.8
0 138 1 0 0.00 3 241.8 93 56.0 8.53 11.8
0 162 1 1 3.27 0 224.9 97 87.7 9.41 12.1
0 147 1 0 0.00 3 248.6 83 55.0 7.45 8.0
0 90 1 0 0.00 1 203.4 146 54.0 11.34 7.3
0 85 1 0 0.00 0 235.8 109 54.0 7.86 12.0
0 50 1 0 0.00 1 157.1 90 46.0 11.17 6.1
1 82 1 0 0.21 0 300.3 109 69.1 9.05 11.7
1 144 1 0 0.21 4 61.6 117 20.1 3.86 8.2
0 46 1 0 0.26 2 214.1 72 53.6 8.22 8.2
0 70 1 0 0.30 1 170.2 98 46.0 7.76 15.0
0 144 1 0 0.00 1 201.1 99 60.0 15.18 13.2
0 116 0 0 0.30 3 215.4 104 58.0 10.24 12.6
0 55 1 1 2.97 3 165.6 123 69.7 6.81 11.0
0 70 1 1 2.65 1 249.5 101 91.5 12.99 9.8
1 106 1 0 0.00 2 210.6 96 57.0 12.46 12.4
0 128 1 1 2.32 0 179.3 104 73.2 11.30 8.6
1 94 1 0 0.00 4 157.9 105 41.0 7.75 8.0
0 111 1 0 0.00 1 214.3 118 55.0 10.43 12.0
0 74 1 1 2.94 2 154.1 104 66.4 6.17 10.9
1 128 1 0 0.00 1 237.9 125 62.0 12.38 13.9
0 82 1 0 0.17 1 143.9 61 43.7 9.75 11.1
1 155 1 0 0.00 0 203.4 100 51.0 9.55 8.9
0 80 1 0 0.00 1 124.3 100 36.0 8.65 7.9
0 78 1 0 0.00 3 252.9 93 59.0 8.92 9.5
0 90 1 0 0.00 3 179.1 71 47.0 9.53 10.6
0 104 1 0 0.30 1 278.4 106 58.0 4.05 9.8
0 73 1 0 0.00 0 160.1 110 46.0 10.67 13.0
0 99 1 0 0.00 4 198.2 87 52.0 10.37 8.7
1 120 1 0 0.00 1 212.1 131 54.0 10.47 5.3
1 77 1 0 0.00 2 251.8 72 61.0 10.29 9.8
0 98 1 1 1.19 4 161.2 114 60.9 12.61 4.4
0 108 1 0 0.34 0 178.3 137 50.4 9.45 14.6
0 135 1 0 0.00 0 151.7 82 36.0 5.95 10.5
0 95 1 0 0.00 1 135.0 99 39.0 9.18 12.5
0 122 1 0 0.39 1 170.5 94 47.9 8.69 11.3
0 95 1 0 0.00 4 238.1 65 57.0 9.36 11.8
0 36 1 1 2.43 2 281.4 102 90.3 10.11 9.0
0 93 1 1 2.65 1 117.9 131 61.5 8.23 9.8
0 141 1 1 2.73 1 148.6 91 64.3 6.56 10.1
0 157 1 0 0.00 3 229.8 90 52.0 7.40 9.6
0 120 1 0 0.00 1 165.0 100 56.0 15.86 8.3
0 103 1 0 0.00 2 185.0 117 51.0 11.17 12.6
0 98 1 0 0.00 4 161.0 117 44.0 9.55 12.1
0 125 1 0 0.00 1 126.7 108 40.0 10.30 13.3
0 63 1 0 0.00 1 58.9 125 25.0 8.48 9.4
1 36 0 1 5.40 0 196.8 89 110.0 12.75 20.0
0 64 1 0 0.29 1 162.6 83 43.9 7.62 14.2
1 74 1 0 0.21 1 282.5 114 69.1 11.00 9.4
0 112 1 1 2.70 2 113.7 117 60.0 7.88 10.0
0 97 1 0 0.00 2 239.8 125 60.0 10.74 8.7
0 46 1 0 0.21 1 210.2 92 58.1 11.37 13.1
0 41 1 1 1.94 0 213.8 102 68.4 7.09 7.2
0 121 1 0 0.00 3 190.7 103 49.0 9.18 9.8
0 193 1 0 0.00 1 170.9 124 41.0 6.62 11.6
0 130 1 0 0.00 2 154.2 119 36.0 5.51 9.2
0 85 1 0 0.40 1 201.4 52 58.0 11.47 12.0
1 162 1 0 0.00 4 70.7 108 26.0 7.88 9.1
1 61 1 1 1.73 4 187.5 124 62.3 7.33 6.4
0 92 1 0 0.00 2 91.7 90 33.0 9.69 9.2
0 131 1 1 2.57 3 214.2 115 76.7 8.09 9.5
0 90 1 0 0.00 3 145.5 92 44.0 10.89 10.9
0 75 1 0 0.00 1 166.3 125 42.0 7.91 6.1
0 78 1 0 0.00 1 231.0 115 59.0 11.52 9.5
0 82 1 0 0.00 4 200.3 96 52.0 10.06 7.1
0 163 1 0 0.00 1 197.0 109 51.0 10.13 9.1
0 91 0 0 0.31 3 129.9 112 40.1 8.67 11.2
0 75 1 1 1.43 5 175.8 97 63.3 10.88 5.3
0 91 1 0 0.00 3 203.1 106 53.0 10.51 12.0
0 127 1 1 3.02 1 183.2 117 72.2 6.34 11.2
0 113 1 1 2.75 2 205.0 101 75.5 7.60 10.2
0 110 1 0 0.00 1 148.5 115 49.0 13.82 12.4
0 120 1 1 2.84 0 200.3 68 81.4 11.02 10.5
0 157 1 1 1.84 3 192.6 107 68.4 9.78 6.8
0 103 1 0 0.00 1 246.5 47 59.0 9.78 11.7
1 117 0 0 0.00 2 167.1 86 44.0 8.88 14.1
0 140 1 0 0.00 3 231.9 101 54.0 8.01 14.3
0 127 1 0 0.00 1 146.7 91 43.0 10.18 13.7
0 83 0 0 0.26 1 271.5 87 67.6 10.82 11.7
0 121 1 0 0.00 1 181.5 121 50.0 10.92 8.5
0 145 1 1 3.00 2 257.7 97 88.0 8.11 11.1
0 113 1 0 0.00 1 193.8 99 52.0 11.07 10.6
0 117 1 0 0.00 1 102.8 119 36.0 10.34 10.1
0 65 1 0 0.00 1 187.9 116 46.0 7.88 7.5
0 56 1 0 0.00 1 226.0 112 60.0 12.43 6.9
0 96 1 0 0.00 5 260.4 115 57.0 7.30 11.5
0 151 1 0 0.00 0 178.7 116 56.0 14.61 9.8
1 83 1 0 0.00 0 337.4 120 77.0 11.37 15.8
0 139 1 1 3.70 0 157.6 129 85.0 12.35 13.7
0 6 1 0 0.00 1 183.6 117 54.0 12.84 10.2
0 115 1 1 2.59 1 142.1 124 65.9 9.17 9.6
0 87 1 0 0.31 0 136.3 97 41.1 8.61 7.1
0 141 1 0 0.00 0 217.1 110 58.0 12.08 12.0
0 141 1 1 2.84 3 187.5 99 81.4 12.07 10.5
0 62 1 0 0.00 1 98.9 103 29.0 6.77 12.2
0 146 1 0 0.00 1 206.3 151 48.0 7.43 6.1
0 92 1 1 3.27 2 243.1 92 92.7 10.69 12.1
0 185 1 1 2.03 1 189.8 126 67.3 8.17 7.5
0 148 1 0 0.39 1 202.0 102 59.9 12.16 10.9
0 94 1 1 3.46 1 170.1 124 80.6 9.67 12.8
0 32 1 0 0.00 0 230.9 87 56.0 9.37 6.3
0 68 1 0 0.00 1 237.1 105 60.0 11.18 13.2
0 64 1 1 2.86 2 182.1 91 74.6 8.49 10.6
0 25 1 0 0.14 3 119.3 87 40.4 10.58 10.5
0 65 1 0 0.00 1 116.8 87 36.0 8.95 14.1
0 179 1 0 0.00 0 219.2 92 50.0 7.47 6.1
0 94 1 0 0.00 2 252.6 104 58.0 8.45 11.1
0 62 1 0 0.00 0 147.1 91 42.0 9.52 12.2
0 127 1 0 0.00 2 202.1 103 54.0 11.47 11.5
0 116 1 0 0.23 3 173.5 93 48.3 9.71 16.2
0 70 1 0 0.00 3 232.1 122 65.0 14.62 0.0
0 94 0 1 2.57 4 197.1 125 77.7 10.73 9.5
1 126 1 0 0.00 5 58.2 94 22.0 6.94 11.9
0 67 1 1 2.67 2 115.6 111 66.7 11.89 9.9
0 19 1 0 0.14 2 186.1 98 55.4 12.72 14.6
0 170 0 0 0.00 3 259.9 68 66.0 12.25 8.4
0 73 1 0 0.00 1 214.3 145 60.0 13.43 10.8
0 106 1 0 0.00 1 158.7 74 33.0 3.22 10.2
0 93 1 0 0.19 2 271.6 71 67.9 11.47 10.9
0 164 1 0 0.27 1 160.6 111 44.7 8.16 9.0
0 51 1 0 0.00 1 232.4 109 56.0 9.37 9.1
0 107 1 0 0.00 0 133.8 85 39.0 9.03 8.9
0 130 1 0 0.35 1 176.9 109 41.5 4.54 9.5
0 80 1 0 0.00 2 209.9 74 53.0 9.76 8.8
0 94 1 0 0.22 0 137.5 118 43.2 10.16 13.4
0 118 1 1 2.57 1 289.5 52 89.7 8.33 9.5
0 117 1 1 1.84 1 198.1 86 67.4 8.85 6.8
0 78 1 0 0.00 0 149.7 119 41.0 9.11 9.7
1 208 1 0 0.33 2 326.5 67 74.3 8.82 10.7
1 131 0 1 3.73 4 292.9 101 104.3 9.99 13.8
0 63 1 0 0.00 0 83.0 64 30.0 8.85 13.0
0 53 1 1 3.54 3 145.7 146 79.4 11.03 13.1
0 62 1 0 0.00 2 182.3 101 59.0 16.41 11.2
0 97 1 0 0.00 3 218.0 86 53.0 9.20 6.4
0 105 1 0 0.00 2 140.6 109 40.0 8.93 6.8
0 157 1 0 0.00 1 152.7 105 48.0 12.88 9.4
0 66 1 1 3.27 1 106.7 76 68.7 10.49 12.1
0 122 1 0 0.00 2 243.8 98 49.0 4.20 13.7
0 38 1 0 0.00 3 194.4 94 49.0 9.34 10.8
0 106 1 0 0.00 3 213.9 95 50.0 7.60 12.2