Export (0) Print
Expand All
Expand Minimize

WorksheetFunction.LogNorm_Inv Method (Excel)

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

Version Added: Excel 2010

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

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

    LOGNORM_INV_ZA10390997

Community Additions

ADD
Show:
© 2014 Microsoft