Modifica

Condividi tramite


WorksheetFunction.Norm_S_Inv(Double) Method

Definition

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 Double

Parameters

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.

Applies to