WorksheetFunction.LogNorm_Inv Method (Excel)

Returns the inverse of the lognormal cumulative distribution function. Use the lognormal distribution to analyze logarithmically transformed data.

Version Information

Version Added: Excel 2010

Syntax

expression .LogNorm_Inv(Arg1, Arg2, Arg3)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Double

Probability - A probability associated with the lognormal distribution.

Arg2

Required

Double

Mean - The mean of ln(x).

Arg3

Required

Double

Standard_dev - The standard deviation of ln(x).

Return Value

Double

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.

  • The inverse of the lognormal distribution function is:

    Ff839685.LOGNORM_INV_ZA10390997(en-us,office.14).jpg

See Also

Concepts

WorksheetFunction Object

WorksheetFunction Object Members