WorksheetFunction.LogInv Method
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:
