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)
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).
Remarks:
All arguments must be numerical.
x and Standard_dev must be > 0.
The equation for the lognormal cumulative distribution function is:
Example:
LOGNORMDIST(4,3.5,1.2) = 0.039084
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.