Customer Churn & Survival Analysis: Hazard Rates, Kaplan-Meier & Retention Curves
Tenure and censoring from raw dates, monthly hazard rates, survival curves and the median lifetime, Kaplan-Meier from a customer list with a step chart, Basic vs Plus curves with a simple log-rank test, LTV from the survival curve, churn drivers with lift and the ROI of a save offer: 8 graded labs on one fictional subscription box.
The first lesson is free — no account needed.
About this course
A customer churn and survival analysis course that measures how long the subscribers of one fictional plant-care subscription box stay, in a spreadsheet, for subscription, retention and CRM analysts, data science students and founders. You turn start and cancellation dates into tenure and a churn flag and censor active customers at the cut-off date, follow a cohort of 2,400 subscribers and calculate the hazard rate for each tenure month, chain 24 hazards into a survival curve and read the median customer lifetime, build a Kaplan-Meier table from a customer list with COUNTIFS and draw the step chart, compare the Basic and Plus plans with a simplified log-rank test, turn the survival curve into expected paid months and a discounted LTV, rank churn drivers by lift and price a save offer for three target groups by net value and ROI. The first lab is free.
Lessons
- Tenure and the Churn Flag: Censoring at a Cut-Off DateFree
- The Monthly Hazard Rate by Tenure Month Pro
- The Survival Curve S(t) = Π(1 − h) and the Median Lifetime Pro
- Kaplan-Meier with Censored Customers: Step Table and Curve Pro
- Comparing Segments: Basic vs Plus Curves and a Simple Log-Rank Test Pro
- Expected Lifetime and LTV from the Survival Curve Pro
- Churn Drivers: Churn Rate by Attribute and Lift Pro
- Retention Intervention ROI: Who Should Get the Save Offer? Pro