SimulationMode
RiskAMP Simulation Analysis Functions
Using this function in Excel:
=SimulationMode(Reference Cell)
Function arguments:
| Reference Cell | Cell to use as source |
This function returns the mode (most likely) value of the reference cell during the simulation.
For discrete data, this function returns the true mode.
For continuous data, this function returns a synthetic mode derived by placing results into buckets (similar to creating a histogram).