EXPONDIST(x, lambda, cumulative)

Returns the exponential distribution.

xThe value of the function.
lambdaThe parameter value.
cumulativeThe type of function to use
True = cumulative probability function
False = probability mass function

Remarks

* EXPON.DIST was added in Excel 2010 to replace this function.
* If "x" < 0, then #NUM! is returned.
* If "x" is not numeric, then #VALUE! is returned.
* The exponential distribution is ?? Distribution.
* If "lambda" = 0, then #NUM! is returned.
* If "lambda" is not numeric, then #VALUE! is returned.
* If "cumulative" = True, then the cumulative distribution function is used.
* If "cumulative" = False, then the probability density function is used.
* For the Microsoft documentation refer to support.office.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!


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