# Documentation/Calc Functions/EXPONDIST

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.

• The formula for the EXPONDIST is:

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

otherwise.

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

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

EXPONDIST