Description

Returns the value of the simulation corresponding to the desired quantile.

Syntax

=MM_SIMQUANTILE(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_SIMQUANTILE is always equal to the cell's simulation value because only one simulation is displayed in Excel.

Example

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