I didn't realize that the "Correlation tool" which is accessed thru the
Analysis Toolpack is any different from the Correl function in regular Excel.
The former does give my matrix.

"Mike Middleton" wrote:

bondjel -

The Correlation tool of the Analysis ToolPak (provided with all versions of
Excel) creates a table of all pairwise correlations.

That seems to be exactly what you want.

- Mike
http://www.MikeMiddleton.com



"bondjel" wrote in message
...
I have a numerical data set with 11 columns and 1809 rows. I would like to
simply obtain a table of correlations involving Col 1 with each remaining
Col (Col 2 thru Col 11), then Col 2 with each remaining Col (3 thru 11),
then
Col 4 with each remaining Col (5 thru 11), and so on until the last
correlation, i.e., Col 10 with Col 11.

.