Documentation/Calc Functions/EXPONDIST

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

EXPONDIST

Category:

Statistical Analysis

Summary:

Returns a value of the probability density function or the cumulative distribution function for the exponential distribution.

Syntax:

EXPONDIST(Number; Lambda; C)

Returns:

Returns a real number which is the value of the probability density function or the cumulative distribution function for the exponential distribution.

Arguments:

Number is a real number or a reference to the cell containing that number which is the input value of the function.

Lambda is a real number or a reference to the cell containing that number which is the rate parameter of the exponential distribution.

C is a logical value that determines the form of the function. C = 0 or False to calculate the probability density function. It can be any other value or True to calculate the cumulative distribution function.

  • For all Number less than 0, the function returns 0 by definition, given valid values for Lambda.
  • If Lambda is less than or equal to 0, the function returns an error value.

Additional details:

  • The formula for the EXPONDIST is:

If Cumulative is FALSE(), EXPONDIST returns 0 for x < 0 and the probability density function value

Pexpdot.png

otherwise.

If Cumulative is TRUE(), EXPONDIST returns 0 if x < 0 and the cumulative distribution function value

Cexpdist.png

otherwise.

Here x is Number and λ is Lambda

  • For more details on exponential distribution, visit Wikipedia

Examples:

Formula Description Returns
=EXPONDIST(3;0.5;1) This formula calculates the cumulative distribution function for the exponential distribution with Number as 3 and Lambda as 0.5 0.7768698399
=EXPONDIST(3;0.5;0) This formula calculates the probability density function for the exponential distribution with Number as 3 and Lambda as 0.5 0.111565080074215
=EXPONDIST(-3;0.5;1) For Number values less than 0 the function returns 0 for valid values of Lambda 0
=EXPONDIST(1;-0.5;1) The function returns an error for Lambda values less than 0 Err:502

Related LibreOffice functions:

EXPON.DIST

ODF standard:

Section 6.18.21, part 2

Equivalent Excel functions:

EXPONDIST