Learn how to perform cluster analysis using Excel.
- [Voiceover] Hi, I'm Curt Frye. Welcome to Up and Running with Excel Cluster Analysis. In this quick course I'll show you how to use Excel to identify meaningful groups of data. I'll start by describing cluster analysis, which uses formulas to identify related data points and show you what one solution might look like in Excel. Next, I'll show you how to set up your data in an Excel table, create centroids that serve as the focus for each group of data, identify the closest centroid to each point, and update your data manually or by recording macros.
Finally, I'll show you how to make sense of your results by analyzing your data in an Excel table, creating an x-y scatter chart to visualize your data, and also to identify and solve any problems that might occur. I'm sure you'll find that your time with Up and Running with Excel Cluster Analysis will be time well-spent. Dive right in.
- 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