Skip to main content

LOGNORMDIST Function

The LOGNORMDIST function is one of the statistical functions. It is used to analyze logarithmically transformed data and return the lognormal cumulative distribution function of the given x value with the specified parameters.

Syntax​

LOGNORMDIST(x, mean, standard_dev)

The LOGNORMDIST function has the following arguments:

ArgumentDescription
xThe value at which the function should be calculated. A numeric value greater than 0.
meanThe mean of ln(x), a numeric value.
standard_devThe standard deviation of ln(x), a numeric value greater than 0.

Notes​

How to apply the LOGNORMDIST function.

Examples​

The figure below displays the result returned by the LOGNORMDIST function.

LOGNORMDIST Function