:Use the LOGINV function skillfully to find the inverse function value-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Use the LOGINV function skillfully to find the inverse function value

Use the LOGINV function skillfully to find the inverse function value

Author: daogeziyuan • • Table skills • Views 878
  • 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 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

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

Related Suggestion