The Specify Options panel of the Correlation Matrix tool sets two kinds of options, described in these sections:
This panel also has the following buttons:
Back — Returns you to the Select Assumptions panel.
Start — Creates the correlation matrix according to the options you specify.
The Location Of Matrix options indicate whether to create the correlation matrix on the active worksheet or on a new worksheet. Available options include:
Create A Temporary Correlation Matrix On A New Worksheet — Creates the matrix on a new worksheet. Use this option if you do not want to permanently alter the spreadsheet. After filling in the matrix, click Load The Matrix to enter the coefficients into the model. This is the default matrix location.
Create And Link To A Correlation Matrix On The Active Worksheet — Creates the matrix on the active worksheet and links it with cell references, so if you change the cells, the correlations update automatically. Select this option to embed the correlation matrix in the model. If you select this option, you must indicate where to put the matrix in the model using the Specify Upper Left Corner option.
Specify Upper Left Corner — Enables you to select the first (upper-left) cell for the matrix by either entering the cell reference in the field or clicking on the cell in the worksheet. This option is only available if you create the matrix on the active worksheet.
Format Matrix — Adds borders and headings, and changes column widths to make the correlation matrix more readable. This option is only available if you create the matrix on the active worksheet. This option is selected by default.
The Orientation options indicate whether to make the correlation matrix an upper triangular or a lower triangular matrix.
Upper Triangular Matrix — Creates the matrix with cells to fill in above the diagonal. This is the default.
Lower Triangular Matrix Creates the matrix with cells to fill in below the diagonal.