Learn how to perform cluster analysis using Excel.
Overview
Syllabus
Introduction
- Welcome
- What you should know before watching this course
- Using the exercise files
- What is clustering?
- How do you identify clusters?
- What does cluster analysis look like in Excel?
- 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
- 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
- Next steps
Taught by
Curt Frye