Navigation:  Formula Reference > Spreadsheet Formula Functions >

EXPONDIST

Previous pageReturn to chapter overviewNext page

 

This function returns the exponential distribution or the probability density.

Syntax

EXPONDIST(value,lambda,cumulative)

Arguments

This function has these arguments:

Argument

Description

value

Value of the function; must be positive or zero

lambda

Parameter value; must be greater than zero

cumulative

Logical value indicating whether to return the cumulative distribution; set to TRUE to return the cumulative distribution; set to FALSE to return the probability density

Remarks

Use this function to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use this function to determine the probability that the process takes at most one minute.

The cumulative distribution is calculated as follows:

Func-EXPONDIST-False

where x is the value argument, lambda is the lambda argument.

The probability density is calculated as follows:

Func-EXPONDIST-True

where x is the value argument, lambda is the lambda argument.

Data Types

Accepts numeric data, except the third argument, which accepts logical data. Returns numeric data.

Examples

EXPONDIST(C12,10,TRUE)

EXPONDIST(R12C3,8,FALSE)

EXPONDIST(0.2,10,TRUE) gives the result 0.8646647168

 

See Also

BINOMDIST