How to create a correlation matrix in excel?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

There are 26 column of data starting from A to Z for 100 rows. I would like
to create a correlation matrix to show all combinations of 2 sets. Does
anyone have any suggestion on how to create a correlation matrix in excel?
Thanks in advance for any suggestions
Eric
 
Do you have any suggestions on how to define a set in a reasonable way?
My intention is to find any higher correlated area for analysis. I am fresh
in this area, could you please give me any suggestions on how it usually used
for analysis?
I look forward to your reply
Regards
Eric
 
Thank everyone very much for any suggestions and sharing.
Do you have any suggestions on Flexible Dynamic Correlation Model?
Do you have any working model?
I look forward to your reply
Best Regards
Eric
 
Eric -

The Correlation tool of Excel's Analysis ToolPak creates a matrix of
pairwise correlations.

Install the Analysis ToolPak that comes with Excel.

If you need assistance installing the Analysis ToolPak add-in, see Excel
Help.

Then, in Excel 2003, choose Tools | Data Analysis | Correlation.

In Excel 2007, choose Data | Analysis | Data Analysis | Correlation.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
 
Back
Top