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 = [[probability distribution function]] (equal to)
True = [[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 or 0, then the height of the curve at "x" is returned.
* If "cumulative" = True or 1, 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!


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