EXPON.DIST

EXPON.DIST(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) = individual probability (equal to)
True (<> 0) = cumulative probability (equal to or less than)

REMARKS
* For an illustrated example refer to the page under Distributions
* 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.
* This function was added in Excel 2010 to replace the EXPONDIST function.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1??


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