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

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

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

- Mike Middleton
Decision Analysis Add-ins for Excel

"Eric" <Eric@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
There are 26 column of data starting from A to Z for 100 rows. I would
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