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)? 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

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

Step: 3

blur-text-image

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

To sell is human

Answered: 1 week ago

Question

What is a break-even chart?

Answered: 1 week ago