Join Curt Frye for an in-depth discussion in this video Extending your analysis to more than two dimensions, part of Up and Running with Excel Cluster Analysis.
…So far in this course, I have shown you how to create…workbooks that let you perform cluster analysis on data in two dimensions.…That is, with an X-axis value and a Y-axis value.…However, it is likely that in your dataset, you will have more…than two variables that you want to look at in terms of clustering.…So in this movie, I will show you how…to extend your analysis to more than two dimensions.…My sample file is the extend workbook.…And you can find it in the chapter 3 folder of the exercise files collection.…
There are a fair number of changes that we need…to make, so I'll try to move through them fairly quickly.…The first is that you need to add a Z-axis value.…And you can add that column to your main table.…By right clicking the distance to centroide one column header and you'll…notice that when I move my mouse pointer into position, it changes from a greek…cross, a white cross to a downward pointing black arrow.…So, I'll right click.…
And then from the shortcut menu that appears, click Insert, or…rather, point to Insert, and then click Table Columns to the Left.…
- 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