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

Use NORMINV function skillfully to find the inverse function value

Picture and text skills
Case

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

Syntax
NORMINV(probability,mean,standard_dev)
Probability corresponds to the probability of the normal distribution.
Mean The arithmetic mean of the distribution.
Standard_dev The standard deviation of the distribution.

Description

￭ If any parameter is non-numeric, NORMINV returns the error value #VALUE!.

￭ if probability

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

￭ 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 precision of NORMINV depends on the precision of NORMDIST. NORMINV uses an iterative search technique. If the search is within 100 iterations

If there is no convergence, the function returns the error value #N/A.

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-NORMINV-han-shu-qiu-fan-han-shu-zhi.html