How to use the EXPONDIST function
Author: Oscar Cronquist Article last updated on November 15, 2022
The EXPONDIST function calculates the exponential distribution representing an outcome in the form of probability.
This function is in the compatibility category and has been replaced by the EXPON.DIST function which was introduced in Excel 2010.
Formula in cell C7:
=EXPONDIST(C3,C4,C5)
Excel Function Syntax
EXPONDIST(x,lambda,cumulative)
Arguments
x | Required. |
lambda | Required. |
cumulative | Required. A boolean value. TRUE - cumulative distribution function FALSE - probability density function |
Comments
The EXPONDIST function returns
- #VALUE! error value if lambda or x is non-numeric.
- #NUM! error value if:
- x < 0 (zero)
- lambda <= 0 (zero)
The general equation to calculate the cumulative distribution function:
The general equation to calculate the probability density distribution:
Functions in 'Compatibility' category
The EXPONDIST function function is one of many functions in the 'Compatibility' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form