Join Curt Frye for an in-depth discussion in this video What does cluster analysis look like in Excel?, part of Learning Excel Cluster Analysis.
…Before I dive into the mechanics of creating a centroid analysis workbook, I…wanted to give you an idea of what the final result will look like.…My sample file is the cluster analysis demo macro enabled workbook, and you…can find it in the chapter one folder of your exercise files archive.…This file contains a table of data.…So I have two dimensions, x and y, and this is just demonstration data.…And then I have a list of distances.…Two centroids that appear in this table here.…
So this table represents the positions of the centroids that I created randomly.…And you can see the distances from .1…to centroid one, centroid two and centroid three.…And a central part of the analysis is discovering which centroid is closest.…So in this case you can see, in the first row, that the distance to centroid two is…the smallest and that is the centroid that is identified in the final column.…And you can see that I have more details and information in the right half…of the worksheet, but we'll get to that as we create the workbook going along.…
- What is clustering?
- Setting up your Excel table
- Creating a list of centroids
- Identifying the closest centroid
- Updating centroids using averages
- Automating updates with macros
- Analyzing your data in Excel
- Visualizing data in a chart