Question: Can you help me turn the data and answer what causes the churn (attrition)? Let's say it is due to unanswered calls, can you include

Can you help me turn the data and answer what causes the churn (attrition)? Let's say it is due to unanswered calls, can you include /show the data where you pulled it to support the answer. Thank you!

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!