the Statistics Add-In for Microsoft® Excel

Cluster Analysis

First, an agglomeration is performed using one of the following distance methods:

  • single linkage (nearest neighbor)
  • complete linkage (farthest neighbor)
  • average linkage
  • centroid method
  • Ward's method

The calculation is displayed as a table and as a dendogram:

Afterwards, you can define a separating variable to divide all data points into the desired number of clusters.