Manuals/calci/LOGNORMDIST
LOGNORMDIST(n,m, sd)
Where n is the value for which the function is evaluated and m is the mean of ln(x).
sd is the standard deviation of ln(x).
It calculates the cumulative lognormal distribution of x, where ln(x) is distributed with parameters as mean and standard deviation.
· When arguments are nonnumeric ,LOGNORMDIST shows error.
· LOGNORMDIST displays 0, when n ≤ 0 or sd ≤ 0.
· The equation for the lognormal cumulative distribution function is:
LOGNORMDIST
Lets see an example in (Column1 Row 1,Column2Row1, Column3Row1)
LOGNORMDIST (n, m,sd)
LOGNORMDIST (C1R1, C2R1,C3R1)
i.e. =LOGNORMDIST (5, 4.5, 2.2) is 0.09472
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |||
| Row1 | 5 | 4.5 | 2.2 | |||
| Row2 | 0.094718 | 0 | ||||
| Row3 | ||||||
| Row4 | ||||||
| Row5 | ||||||
| Row6 |