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
From the course: Learning Excel Cluster Analysis
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.