:Use the NORMINV function to calculate the inverse function value-Table skills免费ppt模版下载-道格办公

Use the NORMINV function to calculate the inverse function value

```html
  • Picture and text skills
  • Case

Returns the inverse of the normal cumulative distribution function for the specified mean and standard deviation.

SyntaxNORMINV(probability,mean,standard_dev)

Probability corresponds to the probability of a normal distribution.

Mean The arithmetic mean of the distribution.

Standard_dev The standard deviation of the distribution.

If any argument is nonnumeric, NORMINV returns the #VALUE! error value.

If probability < 0 or probability > 1, NORMINV returns an error value.

If standard_dev ≤ 0, NORMINV returns the #NUM! error value.

If mean = 0 and standard_dev = 1, NORMINV uses the standard normal distribution (see function NORMSINV).

If a probability value is given, NORMINV solves for the value x using NORMDIST(x, mean, standard_dev, TRUE) = probability.

Therefore, the accuracy of NORMINV depends on the accuracy of NORMDIST. NORMINV uses an iterative search technique. If the search does not converge after 100 iterations, the function returns the #N/A 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/li-yong-NORMINV-han-shu-ji-suan-fan-han-shu-zhi.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
single-end

Related Suggestion