Join Curt Frye for an in-depth discussion in this video Automating updates using macros, part of Learning Excel Cluster Analysis.
…So far I have shown you how to…work through centroid analysis as a manual process.…And even though you do need to enter some…formulas and other values into the main table here, it…can be a pain to copy values from the…centroid update area and put them into the centroids table.…And also to identify or create new random centroids so you can rerun your analysis.…In this movie, I will show you how to…use macros to automate those parts of the process.…As my sample file, I will use the use macros workbook, and you…can find that in the chapter two folder of your exercise files collection.…
So what I want to do is to automate…two tasks, generating random centroids to begin my analysis.…And then also updating by copying the values…from the centroid updates area to the centroids table.…So the first thing I'll do is delete the values, in cells I3, through J5, and that…throws off my calculations but we don't need to worry about that for the moment.…Now I'll click away from cell I3 because I want…the macro to capture that I am selecting that cell.…
- 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