K-th Neighbour Cluster Analysis in Excel with UNISTAT

The UNISTAT statistics add-in extends Excel with K-th Neighbour Cluster Analysis capabilities.

For further information visit UNISTAT User's Guide section 8.1.2. K-th Neighbour Cluster Analysis.

Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.

K-th Neighbour Cluster Analysis

Variables Selected: Motiv, Qual, Grade, Compr
Kth Neighbour Cluster Analysis. Neighbour No: 2

History

Step	Combined1	Combined2	Cases	Distance
1	2	6	2	5.3367
2	2	5	3	5.6803
3	2	4	4	5.8208
4	2	3	5	6.1336
5	1	2	6	10.8896

Character Dendrogram

             2+------------------------------+                                  
             6+------------------------------+-+                                
             5+--------------------------------++                               
             4+---------------------------------+-+                             
             3+-----------------------------------+---------------------------+ 
             1+---------------------------------------------------------------+ 

Cluster Table

	Cases	Percentage	Within SSQ	Average Distance	Minimum	Maximum
Cluster 1	1	16.7%	0.0000	0.0000	0.0000	0.0000
Cluster 2	4	66.7%	53.7500	3.6533	3.1325	3.8487
Cluster 3	1	16.7%	0.0000	0.0000	0.0000	0.0000

Cluster Centroids

	Cluster 1	Cluster 2	Cluster 3	Overall
Motiv	14.0000	11.0000	8.0000	11.0000
Qual	19.0000	8.0000	10.0000	10.1667
Grade	19.0000	8.7500	14.0000	11.3333
Compr	18.0000	8.5000	8.0000	10.0000

Distance Between Centroids

	Cluster 1	Cluster 2	Cluster 3
Cluster 1	0.0000	18.0364	15.5563
Cluster 2	18.0364	0.0000	6.3885
Cluster 3	15.5563	6.3885	0.0000

Cluster Membership

Observation	Cluster
1	1
2	2
3	3
4	2
5	2
6	2