Spread 8.0 Documentation
EXPONDIST
Support Options
Formula Reference > Built-In Functions > EXPONDIST

Glossary Item Box

EXPONDIST


Name

Exponent

Description

Returns the exponential distribution or the probability density.

Syntax

EXPONDIST(value,lamda,cumulative)

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::where x is the value argument, lambda is the lambda argument.

The probability density is calculated as follows:where x is the value argument, lambda is the lamda argument.

Data Type

Accepts numeric data, except the third argument, which accepts logical data. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

EXPONDIST(C12,10,TRUE)
EXPONDIST(R12C3,8,FALSE)
EXPONDIST(0.2,10,TRUE)=0.8646647168

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.