MM_PDF_TRUNC function

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

Written By Nikolas Ethoré (Super Administrator)

Updated at November 24th, 2021

Description

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

Syntax

=MM_PDF_TRUNC("DistName", X, Param1, Param2, Param3, LowerBound, UpperBound)
  • "DistName"
    String. Name of the desired distribution. 

  • X
    The value at which the truncated probability density 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_PDF_MS_TRUNC to evaluate the probability density function of a truncated distribution (with mean and standard deviation). 

Example 1: Truncated normal distribution

Formula1: =MM_PDF_TRUNC("Normal",1.2,0,2,0,-10,10)
Evaluates, at x equal to 1.2 the probability density 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.17.

Example 2: Error example

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