EXPONDIST

EXPONDIST(x, lambda, cumulative)

Returns the probability distribution function OR the cumulative probability function for an exponential distribution.

xThe value of the function.
lambdaThe parameter value.
cumulativeA logical value indicating the type of function to use:
False (or 0) = [[probability distribution function]] (equal to)
True (<> 0) = [[cumulative probability function]] (equal to or less than)

REMARKS
* EXPON.DIST was added in Excel 2010 to replace this function.
* The exponential distribution is a [[continuous distribution]]
* If "x" < 0, then #NUM! is returned.
* If "x" is not numeric, then #VALUE! is returned.
* If "lambda" = 0, then #NUM! is returned.
* If "lambda" is not numeric, then #VALUE! is returned.
* If "cumulative" = False, then the height of the curve at "x" is returned.
* If "cumulative" = True, then the area under the curve to the left of "x" is returned.
* For the Microsoft documentation refer to support.microsoft.com

 A
1=EXPONDIST(0.2, 10, TRUE) = 0.865
2=EXPONDIST(1, 4, 1) = 0.982
3=EXPONDIST(0.2, 10, FALSE) = 1.353
4=EXPONDIST(0.2, 0, FALSE) = #NUM!
5=EXPONDIST(5, "some text", FALSE) = #VALUE!


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top