Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Correlation Matrix | Excel Worksheet Functions | |||
Matrix Problem | Excel Discussion (Misc queries) | |||
CORRELATION / COVARIANCE MATRIX | Excel Worksheet Functions | |||
In Regression Analysis, How do you get a Correlation Matrix to be. | Excel Discussion (Misc queries) | |||
Correlation matrix | Excel Worksheet Functions |