k-Means on RFM: One Iteration by Hand
This lesson is part of the course
In this lesson
You run one k-means iteration on the 12 standardised customers: distances in three dimensions, the nearest centroid, new centroids with AVERAGEIF and the cluster sizes.
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
- Recency, Frequency and Monetary from a Raw Order Log Locked
- Quintile Scores: PERCENTILE Cut-offs and PERCENTRANK Locked
- From Scores to Segments: Champions, At Risk & Co. Locked
- Segment Size vs Revenue Share Locked
- Standardising Variables with z-Scores Locked
- k-Means on RFM: One Iteration by Hand Locked
- Choosing k: Within-Cluster Sum of Squares and the Elbow Locked
- Segment Profiles and Targeted Campaign Economics Locked