Related Topics:
	Spreadsheet Mathematical Functions Function Wizard Functions

LOGNORMDIST

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