SimulationFrequency
RiskAMP Simulation Analysis Functions
Using this function in Excel:
=SimulationFrequency(Reference Cell)
Function arguments:
Reference Cell | Cell to use as source |
This function returns the observed frequency that a cell returned TRUE (or non-zero) during a simulation.
The function is intended to return the likelihood, during a simulation, that an event occurred.
For example, you might create a cell that returns TRUE
if a particular position exceeds a target return. You can use the SimulationFrequency
function to find the frequency that this occurs during the simulation.
You can use this function with any cell that returns TRUE or FALSE. You can
also use it with cells that return 0
or some other value; any non-zero value
will be counted as TRUE, while 0
will be counted as false.
You should not use this function with cells that returns strings, as these may not be interpreted consistently.
To find the exact number of trials that the event occurred, multiply the
result of this function by SimulationTrials()
.