# LOGNORM.DIST

### [data-colorid=d8leom288c]{color:#2f2f2f} html[data-color-mode=dark] [data-colorid=d8leom288c]{color:#d0d0d0}Definition

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)

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.

### Remarks

• 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)

### By adding the values you would like to calculate the LOGNORM.DIST formula for, Excellentable will generate the outcome:

A
B
1
Data
Description
2
4
Value at which to evaluate the function (x)
3
3.5
Mean of ln(x)
4
1.2
Standard deviation of ln(x)
5
6
LOGNORM.DIST
0.039083556

JavaScript errors detected