SimulationPercentile
RiskAMP Simulation Analysis Functions
Using this function in Excel:
=SimulationPercentile(Reference Cell, Percentile)
Function arguments:
| Reference Cell | Cell to use as source |
| Percentile | Target percentile |
This function returns the value of the reference cell corresponding to the given percentile over all iterations of the simulation. For this purpose cell values are sorted in ascending order.
A percentile value of 50% will return the median of the Reference Cell; 0% will return the minimum value of the Reference Cell; and 100% will return the maximum value of the Reference Cell.
This function is used to test the expected value of a function corresponding to various probabilities.
This function can be used as the inverse of the SimulationInterval function.