Skip to content
K Means Clustering
The easiest way to use this is by using the =GetKMeansCluster() formula in a table.
Points
x
y
z
Cluster
Cluster from generated
There are no rows in this table
For something that will probably calculate quicker, you can use =GenerateAllClusters() and then add those in order with a column formula like =Clusters.Nth(Points.Find(thisRow))
Note that the name of the clusters will differ based on randomness even with the same inputs, but the centroids should be about the same.
I also wrapped clustering of 1 to provide a centroid formula. The centroid of the points above is: ()
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.