Data Analysis with Microsoft Excel: Updated for Office 2007

340 Statistical Methods

Now let’s create a matrix of the correlations for all of the variables in the

workbook.

To create a correlation matrix of the numeric variables:

1 Click Multivariate Analysis from the StatPlus menu and then click

Correlation Matrix.

2 Click the Data Values button and select all of the variables in the

workbook except the Gender variable.

3 Click the Output button and send the output to a new worksheet

named Corr Matrix. Click the OK button. Figure 8-23 shows the

completed dialog box.

Figure 8-22

Calculus

workbook