Join Curt Frye for an in-depth discussion in this video Troubleshooting a cluster analysis workbook, part of Learning Excel Cluster Analysis.
…Cluster analysis is a powerful technique that you…can use to get great insights into your data.…However, the workbook that you built in this course does have…some idiosyncrasies and I want to show you how to handle them.…My sample file is the trouble shooting workbook and you can…find it in the chapter three folder of your exercise files collection.…This workbook is a macro enabled workbook.…But you might find that due to your company's information security policy…or just Excel settings that you are unable to run the macros.…
If that's the case I'll show you where to…look so that you can turn them on if possible.…To change Excel's macro security policy click the…File tab, and then click the Options item.…Doing so displays the Excel options dialog box.…Now, click trust center, over here in the categories pane.…And then click trust center settings button.…Doing so displays the trust center dialog box and click if necessary macro settings.…On this page you can select from four different macro settings.…
The one you should never select is enable all macros.…
- 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