RiskPercentile, RiskPtoX, RiskPercentileD, RiskQtoX

Description

RiskPercentile(cellref or output/input name, percentile, Sim#) or RiskPtoX(cellref or output/input name, percentile, Sim#) returns the value of the entered percentile of 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

RiskPercentile(C10,0.99) returns the 99^th percentile of the simulated distribution for cell C10.

RiskPercentile(C10,A10) returns the percentile value from cell A10 of the simulated distribution for cell C10.

Guidelines

percentile must be between 0 and 1.

RiskPercentileD and RiskQtoX are similar, but they take a cumulative descending percentile value.

RiskPercentile and RiskPtoX are alternate names for the same function. Similarly for RiskPercentileD and RiskQtoX.