Excel functions / Statistics
LOGNORM.INV function
The value below which a given share of a lognormal distribution falls.
Syntax
=LOGNORM.INV(probability, mean, standard_dev)
Arguments
probability: A probability, between 0 and 1.mean: The mean of ln(x).standard_dev: The standard deviation of ln(x).
When to use it
LOGNORM.INV gives the value below which a share of a lognormal distribution falls.
Examples
Undo LOGNORM.DIST
A B C D E 1 p Mean SD 2 0.039084 3.5 1.2 4.000 In E2:
=LOGNORM.INV(A2, B2, C2)→ 4.000
Common mistakes
- Parameters. The mean and SD are of ln(x).
LOGNORM.INV in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: LOGNORM.INV
- Danish: LOGNORM.INV
- Dutch: LOGNORM.INV
- Finnish: LOGNORM.KÄÄNT
- French: LOI.LOGNORMALE.INVERSE.N
- German: LOGNORM.INV
- Hungarian: LOGNORM.INVERZ
- Italian: INV.LOGNORM.N
- Norwegian: LOGNORM.INV
- Polish: ROZKŁ.LOG.ODWR
- Portuguese (Brazil): INV.LOGNORMAL
- Portuguese (Portugal): INV.NORMALLOG
- Russian: ЛОГНОРМ.ОБР
- Spanish: INV.LOGNORM
- Swedish: LOGNORM.INV
- Turkish: LOGNORM.TERS
Also written as LOGINV.
Try LOGNORM.INV in the playground
Related functions
- LOGNORM.DIST: The lognormal distribution, for values whose logarithm is normally distributed, such as prices and incomes.