LOGNORM.INV

Description

Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. If p = LOGNORM.DIST(x,...) then LOGNORM.INV(p,...) = x.

Use the lognormal distribution to analyze logarithmically transformed data.

Sample Usage

Syntax

LOGNORM.INV(probability, mean, standard_dev)

The LOGNORM.INV function syntax has the following arguments:

• Probability    Required. A probability associated with the lognormal distribution.

• Mean    Required. The mean of ln(x).

• Standard_dev    Required. The standard deviation of ln(x).

Remarks

• If any argument is nonnumeric, LOGNORM.INV returns the #VALUE! error value.

• If probability <= 0 or probability >= 1, LOGNORM.INV returns the #NUM! error value.

• If standard_dev <= 0, LOGNORM.INV returns the #NUM! error value.

In order to use the LOGNORM.INV formula, start with your edited Excellentable

Then type in the LOGNORM.INV formula in the area you would like to display the outcome:

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