Share Description
In this course, you will :
- Learn how to identify clusters of data points using Excel's built-in data management and computation functions—with little or no VBA!
- shows you how to create a worksheet for cluster analysis, write formulas to find the closest focal point (centroid) for each row, and analyse your results in an Excel table or XY scatter chart.
- Members who are comfortable recording macros or writing VBA code can learn how to automate parts of the procedure.
Syllabus :
1. Introducing Cluster Analysis
- What is clustering?
- How do you identify clusters?
- What does cluster analysis look like in Excel?
2. Building a Cluster Analysis Worksheet
- Setting up your Excel table
- Creating a list of random centroids
- Calculating the distance to a centroid
- Identifying each row's closest centroid
- Updating centroids using averages
- Automating updates using macros
- Running macros using command buttons
3. Analyzing and Visualizing Cluster Data
- Analyzing data in your Excel table
- Visualizing table data in a chart
- Extending your analysis to more than two dimensions
- Troubleshooting a cluster analysis workbook
