XL 2000 Correlation Matrix

[George Wilson]

How to do a correlation matrix in Excel for a large data
set? I can only find a correlation function scaler for two
vectors, but I want one for a whole matrix. Any
suggestions or helpful insight would be appreciated.
George

 

[Michael R Middleton]

George Wilson -

How to do a correlation matrix in Excel for a large data set? I can only

find a correlation function scaler for two vectors, but I want one for a
whole matrix. Any suggestions or helpful insight would be appreciated. <

Tools | Data Analysis | Correlation

The Correlation tool of the Analysis ToolPak will compute pairwise
correlation coefficients for multiple variables.

From my book "Data Analysis Using Microsoft Excel: Updated for Office XP":
If the Data Analysis command doesn't appear on the Tools menu, choose the
Add-Ins command from the Tools menu; in the Add-Ins Available list box,
check the box next to Analysis Tools. If Analysis Tools doesn't appear in
the Add-Ins Available list box, you may need to add the Analysis ToolPak
through a custom installation using the Microsoft Excel Setup program.

- Mike Middleton, www.usfca.edu/~middleton