# Documentation/Calc Functions/EXPONDIST

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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

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 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

EXPONDIST