Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Complex Analysis

Authors: Dennis G Zill, Patrick D Shanahan

3rd Edition

1449694624, 9781449694623

More Books

Students also viewed these Mathematics questions

Question

What are the purposes of promotion ?

Answered: 1 week ago

Question

Define promotion.

Answered: 1 week ago