Syntax
=EXPON.DIST(x, lambda, cumulative)Arguments
| Argument | Required | Description |
|---|---|---|
x | Required | The value (0 or more) |
lambda | Required | The rate (positive) |
cumulative | Required | TRUE for the cumulative distribution, FALSE for the density |
How to use EXPON.DIST
EXPON.DIST takes 3 required arguments. Type =EXPON.DIST( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=EXPON.DIST(0.2, 10, TRUE)Result =EXPON.DIST(0.2, 10, FALSE)Result Related statistical functions
- COUNTIFSCounts the cells that meet all of several conditions.
- COVARIANCE.PReturns the population covariance of two sets of numbers.
- COVARIANCE.SReturns the sample covariance of two sets of numbers.
- DEVSQReturns the sum of squared deviations of the numbers from their mean.
- F.DISTReturns the left tailed F probability distribution.
- F.DIST.RTReturns the right tailed F probability distribution.
- F.INVReturns the inverse of the left tailed F distribution.
- F.INV.RTReturns the inverse of the right tailed F distribution.
- F.TESTReturns the two tailed probability of an F test that two samples have the same variance.