RiskIndepC

Description

RiskIndepC(ID) designates an independent variable in a pair of correlated inputs.  The ID is the string used to identify the dependent variable it is being correlated with.  This string must be inside quotes.  This same ID must be used in the RiskDepC function for the dependent variable. The correlation coefficient is not specified here; it is specified in the corresponding RiskDepC function.

This is the “old” way to correlate two variables in @RISK, and it has been kept for backward compatibility. However, a better way is to use a correlation matrix (or a copula). See the Define Correlations section of this manual for more detailed information about correlations, correlation matrices, and copulas.

Examples

RiskNormal(10,10, RiskIndepC("Price")) identifies the Normal(10,10) distribution as the distribution of the independent variable “Price”.  There should be a corresponding RiskDepC function for the dependent variable in the pair.

Guidelines

ID must be the same string of characters used to identify the dependent variable in the RiskDepC function.  ID can be a reference to a cell that contains an identifier string.