Menu
EXCEL LOGNORMDIST FUNCTION
Excel LOGNORMDIST Function Introduction
The LOGNORMDIST function in Excel computes the Cumulative Log-Normal Distribution Function for a given x value.
Description of Excel LOGNORMDIST Function
Syntax :
=LOGNORMDIST( x, mean, standard_dev )
Parameters :
- The following parameter are:
x –
- The value at which the log-normal dispersion should be evaluated.
mean –
- ln’s mean is the average (x).
standard dev
–
- The ln standard deviation (x).
Step By Step Guide of LOGNORMDIST Function
Example :
The graph on the right depicts the Log-Normal Cumulative Distribution Function for a variable called x. ln(x) has a mean of 10 and a standard deviation of 5.
If you wish to determine the value of this function when x = 12, use the Excel Lognormdist function, as shown below:
=LOGNORMDIST( 12, 10, 5 )
This gives the result 0.066417115.
Key Points
- #NUM! – Occurs if the provided x or standard dev are both 0.
- #VALUE! – This error occurs if any of the supplied parameters is n.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
