- Picture and text skills
- Case
Returns the inverse logarithmic cumulative distribution function of x, where ln(x) is the normal distribution with mean and standard-dev parameters.
If p=LOGNORMDIST(x,...), then LOGINV(p,...)=x. Use the log distribution to analyze log-transformed data.
Syntax
LOGINV(probability,mean,standard_dev)
Probability The probability associated with the logarithmic distribution.
Mean mean of ln(x).
Standard_dev The standard deviation of ln(x).
Description
If either argument is non-numeric, LOGINV returns #VALUE! Error value.
If probability <= 0 or probability >= 1, then LOGINV returns #NUM! Error value.
If standard_dev <= 0, LOGINV returns #NUM! Error value.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/qiao-yong-LOGINV-han-shu-qiu-fan-han-shu-zhi.html
支付宝扫一扫 
评论列表（196条）
测试