Join Curt Frye for an in-depth discussion in this video Creating a list of random centroids, part of Learning Excel Cluster Analysis.
…Now that we've created an Excel table to…hold the data in calculations required to perform…a cluster analysis, we can start filling in…the rest of the data and formulas we need.…Our goal for this movie, is to create a set…of random centroids Excel can use to analyze the data.…My sample file is the centroid list Excel workbook.…And you can find it in the chapter two folder of the exercise files archive.…This is the main table that I created in…the previous movie and it also contains x and…y pairs for 15 different points that will occur…within the body of chart that we'll create later.…
What we need to do now is create a table that lists the centroids.…To do that click in cell H2 and then type C underscore number, this…is a column header for the centroid table we're about to create.…So we have C number, which represents the centroid number.…Press tab to move to I2, and here we'll have C underscore field 1.…So that's centroid field 1, and then C underscore field 2.…
Now in cells H3 through H5 I'll enter the numbers 1, 2, 3.…
- 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