MM_CDF function

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

Written By Nikolas Ethoré (Super Administrator)

Updated at November 24th, 2021

Description

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

Syntax

=MM_CDF("DistName", X, Param1, [Param2], [Param3])
  • "DistName"
    String. Name of the desired distribution. 

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

  • Param1
    First parameter of the distribution. To check the definition of the parameters, see MM_PARAMNAME function. 

  • [Param2], [Param3] (optional/required depending on the chosen distribution)
    Other distribution parameters. 

Remarks

  • To check all supported distributions, see MM_DISTRIBUTIONSLIST function. 

  • Use MM_CDF_MS to evaluate the cumulative distribution function via mean and standard deviation.
    Use MM_CDF_TRUNC to evaluate the cumulative distribution function of a truncated distribution (with distribution parameters).
    Use MM_CDF_MS_TRUNC to evaluate the cumulative distribution function of a truncated distribution (with mean and standard deviation). 

  • See MM_PDF for probability density function.
    See MM_InvCDF for inverse cumulative distribution function.

Example 1: Normal distribution

Formula1: =MM_CDF("Normal",0.3,0,1)
Evaluates the cumulative distribution function of a normal distribution with mean 0 and standard deviation 1 at x equal to 0.3. Returns approximately 0.62.

Example 2: Continuous uniform distribution

Formula2: =MM_CDF("ContinuousUniform",4.5,-1,10)
Evaluates the cumulative distribution function of a continuous uniform distribution defined on [-1,10] at 4.5. Returns 0.5.