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

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

  1. Below 4, when ln(x) has mean 3.5 and SD 1.2

    ABCDE
    1xMeanSD
    243.51.20.0391

    In E2: =LOGNORM.DIST(A2, B2, C2, TRUE) → 0.0391

    Try this example

Common mistakes

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.

Translate a whole formula

Try LOGNORM.DIST in the playground

Related functions