Join Curt Frye for an in-depth discussion in this video Next steps, part of Up and Running with Excel Cluster Analysis.
…Thanks again for spending time with me…in Up and Running with Excel Cluster Analysis.…I hope you've gotten a lot out of the course and learned…some techniques that you can use to analyze your data more effectively.…Before I go, I'd like to mention some resources that you can turn…to, to learn more both about…cluster analysis and other machine learning techniques.…The first book is called Data Smart, and…it's by John W Foreman, published by Wiley.…That book contains a description of…a slightly different cluster analysis method, as…well as many other ways to use your Excel spreadsheet to analyze data.…
Next, there is Decision Analytics by Conrad Carlberg that…contains many techniques as well,…including another cluster analysis algorithm.…And finally, there's another book by Carlberg called Predictive Analytics.…In that book, you'll learn how to perform…other types of machine learning and data analysis methods.…Once again, thank you for taking time with…this course, and best of luck with your data.…
- 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