SimulationInterval

RiskAMP Simulation Analysis Functions

This function returns the portion of simulation values in a reference cell, as a percentage, that fell between the Minimum and Maximum values.

If the Minimum value is omitted, the function will return all values less than or equal to Maxmum. Conversely if Maximum is omitted, the function will return all values greater than or equal to Minimum.

The function treats Minimum and Maximum as inclusive, meaning it will return all values >= Minimum, and all values <= `Maximum. Therefore when modeling discrete data, you may want to add a small epsilon value to avoid double-counting values. See the second example below.

The inverse of this function is SimulationPercentile, which returns a value from the simulation matching a given percentile.

Examples

This example shows how to use the function with one or two arguments:

If you leave the minimum value argument blank, the function will include all values up to and including the maximium. Similarly if you omit the maximum value, it will include all values above and including the minimum value.

This example shows how to use the SimulationInterval function with discrete data:

This example uses discrete values. In cell C5 we want to show the percentage of values that are above 50. We use the function =SimulationInterval(C2, 50.1).

We use the value 50.1 as the minimum so it excludes trials with the value exactly equal to 50.