LOGNORM.DIST

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.

Sample Usage

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)

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:

	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