Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you help me turn the data and answer what causes the churn (attrition) and 3 solutions (actionable items) to resolve the churn. customer revenue
Can you help me turn the data and answer what causes the churn (attrition) and 3 solutions (actionable items) to resolve the churn.
customer | revenue | dropvce | blckvce | unansvce | custcare | threeway | mourec | outcalls | incalls | peakvce | opeakvce | dropblk | callfwdv | callwait | months | uniqsubs | actvsubs | phones |
1032537 | 37.41 | 15 | 0 | 49 | 7 | 0 | 59 | 47 | 1 | 112 | 60 | 19 | 0 | 0 | 21 | 1 | 1 | 2 |
1032542 | 33.395 | 1 | 0 | 0 | 0 | 0 | 27 | 12 | 0 | 9 | 16 | 2 | 0 | 0 | 25 | 1 | 1 | 1 |
1032546 | 32.78 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 12 | 6 | 1 | 0 | 0 | 19 | 2 | 2 | 1 |
1032549 | 28.075 | 1 | 0 | 8 | 6 | 0 | 1 | 6 | 1 | 50 | 21 | 1 | 0 | 0 | 21 | 2 | 2 | 1 |
1032551 | 81.555 | 2 | 2 | 16 | 1 | 0 | 97 | 16 | 15 | 71 | 35 | 4 | 0 | 0 | 23 | 3 | 3 | 2 |
1032552 | 15.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 25 | 1 | 1 | 2 |
1032557 | 34.64 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 4 | 5 | 2 | 0 | 0 | 23 | 2 | 2 | 1 |
1032562 | 85.765 | 9 | 4 | 113 | 3 | 2 | 358 | 132 | 77 | 194 | 378 | 17 | 0 | 3 | 21 | 1 | 1 | 2 |
1032565 | 29.55 | 1 | 16 | 7 | 0 | 0 | 9 | 15 | 0 | 60 | 17 | 17 | 0 | 0 | 21 | 1 | 1 | 2 |
1032567 | 32.445 | 3 | 0 | 11 | 0 | 0 | 76 | 24 | 1 | 68 | 29 | 3 | 0 | 0 | 19 | 1 | 1 | 1 |
1032568 | 83.96 | 2 | 5 | 47 | 3 | 0 | 91 | 9 | 0 | 357 | 25 | 7 | 0 | 2 | 25 | 1 | 1 | 2 |
1032572 | 56.185 | 2 | 0 | 8 | 0 | 0 | 58 | 32 | 3 | 66 | 54 | 2 | 0 | 0 | 25 | 2 | 2 | 1 |
1032574 | 90.545 | 16 | 19 | 96 | 11 | 1 | 773 | 231 | 114 | 474 | 506 | 38 | 0 | 45 | 21 | 1 | 1 | 8 |
1032580 | 32.1 | 1 | 0 | 10 | 0 | 0 | 20 | 4 | 0 | 32 | 25 | 2 | 0 | 0 | 21 | 2 | 2 | 2 |
1032584 | 60.365 | 3 | 3 | 19 | 1 | 0 | 69 | 26 | 11 | 77 | 55 | 6 | 0 | 2 | 25 | 2 | 2 | 3 |
1032585 | 30.535 | 2 | 0 | 12 | 1 | 0 | 16 | 10 | 3 | 42 | 9 | 2 | 0 | 0 | 21 | 2 | 2 | 1 |
1032586 | 39.895 | 1 | 8 | 10 | 0 | 0 | 180 | 5 | 0 | 94 | 33 | 10 | 0 | 0 | 23 | 1 | 1 | 5 |
1032587 | 66.81 | 3 | 1 | 34 | 0 | 0 | 278 | 84 | 32 | 128 | 152 | 4 | 0 | 2 | 21 | 1 | 1 | 1 |
1032593 | 57.555 | 13 | 7 | 55 | 0 | 0 | 82 | 39 | 7 | 102 | 78 | 25 | 0 | 1 | 21 | 4 | 3 | 4 |
1032604 | 69.11 | 9 | 3 | 65 | 5 | 2 | 256 | 92 | 10 | 201 | 256 | 16 | 0 | 2 | 21 | 1 | 1 | 1 |
1032609 | 32.195 | 2 | 0 | 8 | 1 | 0 | 0 | 4 | 0 | 52 | 6 | 3 | 0 | 0 | 21 | 1 | 1 | 1 |
1032611 | 29.82 | 1 | 0 | 0 | 0 | 0 | 3 | 2 | 0 | 34 | 10 | 1 | 0 | 0 | 19 | 1 | 1 | 1 |
1032616 | 29.55 | 3 | 14 | 10 | 11 | 1 | 89 | 0 | 0 | 71 | 30 | 17 | 0 | 0 | 21 | 1 | 1 | 1 |
1032617 | 101.555 | 28 | 98 | 20 | 8 | 2 | 163 | 22 | 0 | 145 | 77 | 133 | 0 | 6 | 19 | 1 | 1 | 2 |
1032619 | 75.48 | 3 | 8 | 34 | 0 | 0 | 74 | 23 | 39 | 122 | 37 | 12 | 0 | 1 | 23 | 4 | 4 | 4 |
1032620 | 45.255 | 5 | 0 | 27 | 0 | 0 | 92 | 1 | 0 | 78 | 45 | 6 | 0 | 1 | 19 | 1 | 1 | 1 |
1032625 | 52.09 | 1 | 6 | 54 | 1 | 0 | 30 | 18 | 1 | 75 | 41 | 6 | 0 | 1 | 23 | 1 | 1 | 2 |
1032629 | 49.84 | 3 | 0 | 304 | 1 | 0 | 50 | 1 | 4 | 62 | 29 | 3 | 0 | 0 | 19 | 1 | 1 | 2 |
1032631 | 29.55 | 3 | 0 | 15 | 0 | 0 | 17 | 6 | 0 | 36 | 14 | 3 | 0 | 0 | 21 | 1 | 1 | 1 |
1032634 | 29.82 | 1 | 1 | 5 | 0 | 0 | 3 | 3 | 0 | 15 | 17 | 2 | 0 | 0 | 19 | 2 | 2 | 1 |
1032648 | 73.72 | 5 | 0 | 1 | 5 | 0 | 232 | 22 | 3 | 97 | 147 | 6 | 0 | 3 | 25 | 1 | 1 | 2 |
1032652 | 76.145 | 1 | 1 | 10 | 0 | 0 | 0 | 0 | 0 | 34 | 12 | 3 | 0 | 0 | 25 | 1 | 1 | 1 |
1032653 | 29.55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21 | 1 | 1 | 1 |
1032654 | 26.06 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 7 | 6 | 1 | 0 | 0 | 19 | 2 | 1 | 1 |
1032656 | 55.075 | 5 | 0 | 24 | 2 | 0 | 86 | 26 | 9 | 59 | 60 | 7 | 0 | 1 | 19 | 1 | 1 | 2 |
1032658 | 50.225 | 3 | 0 | 12 | 0 | 0 | 2 | 3 | 1 | 15 | 25 | 3 | 0 | 0 | 21 | 1 | 1 | 1 |
1032663 | 31.99 | 1 | 2 | 2 | 0 | 0 | 38 | 12 | 6 | 50 | 8 | 3 | 0 | 1 | 23 | 3 | 2 | 1 |
1032666 | 29.975 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 4 | 0 | 0 | 0 | 25 | 1 | 1 | 1 |
1032677 | 32.125 | 3 | 11 | 46 | 4 | 0 | 118 | 11 | 10 | 79 | 49 | 13 | 0 | 0 | 23 | 2 | 2 | 3 |
1032678 | 30.705 | 0 | 0 | 7 | 0 | 0 | 0 | 4 | 0 | 23 | 15 | 0 | 0 | 0 | 19 | 1 | 1 | 1 |
1032680 | 29.55 | 2 | 2 | 16 | 0 | 1 | 40 | 8 | 10 | 50 | 16 | 5 | 0 | 1 | 21 | 3 | 3 | 1 |
1032690 | 28.59 | 0 | 3 | 15 | 0 | 0 | 6 | 5 | 0 | 14 | 11 | 3 | 0 | 0 | 21 | 1 | 1 | 1 |
1032691 | 28.325 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | 1 | 1 | 1 |
1032707 | 96.075 | 6 | 1 | 25 | 0 | 0 | 180 | 28 | 1 | 125 | 90 | 9 | 0 | 2 | 25 | 1 | 1 | 1 |
1032710 | 28.075 | 1 | 15 | 3 | 0 | 0 | 7 | 5 | 2 | 14 | 23 | 16 | 0 | 0 | 25 | 5 | 3 | 2 |
1032715 | 29.55 | 0 | 1 | 38 | 1 | 0 | 0 | 11 | 0 | 27 | 24 | 1 | 0 | 0 | 25 | 2 | 2 | 1 |
1032716 | 29.55 | 1 | 1 | 4 | 0 | 0 | 1 | 2 | 0 | 19 | 6 | 2 | 0 | 1 | 21 | 1 | 1 | 1 |
1032720 | 46.76 | 1 | 1 | 12 | 0 | 0 | 6 | 2 | 0 | 26 | 18 | 2 | 0 | 0 | 23 | 1 | 1 | 1 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started