WorksheetFunction.Norm_S_Inv(Double) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of 0 (zero) and a standard deviation of one.
public:
double Norm_S_Inv(double Arg1);public double Norm_S_Inv (double Arg1);Public Function Norm_S_Inv (Arg1 As Double) As DoubleParameters
- Arg1
- Double
Probability - A probability corresponding to the normal distribution.
Returns
Remarks
If probability is non-numeric, Norm_S_Inv returns the #VALUE! error value.
If probability < 0 or if probability > 1, Norm_S_Inv returns the #NUM! error value.
Given a value for probability, Norm_S_Inv seeks that value z such that NORM_S_DIST(z) = probability. Thus, precision of Norm_S_Invdepends on precision of Norm_S_Dist(Double, Boolean). Norm_S_Inv uses an iterative search technique. If the search has not converged after 100 iterations, the function returns the #N/A error value.