Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
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 to 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 XY 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.
There are currently no FAQs about Up and Running with Excel Cluster Analysis.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.