The Excel LOGNORMDIST Function

Home » Excel-Built-In-Functions » Excel-Statistical-Functions » Excel-Lognormdist-Function Search this site: Custom Search

Related Functions:  LOGINV NORMDIST

Log-Normal Distribution

A variable, x is Log-Normally Distributed if its natural logarithm is normally distributed.

Or, in terms of Excel functions:

where μ is the mean of ln(x) and σ is the standard deviation of ln(x).

LOGNORMDIST & LOGNORM.DIST Functions

In Excel 2010, the LOGNORMDIST function has been replaced by the LOGNORM.DIST function.

The new Lognorm.Dist function in Excel 2010 has been improved, in that it can calculate the both the probability density function and the cumulative distribution function, whereas the Lognormdist function only calculates the cumulative distribution function.

Although it has been replaced, the Lognormdist function is still available in Excel 2010 (stored in the list of compatibility functions), to allow compatibility with earlier versions of Excel.

Basic Description

The Excel LOGNORMDIST function calculates the Cumulative Log-Normal Distribution Function at a supplied value of x.

The format of the function is :

Where the function arguments are:

Log-Normal Cum. Distrib. with mean ln(x) = 10 & std. dev. ln(x) = 5

Lognormdist Function Example

The chart on the right shows the the Log-Normal Cumulative Distribution Function for a variable, x. The mean of ln(x) is 10 and the standard deviation of ln(x) is 5.

If you want to calculate the value of this function at x = 12, this can be done using the Excel Lognormdist function, as follows:

This gives the result 0.066417115.

Further information and examples of the Excel Lognormdist function can be found on the Microsoft Office website.

Trouble Shooting

If you get an error from the Excel Lognormdist function this is likely to be one of the following: