LOGNORMDIST

Used only in ReliaSoft Workbooks

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