Related Topics: | ||
Description: Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with a specified mean and standard deviation. Use this function to analyze data that has been logarithmically transformed.
Syntax: lognormdist(x, Mean, Standard_dev, Cumulative)
x is the value at which to evaluate the function.
Mean is the mean of ln(x).
Standard_dev is the standard deviation of ln(x).
Cumulative is a logical value that indicates which form of the exponential function to provide. If Cumulative is TRUE, lognormdist returns the cumulative distribution function; if FALSE, it returns the probability density function.
Remarks:
Arguments must be numerical.
x and Standard_dev must be > 0.
The equation for the lognormal cumulative distribution function is:
The equation for the probability density function is:
All parameter values can include:
Numerical values
Standard operands (+, -, *, /)
Predefined mathematical functions (exp, log, sin, etc.)
References to any analysis workbooks
Example:
lognormdist(4,3.5,1.2,TRUE)
Returns:
0.039084
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.