Cell Selection Rules for Smart Selection

Your current cell selection controls the assumptions that are displayed in the Define Correlations dialog when you open it:

Advanced Tips

  To automatically define a new linked matrix using adjacent assumptions:

  1. Create assumptions or assumption names next to a square matrix of correlations.

  2. Select the upper left cell of the matrix, or the entire matrix range.

  3. Click Define Correlations.

A new linked matrix containing the adjacent assumptions opens in the Define Correlations dialog.

  To automatically create a new linked matrix using nonadjacent or adjacent assumptions:

  1. Use Ctrl+click to select a group of uncorrelated assumption cells and a square range containing a matrix of correlations to link.

  2. Click Define Correlations.

A new linked matrix containing the selected assumptions opens in the Define Correlations dialog.