Manuals/calci/LOGINV
LOGINV (p, m, sd)
Where p is a lognormal distribution and m is the mean of ln(x), and sd is the standard deviation of ln(x).
It calculates the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard deviation. LOGINV (p...) = x, if p = LOGNORMDIST(x...).
· when argument is nonnumeric LOGINV displays error.
· LOGINV displays error when p is less than 0 or p is greater than 1.
· LOGINV displays error when sd <=0.
· The inverse of the lognormal distribution function is:
LOGINV
Lets see an example in (Column1 Row 1,Column2Row1, Column3Row1)
LOGINV (p, m,sd)
LOGINV (C1R1, C2R1,C3R1)
i.e. =LOGINV (0.05345, 2.5,1.3) is 1.4031
| Column1 | Column2 | Column3 | Column4 | |||
| Row1 | 0.05345 | 2.5 | 1.3 | |||
| Row2 | 1.403125 | 0 | ||||
| Row3 | ||||||
| Row4 | ||||||
| Row5 | ||||||
| Row6 |