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

Syntax

=MM_InvCDF_MS_TRUNC("DistName", X, Mean, StdDev, Param3, LowerBound, UpperBound)

• "DistName"
  String. Name of the distribution you want to simulate. 

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

• Mean
  Required. Mean of the initial distribution. 

• StdDev
  Required. Standard deviation of the initial distribution. 

• Param3
  Required. Third parameter of the distribution.

Even if the distribution does not require StdDev and/or Param3, all entries should be filled; the reason being that Mind does not accept empty parameters.

• LowerBound
  Lower bound of the truncated distribution. Restricts the domain of the distribution on the left side. Input empty string ("") for negative infinity.

• UpperBound
  Upper bound of the truncated distribution. Restricts the domain of the distribution on the right side. Input empty string ("") for positive infinity.

Remarks

• To check all supported distributions, see MM_DISTRIBUTIONSLIST function. 

• Use MM_InvCDF_TRUNC to evaluate the inverse cumulative distribution function of a truncated distribution with distribution parameters. 

• See MM_CDF_MS_TRUNC for the cumulative distribution function of a truncated distribution (defined with mean and standard deviation). 

Example 1: Truncated normal distribution

Formula1: =MM_InvCDF_MS_TRUNC("Normal",0.95,0,2,0,-10,10)
Evaluates, at x equal to 95% the inverse cumulative distribution function of a truncated normal distribution with interval (-10, 10] as support, 0 as mean and 2 as standard deviation. The third parameter which is zero (chosen arbitrarily) is ignored since the normal distribution has only two degrees of freedom. Returns approximately 3.29.

Example 2: Error example

Formula2: =MM_InvCDF_MS_TRUNC("Normal",0.95,0,2,,-10,10)
Returns an error as Mind does not recognize empty parameters.