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