From the course: Learning Excel Cluster Analysis

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Creating a list of random centroids

Creating a list of random centroids

From the course: Learning Excel Cluster Analysis

Start my 1-month free trial

Creating a list of random centroids

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…

Contents