WorksheetFunction.Norm_Inv (Excel)

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

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.

Norm_Inv (Arg1, Arg2, Arg3)

Dim dblArg1 As Double: dblArg1 = 
Dim dblArg2 As Double: dblArg2 = 
Dim dblArg3 As Double: dblArg3 = 
Dim dblNorm_Inv As Double
dblNorm_Inv = WorksheetFunction.Norm_Inv(Arg1:=dblArg1, Arg2:=dblArg2, Arg3:=dblArg3)

Arguments

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.