Join Curt Frye for an in-depth discussion in this video Setting up your Excel table, part of Up and Running with Excel Cluster Analysis.
…To start building your Excel cluster analysis…workbook you need to create a table…that will hold the data and also distances that are important to the technique.…In this movie I will walk you through the first elements of the setup…and we can use what we create here to build on in later movies.…As my sample file, I will use firsttable.xlsx.…It's an Excel workbook, and you can find it…in the chapter two folder of your exercise files archive.…Yes, it is a blank workbook.…I just wanted to start out with a blank slate…so that we can build right from the ground up.…
To build our table to hold the data, go ahead and click cell A2.…And then in that cell, we'll type in our first column name.…And that is X, capital X, underscore, Axis, A-X-I-S.…Then, I'll press tab to move to cell B2, and this column will be named Y_Axis.…So I have the name Y_Axis.…That way I don't have two capital letters right next to each other.…That's why I put an underscore between the Y and the A.…I'll press Tab.…
Now in cell C2 I'm going to type in the first of my three distance column headers.…
- 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