Example of a Distance Matrix
In this example, the data has distances between observations, so you use the Data is distance matrix option in the Hierarchical Cluster launch window. The correct data table structure for a distance matrix consists of the following:
• An identifier column (usually the first column) that has a Character data type.
• A set of n columns, where n is also the number of rows. These n columns define a symmetric matrix with zero or missing values on the diagonal.
1. Select Help > Sample Data Folder and open Flight Distances.jmp.
2. Select Analyze > Clustering > Hierarchical Cluster.
3. In the list next to Data Format, select Data is distance matrix.
4. Select Cities and click Label.
5. Select all remaining columns and click Y, Columns.
Figure 13.5 Completed Distance Matrix Launch Window
6. Click OK.
7. Click the Hierarchical Clustering red triangle and select Color Clusters.
Figure 13.6 Dendrogram Report for Flight Distances
In the Dendrogram report for the flight distances, the placement of the diamonds indicates that the model has grouped the cities into three clusters. The clusters are color-coded on the dendrogram. For more information about how to interpret the report, see Dendrogram.