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.
The LOGNORM.DIST function syntax has the following arguments:
X Required. The value at which to evaluate the function.
Mean Required. The mean of ln(x).
Standard_dev Required. The standard deviation of ln(x).
Cumulative Required. A logical value that determines the form of the function. If cumulative is TRUE, LOGNORM.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.
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.
The equation for the lognormal cumulative distribution function is:
LOGNORM.DIST(x,µ,o) = NORM.S.DIST(1n(x)-µ / o)
In order to use the LOGNORM.DIST formula, start with your edited Excellentable
Then type in the LOGNORM.DIST formula in the area you would like to display the outcome:
By adding the values you would like to calculate the LOGNORM.DIST formula for, Excellentable will generate the outcome: