WorksheetFunction.T_Test (Excel)

Returns the probability associated with a Student t-Test. Use T_Test to determine whether two samples are likely to have come from the same two underlying populations that have the same mean.

The following table represents possible values for Arg4.

T_Test (Arg1, Arg2, ..., Arg4)

Dim dblArg3 As Double: dblArg3 = 
Dim dblArg4 As Double: dblArg4 = 
Dim dblT_Test As Double
dblT_Test = WorksheetFunction.T_Test(Arg1:=, Arg2:=, Arg3:=dblArg3, Arg4:=dblArg4)

Arguments

Arg1 - Array1 - The first data set

Arg2 - Array2 - The second data set

Arg3 (Double) - Tails - Specifies the number of distribution tails. If tails = 1, T_Test uses the one-tailed distribution. If tails = 2, T_Test uses the two-tailed distribution.

Arg4 (Double) - Type - The kind of t-Test to perform.