Join Curt Frye for an in-depth discussion in this video Updating centroids using averages, part of Learning Excel Cluster Analysis.
…In the previous movie we used nested if…functions to identify the centroid closest to each point.…In this movie we will use those values from the…main table to update the centroids in our centroids tables.…My sample is the new average workbook and you can find…it in the chapter two folder of your exercise files archive.…If you're creating your own workbooks as you go along, you might have different…values in your centroids table, and therefore…different results here in the main table.…And the reason for that is that you might have generated different random values.…
So, if you did, don't worry about it, everything you see here will still work.…The first thing I'll do is identify where I want these centroid update values to go.…So, in cell L5, I will type a header, Centroid updates.…Press enter.…And I'll just click in cell L5 again and make that value bold.…And then, in cells K6 through K8, I'll type the numbers one, two, and three.…And those just reflect the numbers of the centroids that we're going to be updating.…
- 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