WorksheetFunction.T_Inv (Excel)
Returns the left-tailed inverse of the Student t-distribution.
If either argument is non-numeric, T_Inv returns the #VALUE! error value. If probability < 0 or if probability > 1, T_Inv returns the #NUM! error value. If deg_freedom is not an integer, it is truncated. If deg_freedom < 1, T_Inv returns the #NUM! error value.
T_Inv (Arg1, Arg2)
Dim dblArg1 As Double: dblArg1 =
Dim dblArg2 As Double: dblArg2 =
Dim dblT_Inv As Double
dblT_Inv = WorksheetFunction.T_Inv(Arg1:=dblArg1, Arg2:=dblArg2)
Arguments
Arg1, Arg2Arg1 (Double) - Probability - The probability associated with the Student t-distribution.
Arg2 (Double) - Deg_freedom - The number of degrees of freedom with which to characterize the distribution.