:"Master the LOGINV function: Easily calculate inverse function values"-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. "Master the LOGINV function: Easily calculate inverse function values"

"Master the LOGINV function: Easily calculate inverse function values"

Author: daogeziyuan • • Table skills • Views 864
```html
  • 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)

LOGINV1.png

Probability The probability associated with the logarithmic distribution. Mean ln(x) average. Standard_dev The standard deviation of ln(x).

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/zhang-wo-LOGINV-han-shu-qing-song-ji-suan-fan-han-shu-zhi.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu 哆啦梦 Columnist
48 196
single-end

Related Suggestion