Join Curt Frye for an in-depth discussion in this video Analyzing data in your Excel table, part of Up and Running with Excel Cluster Analysis.
- View Offline
…Cluster analysis helps you identify…potentially related items within a dataset.…For example, you might be able to identify customers that have…something in common or perhaps products that people tend to buy together.…In this movie, I will show you how to do some analysis based on the raw data,…so that you can use your domain knowledge…to get more insights into the clusters you create.…As my sample file, I'm using the analysis workbook.…And you can find that in the chapter three folder of your exercise files archive.…
This workbook contains a worksheet with a table that…contains different data than what we've worked with elsewhere.…That other data was meant to help you create…your cluster analysis workbook and be able to understand what…was going on, but in this case we're looking…at a little bit more realistic set of customer data.…This data set has a number of customer…records, indicating the customer's city, state, age, the date…of their first order, the amount of the…average order, and the cluster to which they belong.…
- 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