Define Repeated Correlation

When multiple sets of related inputs should be correlated using the same correlation matrix (e.g. a set of multiple inputs that are created to span several years), the Define Repeated Correlation command can be used to create a single correlation matrix and apply it to multiple instances at the same time.

To define a repeated correlation, click the lower half of the Correlation button and select 'Define Repeated Correlation' or select the Edit Correlation command button at the bottom of the Define Correlations window and select 'Instances > Define Repeated Correlation'.

Figure 1 - Define Repeated Correlation

When the Define Repeated Correlation command is selected the Define Repeated Correlation window (Figure 1, right) will open. There are two sections to the window:

  • Inputs - Identify the range of correlated inputs and how they are organized (by rows or columns).
  • Instance Names - Designate how instances of a repeated correlation will be named (consecutive numbers or values from a range of cells).

To create a correlation with multiple instances, select the range of cells that include all inputs to be correlated, and then select how the input cells are organized:

  • Every Row - Input distributions are organized by rows; a correlation matrix will be created with the number of inputs matching the number of columns in the range, and instances will be created using the row of inputs.
  • Every Column - Input distributions are organized by columns; a correlation matrix will be create with the number of inputs matching the number of rows in the range, and instances will be created using the column of inputs.

Once inputs and instances have been specified, the Define Correlation window will open. See Define Correlation Window for more information.