SimulationMode
RiskAMP Simulation Analysis Functions
Using this function in Excel:
=SimulationMode(Reference Cell, Assume Discrete)
Function arguments:
| Reference Cell | Cell to use as source |
| Assume Discrete | Force the function to assume data is discrete or continuous |
This function returns the mode of the reference cell during the simulation.
For discrete data, the function returns the most likely value based on frequency.
For continuous data, it uses a histogram and banded search to find the peak of the data distribution.
This function uses heuristics to determine if your data is continuous or discrete.
In some cases it may make an incorrect assumption. You can force the function to
use a particular method with the Assume Discrete parameter.
Set this parameter to TRUE to assume the data is discrete and return the
most frequently observed value. Set the parameter to FALSE to assume the
data is continuous and use the banded search. Leave the parameter blank to use the standard heuristics.