Tutorvo

Kaplan-Meier with Censored Customers: Step Table and Curve

Lesson 4 of 820 minLab

This lesson is part of the course

In this lesson

You build a Kaplan-Meier table straight from a customer list with COUNTIF and COUNTIFS, keep the censored customers in the risk set, read off the median lifetime and draw the step-shaped survival curve.

Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.

Lessons in this course

  1. Tenure and the Churn Flag: Censoring at a Cut-Off DateLab15 min Locked
  2. The Monthly Hazard Rate by Tenure MonthLab15 min Locked
  3. The Survival Curve S(t) = Π(1 − h) and the Median LifetimeLab15 min Locked
  4. Kaplan-Meier with Censored Customers: Step Table and CurveLab20 min Locked
  5. Comparing Segments: Basic vs Plus Curves and a Simple Log-Rank TestLab20 min Locked
  6. Expected Lifetime and LTV from the Survival CurveLab15 min Locked
  7. Churn Drivers: Churn Rate by Attribute and LiftLab15 min Locked
  8. Retention Intervention ROI: Who Should Get the Save Offer?Lab15 min Locked