15:32:00
NORMSINV function and ways to use
Returns the inverse of the standard normal cumulative
distribution. The distribution has a mean of zero and a standard deviation of
one.
Important This
function has been replaced with one or more new functions that may provide
improved accuracy and whose names better reflect their usage. This function is
still available for compatibility with earlier versions of Excel. However, if
backward compatibility is not required, you should consider using the new
functions from now on, because they more accurately describe their
functionality.
Syntax
NORMSINV(probability)The NORMSINV function syntax has the
following argument (argument: A value that provides information to an action,
an event, a method, a property, a function, or a procedure.):
Probability
Required. A probability corresponding to the normal distribution.
Remarks
If probability is nonnumeric, NORMSINV returns the #VALUE!
error value.
If probability <= 0 or if probability >= 1, NORMSINV
returns the #NUM! error value.
Given a value for probability, NORMSINV seeks that value z
such that NORMSDIST(z) = probability. Thus, precision of NORMSINV depends on
precision of NORMSDIST. NORMSINV uses an iterative search technique. If the
search has not converged after 100 iterations, the function returns the #N/A
error value.
Example
