T
TarrynG
Hi
I have a macro which runs the correlation matrix function found in the
Analysis Toolpack . . . however, the matrix that is generated does not
provide the 'duplicate'/mirrored correlation values. For example, the output
looks as follows;
A B C
A 1.0
B 0.5 1.0 0.2
C 0.6 0.2 1.0
rather than:
A B C
A 1.0 0.5 0.6
B 0.5 1.0 0.2
C 0.6 0.2 1.0
Is there any neat way that I can get the Toolpack function to return the
desired matrix?
Many thanks,
Tarryn
I have a macro which runs the correlation matrix function found in the
Analysis Toolpack . . . however, the matrix that is generated does not
provide the 'duplicate'/mirrored correlation values. For example, the output
looks as follows;
A B C
A 1.0
B 0.5 1.0 0.2
C 0.6 0.2 1.0
rather than:
A B C
A 1.0 0.5 0.6
B 0.5 1.0 0.2
C 0.6 0.2 1.0
Is there any neat way that I can get the Toolpack function to return the
desired matrix?
Many thanks,
Tarryn