WorksheetFunction.Norm_Inv Method (Excel)
Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
Version Information
Version Added: Excel 2010
Syntax
expression .Norm_Inv(Arg1, Arg2, Arg3)
expression A variable that represents a WorksheetFunction object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Arg1 |
Required |
Double |
Probability - A probability corresponding to the normal distribution. |
Arg2 |
Required |
Double |
Mean - The arithmetic mean of the distribution. |
Arg3 |
Required |
Double |
Standard_dev - The standard deviation of the distribution. |
Return Value
Double
Remarks
If any argument is non-numeric, NORM_INV returns the #VALUE! error value.
If probability <= 0 or if probability >= 1, NORM_INV returns the #NUM! error value.
If standard_dev ≤ 0, NORM_INV returns the #NUM! error value.
If mean = 0 and standard_dev = 1, NORM_INV uses the standard normal distribution (see NORM_S_INV).
Given a value for probability, NORM_INV seeks that value x such that NORM_DIST(x, mean, standard_dev, TRUE) = probability. Thus, precision of NORM_INV depends on precision of NORM_DIST.