Excel functions / Statistics
LOGNORM.DIST function
The lognormal distribution, for values whose logarithm is normally distributed, such as prices and incomes.
Syntax
=LOGNORM.DIST(x, mean, standard_dev, cumulative)
Arguments
x: The value, greater than 0.mean: The mean of ln(x).standard_dev: The standard deviation of ln(x).cumulative: TRUE for the chance of x or less; FALSE for the height of the curve at x.
When to use it
LOGNORM.DIST works with the lognormal distribution, for values whose logarithm is normally distributed: prices, incomes, file sizes. Give the mean and standard deviation of ln(x).
Examples
Below 4, when ln(x) has mean 3.5 and SD 1.2
A B C D E 1 x Mean SD 2 4 3.5 1.2 0.0391 In E2:
=LOGNORM.DIST(A2, B2, C2, TRUE)→ 0.0391
Common mistakes
- Mean of x or of ln(x). The mean and standard deviation are those of ln(x), not of x.
LOGNORM.DIST 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.DIST
- Danish: LOGNORM.FORDELING
- Dutch: LOGNORM.VERD
- Finnish: LOGNORM_JAKAUMA
- French: LOI.LOGNORMALE.N
- German: LOGNORM.VERT
- Hungarian: LOGNORM.ELOSZLÁS
- Italian: DISTRIB.LOGNORM.N
- Norwegian: LOGNORM.FORDELING
- Polish: ROZKŁ.LOG
- Portuguese (Brazil): DIST.LOGNORMAL.N
- Portuguese (Portugal): DIST.NORMLOG
- Russian: ЛОГНОРМ.РАСП
- Spanish: DISTR.LOGNORM
- Swedish: LOGNORM.FÖRD
- Turkish: LOGNORM.DAĞ
Try LOGNORM.DIST in the playground
Related functions
- LOGNORM.INV: The value below which a given share of a lognormal distribution falls.
- NORM.DIST: The normal distribution: the chance of a value at or below x, or the height of the bell curve at x.
- LN: Natural logarithm.