RiskTarget, RiskXtoP, RiskTargetD, RiskXtoQ

Description

RiskTarget(cellref or output/input name, targetValue, Sim#) or RiskXtoP(cellref or output/input name, targetValue, Sim#) returns the cumulative probability for targetValue in the simulated distribution for cellref. You can use the RiskTruncate property function to optionally restrict the range of the simulated distribution for calculating the statistic.

Examples

RiskTarget(C10,1000) returns the cumulative probability of the value 1000 using the simulated distribution for cell C10.

Guidelines

RiskTargetD and RiskXtoQ are similar, but they return a cumulative descending probability

RiskTarget and RiskXtoP are simply alternate names for the same function. Similarly for RiskTargetD and RiskXtoQ.