SimulationQuartiles
RiskAMP Simulation Analysis Functions
Using this function in Excel:
=SimulationQuartiles(Reference Cell)
Function arguments:
| Reference Cell | Cell to use as source |
Returns the minimum, 1st quartile, median, 3rd quartile, and maximum value of the reference cell during the simulation.
This function returns an array. You can enter it in a range of cells using Ctrl + Shift + Enter, or you can enter it into a single cell and use Excel’s spill function.