Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate RFM analysis (Recency, frequency, and monetization) and Customer Lifetime Value (CLV) . The data below: CustomerID, Gender Senior Citizen Tenure Months Contract Monthly Charges

Calculate RFM analysis (Recency, frequency, and monetization) and Customer Lifetime Value (CLV) . The data below:

image text in transcribed
CustomerID, Gender Senior Citizen Tenure Months Contract Monthly Charges Total Charges Lat Long Latitude Longitude Senior Citizen Partner Dependents 3668-QPYBK Male No 2 Month-to-month 53.85 108.15 33.964131, -1 33.964131 -118.272783 No No No 9237-HQITU Female No 2 Month-to-month 70.7 151.65 34.059281, -1 34.059281 -118.307420 No No Yes 9305-CDSKC Female No Month-to-month 99.65 820.5 34.048013, -1 34.048013 -118.293953 No No Yes 7892-POOKP Female No 28 Month-to-month 104.8 3046.05 34.062125, -1 34.062125 118.315709 No Yes Yes 0280-XJGEX Male No 49 Month-to-month 103.7 5036.3 34.039224, -1 34.039224 -118.266293 No No Yes 4190-MFLUW Female No 10 Month-to-month 55.2 528.35 34.066367, -1 34.066367 -118.309868 No Yes No CustomerID, | Phone Service Multiple Lines Internet Service Online Security Online Backup Device ProtectTech Support Streaming TV Streaming Movies Paperless Billi Payment Method 3668-QPYBK Yes No DSL Yes Yes No No No No Yes Mailed check 9237-HQITU Yes No Fiber optic No No No No No No Yes Electronic check 9305-CDSKC |Yes Yes Fiber optic No No Yes No Yes Yes Yes Electronic check 7892-POOKP I Yes Yes Fiber optic No No Yes Yes Yes Yes Yes Electronic check 0280-XJGEX Yes Yes Fiber optic No Yes Yes No Yes Yes Yes Bank transfer (automatic) 4190-MFLUW Yes No DSL No No Yes Yes No No No Credit card (automatic) CustomerID, Churn Label Churn Value Churn Score CLTV 3658-QPYBK Yes 86 3239 9237-HQITU Yes 67 2701 9305-CDSKC Yes 86 5372 7892-POOKP Yes 84 5003 0280-XJGEX Yes 89 5340 4190-MFLUW Yes 78 5925

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

Services Marketing Concepts, Strategies, & Cases

Authors: Douglas Hoffman, john Bateson

4th edition

1439039399, 978-1439039397

More Books

Students also viewed these Marketing questions