No results found

    We couldn’t find anything with that term. Please try again.

    Press Esc to close

    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().

    Example

    Copyright © 2024 - 2025 Structured Data LLC