Excel_correlation_matrix
Hi to everybody. I'm beginner in excel.
I want to create correlation matrix in excel. Without using Data Analysis Toolpack or macro.
I search in the internet and find function about creating correlation matrix.
here is function
=CORREL(INDIRECT("'data'!" & B$1 &2& ":" & B$1 &100), INDIRECT("'data'!" & $A2 &2& ":" & $A2 &100))
But i can't implement this function.
Please help me. If it is possible attach a little sample in excel worksheet or send it to my mail.
Thanks in advance.
|