Description

Returns the index of the simulation corresponding to the desired percentile. 

Syntax

=MM_SIMINDEXQUANTILE(Value, Quantile)

• Value
  Cell in which simulations are generated (with functions such as RANDOM, MM_SIMULATE_MS, and so on.).

• Quantile
  The value at which the cumulative distribution function is evaluated.

Remarks

Note that in Excel, the default value returned by MM_SIMINDEXQUANTILE is always 1 because only one simulation is displayed in Excel.

Example

For example, in this case, the cell C8 returns the simulation index corresponding to the quantile 0.1 for the variable #2.
The cell C19 retrieves the corresponding value using the function MM_RESULT.

Note that you can now use the function MM_SIMQUANTILE instead of the MM_RESULT.