Hello,
I have a fairly basic question.
I've used the trial package of statisiXL for excel to run a cluster analysis on the following data:
9 elements (Na, Ca, etc..) were measured at 100 occasions, so 900 measurement points in total. All have a similar range.
Used settings: Quantitative data set; Euclidean distance; Nearest neighbour cluster method.
This gave a very nice hierarchical tree with two obvious clusters. It was obvious because you can 'see' two different clusters. But how do determine, statistically, the significance of a cluster/group? In other words; how do i determine a "critical distance"?
Could I use a simple statistical test? Including number of samples etc.?
My apologies if the question has already been answered on this forum, I couldn't find it.
Thank you in advance!
I have a fairly basic question.
I've used the trial package of statisiXL for excel to run a cluster analysis on the following data:
9 elements (Na, Ca, etc..) were measured at 100 occasions, so 900 measurement points in total. All have a similar range.
Used settings: Quantitative data set; Euclidean distance; Nearest neighbour cluster method.
This gave a very nice hierarchical tree with two obvious clusters. It was obvious because you can 'see' two different clusters. But how do determine, statistically, the significance of a cluster/group? In other words; how do i determine a "critical distance"?
Could I use a simple statistical test? Including number of samples etc.?
My apologies if the question has already been answered on this forum, I couldn't find it.
Thank you in advance!
Last edited:
