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.