Edit

Share via


WorksheetFunction.Norm_Inv(Double, Double, Double) Method

Definition

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

public:
 double Norm_Inv(double Arg1, double Arg2, double Arg3);
public double Norm_Inv (double Arg1, double Arg2, double Arg3);
Public Function Norm_Inv (Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double

Parameters

Arg1
Double

Probability - A probability corresponding to the normal distribution.

Arg2
Double

Mean - The arithmetic mean of the distribution.

Arg3
Double

Standard_dev - The standard deviation of the distribution.

Returns

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(Double)).

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(Double, Double, Double, Boolean).

Applies to