Returns the inverse cumulative distribution function or quantile function of a distribution evaluated at a specified value. Via mean and standard deviation.

Syntax

=MM_InvCDF_MS("DistName", X, Mean, [StdDev], [Param3])

• "DistName"
  String. Name of the desired distribution. 

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

• Mean
  Mean of the desired distribution. 

• StdDev (optional/required depending on the distribution)
  Standard deviation of the desired distribution. 

• Param3 (optional/required depending on the distribution)
  Third parameter of the distribution.

Remarks

• To check all supported distributions, see MM_DISTRIBUTIONSLIST function. 

• Use MM_InvCDF function to evaluate the inverse cumulative distribution function via distribution parameters.
  Use MM_InvCDF_TRUNC to evaluate the inverse cumulative distribution function of a truncated distribution (with distribution parameters).
  Use MM_InvCDF_MS_TRUNC to evaluate the inverse cumulative distribution function of a truncated distribution (with mean and standard deviation). 

• See MM_CDF for cumulative distribution function.

Example 1: Normal distribution

Formula1: =MM_InvCDF_MS("Normal",0.95,100,20)
Evaluates at 0.95 the inverse cumulative distribution function of a Normal distribution with a mean and standard deviation equal to 100 and 20, respectively. Returns approximately 132,90. 

Formula2: =MM_InvCDF_MS("Normal",0.95,100,20,42)
Evaluates at 0.95 the inverse cumulative distribution function of a Normal distribution with a mean and standard deviation equal to 100 and 20, respectively. Returns approximately 132.90. As this probability distribution has only two degrees of freedom, the Param3 parameter is ignored. 

Example 2: Gamma distribution

Formula3: =MM_InvCDF_MS("Gamma",0.75,4,2)
Evaluates, at x equal to 75%, the inverse cumulative distribution function of a Gamma distribution with mean and standard deviation equal to 4 and 2, respectively. Returns approximately 5.11.