Applies to: @RISK, all releases

Using RiskSimtable() with Distributions as Arguements

 

Explanation
RiskSimtable() takes one argument: an array of values or cell references. To use distributions as arguments, place the distributions in a range of cells and reference that range in RiskSimtable(). You cannot put distribution functions directly inside curly braces.

Usage Methods

Method 1: Vary parameters of a single distribution

• Example: RiskBinomial(n, p) where p comes from a RiskSimtable() function.

• Put the possible values of p in a range, e.g., C88:C91.

• Reference that range in RiskSimtable(): RiskSimtable(C88:C91).

• Other formulas use the value of the distribution, not the RiskSimtable() itself.

Method 2: Vary the distribution function itself per simulation

• Place multiple distribution functions in a range of cells.

• Use RiskSimtable() with that range as its argument: RiskSimtable(D10:D12).

• Each simulation picks a different distribution from the table.

Important: In Method 2, all distributions show as precedents of any output that refers to RiskSimtable(). To avoid confusing tornado or sensitivity graphs, wrap the RiskSimtable() inside a RiskMakeInput(). This ensures only the active distribution per simulation is considered a precedent.

 

Attachments:
KB55_SimtableArguments.xlsx