RiskTarget, RiskXtoP, RiskTargetD, RiskXtoQ

Descripción

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

Ejemplos

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

Reglas

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

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