WorksheetFunction.LogInv Method

  • Article
Excel Developer Reference

Use the lognormal distribution to analyze logarithmically transformed data.

Syntax

expression.LogInv(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, LOGINV returns the #VALUE! error value.

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

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

  • The inverse of the lognormal distribution function is:

    Equation

See Also