The Excel LOGNORMDIST Function

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:
Relationship Between the Excel Lognormdist & Normsdist 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 :

LOGNORMDIST( x, mean, standard_dev )

Where the function arguments are:

x - The value at which you want to evaluate the log-normal distribution function
mean - The arithmetic mean of ln(x)
standard_dev - The standard deviation of ln(x)


Plot of Log-Normal Cumulative Distribution Function with Mean=10 and Standard Deviation=5
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:

=LOGNORMDIST( 12, 10, 5 )

This gives the result 0.066417115.


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


Lognormdist Function Errors

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

Common Errors
#NUM! - Occurs if the supplied x ≤ 0 or the supplied standard_dev ≤ 0
#VALUE! - Occurs if any of the supplied arguments are non-numeric
Return to the Excel Statistical Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014 ExcelFunctions.net