Learning Excel Cluster Analysis

Author

Released

5/28/2014

Learn how to use Excel's built-in data management and computation functions to identify clusters of data points—with little or no VBA! Author Curt Frye shows you how to set up a worksheet for cluster analysis, create formulas that identify the closest focal point (centroid) for each row, and analyze your results in an Excel table or XY scatter chart. Members who don't mind recording macros or writing VBA code can learn how to automate some parts of the procedure.

Topics include:

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

Skill Level Advanced

1h 9m

Duration

60,176

Views

Show MoreShow Less

- [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 Excelto identify meaningful groups of data.I'll start by describing cluster analysis,which uses formulas to identify related data pointsand show you what one solution might look like in Excel.Next, I'll show you how to set upyour data in an Excel table,create centroids that serve as the focusfor 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 resultsby analyzing your data in an Excel table,creating an x-y scatter chart to visualize your data,and also to identify and solveany problems that might occur.I'm sure you'll find that your time withUp and Running with Excel Cluster Analysiswill be time well-spent.Dive right in.