Cluster Analysis - Distance from k-centroid to each member of the cluster?

I've run cluster analyses a number of times, but have never been asked this before....so I did some digging and could not find anything in the Alteryx toolset or on community that would help me answer it.

I understand how to run a cluster analysis and then append clusters with the tools shown below...I can see the average distance within cluster in the typical output. But how to get the distance from each of the k-centroids to each of the members of each cluster? For context I had grouped some store locations, and then someone asked me which stores are in the center of each cluster and which ones on the fringe.

Predictive Analysis

Accepted answers

ianwi

Hi @ggruccio,

The Find Nearest Neighbors tool may provide what you're looking for. You'll need to grab the cluster assignments to link them with your store locations but you can find the "distance" between them. Also, including the Interactive Lesson in case you want more info!

Hope that helps!

All comments

StephenRuhl

Hello @ggruccio I would recommend using the Poly-Build Tool to build a convex hull polygon, then we can use the Spatial Info tool to get the geographically weighted center. This allows us to use the Distance Tool to get distances from center.

ggruccio

HI @StephenR,

Thank you and I think that would work if I had done the cluster analysis based on latitude/longitude or spatial position. However this is based on various factors including demographics, store performance, competitive factors etc. Is there a way to get the relative 'coordinates' for each observation based on these factors? Thanks!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703