hutu5565 发表于 2010-10-27 12:13
怎样用excel 逆累积分布函数(inverse cdf function)求10,000个关于对数正态分布(LN distribution)的随机值(random value)????

----------------------

版主coral033：
Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev. If p = LOGNORMDIST(x,...) then LOGINV(p,...) = x.

Use the lognormal distribution to analyze logarithmically transformed data.
Syntax
LOGINV(probability,mean,standard_dev)
Probability   is a probability associated with the lognormal distribution.
Mean   is the mean of ln(x). Standard_dev   is the standard deviation of ln(x).