EXPON.DIST
Formulas / EXPON.DISTCalculate the exponential distribution.
EXPONDIST(x,lambda,cumulative)
- x - required argument that is the value of the function
- lambda - required argument that is the parameter value
- cumulative - required argument that indicates which form of the exponential function to use
Examples
=EXPONDIST( 0.5, 1, FALSE )The EXPON.DIST function is used to calculate the probability density function (PDF) for the exponential distribution. For example, the formula returns the probability density value of 0.60653066, which is the PDF of the exponential distribution with λ = 0.5 and x = 0.5.
=EXPONDIST( 0.5, 1, TRUE )The EXPON.DIST function can also be used to calculate the cumulative distribution function (CDF) for the exponential distribution. For example, the formula returns the cumulative distribution value of 0.39346934, which is the CDF of the exponential distribution with λ = 0.5 and x = 0.5.
Summary
The EXPON.DIST function returns the exponential distribution, allowing users to calculate the probability of a given event occurring.
- The EXPON.DIST function in Sourcetable can be used to model the time between events as it calculates an exponential distribution.
Need help with Formulas?
Frequently Asked Questions
What is the EXPON.DIST function?
What is the syntax of the EXPON.DIST function?
What parameters do I need to use the EXPON.DIST function?
What type of values do I need to use with the EXPON.DIST function?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.