Re: How to create a correlation matrix in excel?



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



"Eric" <Eric@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:797AA745-E8B3-4E63-8929-3174B987B766@xxxxxxxxxxxxxxxx
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


.