O'Reilly logo

Decision Analytics: Microsoft® Excel® by Conrad Carlberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

9. Cluster Analysis: Further Issues

Chapter 8, “Cluster Analysis: The Basics,” covers some introductory aspects of cluster analysis and discusses two fundamentally different approaches: linkage or hierarchical methods, and centroid distances methods, particularly the popular k-means procedures. The focus in Chapter 8 is on the mechanics of each approach.

This chapter focuses exclusively on the k-means approach. An Excel workbook named Kmeans Cluster Analysis.xls accompanies this chapter, and it contains code that performs a k-means analysis on data that you supply. The first portion of this chapter walks you through the steps involved in using the workbook ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required