How do I get Excel to calculate a correlation matrix (i.e., correlations among several variables)?
If you want an entire correlation matrix, you’ll need to use the Analysis ToolPak. First, make sure the Analysis ToolPak has been installed (see above). To generate a correlation matrix, select Data Analysis from the Tools menu and choose the Correlation procedure. A dialog box will open that will allow you to select the range of your data. (Note that you need to select one continuous range; you can’t select a series of unconnected columns.) Indicate whether your variables are in columns or rows (it will almost always be columns). If you include the names of your variables in the selected range, make sure you check the Labels in First Row box.
