MATRIXCORREL
Category: User Defined Function.
Description: Returns the cophenetic coefficient of correlation (Pearson) between two matrices of the same size.
Note: Diagonal values are not accounted.
Syntax: MATRIXCORREL(range, range, [section of matrix to use])
Section of matrix to use: Optional. Possible parameters:
-
BOTH, will use the average between the upper and lower sections of the matrix for the calculation of the correlation coeficient
-
UPPER, only the upper section will be used (above the diagonal)
-
LOWER (default value), only the lower section will be used (below the diagonal)