Learning Excel Cluster Analysis

Learn how to perform cluster analysis using Excel.

Introduction

• Welcome
• What you should know before watching this course
• Using the exercise files

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

Conclusion

• Next steps