The Define Correlations dialog has the following menus and buttons:
Edit — Enables you to copy the assumption list and chart in List view, copy the matrix in Matrix view, and print dialog contents
View — Switches between List and Matrix views, and enables you to display edited cells in bold type
Matrix — In Matrix view, specifies whether the matrix is a triangle in the upper right corner or the lower left, and enables you to remove the current matrix and all correlations among its assumptions
Help — Displays online help for the Define Correlations dialog
Add Assumptions — Displays the Choose Assumptions dialog, where you can select assumptions to correlate from the active workbook
Remove — Deletes the selected assumption from the current matrix and removes all correlations with it
Calculate — Enables you to calculate the correlation between two ranges of data
Note: | For information about the Link to spreadsheet checkbox in Matrix view, see Defining Correlations with a Linked Matrix. |