- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Statistical - LOGNORM.DIST Function
Description
The LOGNORM.DIST function returns the lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. Use this function to analyze data that has been logarithmically transformed.
Syntax
LOGNORM.DIST(x,mean,standard_dev,cumulative)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
X | The value at which to evaluate the function. | Required |
Mean | The mean of ln(x). | Required |
Standard_dev | The standard deviation of ln(x). | Required |
Cumulative | A logical value that determines the form of the function. If cumulative is TRUE, LOGNORM.DIST returns the cumulative distribution function. If cumulative is FALSE, LOGNORM.DIST returns the probability density function. |
Required |
Notes
The equation for the lognormal cumulative distribution function is −
$$LOGNORM.DIST\left ( x,\mu ,o\right )=NORM.S.DIST\left (ln\left ( X \right )-\mu /o \right )$$
If any argument is nonnumeric, LOGNORM.DIST returns the #VALUE! error value.
If x ≤ 0 or if standard_dev ≤ 0, LOGNORM.DIST returns the #NUM! error value.
Applicability
Excel 2010, Excel 2013, Excel 2016