Returns the cumulative distribution function of a truncated distribution evaluated at a specified value. Via distribution parameters.

Syntax

=MM_CDF_TRUNC("DistName", X, Param1, Param2, Param3, LowerBound, UpperBound)

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

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

• Param1, Param2, Param3
  Required. Parameters of the distribution. Even if the distribution has less than three parameters, all entries should be filled; the reason being that Mind does not accept empty parameters. To check the definition of the parameters, see MM_PARAMNAME function. 

• 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_CDF_MS_TRUNC to evaluate the cumulative distribution function of a truncated distribution with mean and standard deviation. 

Example 1: Truncated normal distribution

Formula1: =MM_CDF_TRUNC("Normal",1.2,0,2,0,-10,10)
Evaluates, at x equal to 1.2 the cumulative distribution function of a truncated normal distribution with interval (-10, 10] as support, 0 as first parameter and 2 as second parameter. The third parameter which is zero (chosen arbitrarily) is ignored since the normal distribution only requires two parameters. Returns approximately 0.73.

Example 2: Error example

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