| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
WorksheetFunction.LogNorm_Inv method (Excel) |
vbaxl10.chm137408 |
|
|
d8a3c416-c2c4-dc57-e1f0-1d05e9fec2a1 |
05/24/2019 |
medium |
Returns the inverse of the lognormal cumulative distribution function. Use the lognormal distribution to analyze logarithmically transformed data.
expression.LogNorm_Inv (Arg1, Arg2, Arg3)
expression A variable that represents a WorksheetFunction object.
| 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). |
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:
[!includeSupport and feedback]