Edit

Share via


WorksheetFunction.T_Test(Object, Object, Double, Double) Method

Definition

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.

public:
 double T_Test(System::Object ^ Arg1, System::Object ^ Arg2, double Arg3, double Arg4);
public double T_Test (object Arg1, object Arg2, double Arg3, double Arg4);
Public Function T_Test (Arg1 As Object, Arg2 As Object, Arg3 As Double, Arg4 As Double) As Double

Parameters

Arg1
Object

Array1 - The first data set.

Arg2
Object

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.

Returns

Remarks

If array1 and array2 have a different number of data points, and type = 1 (paired), T_Test returns the #N/A error value.

The tails and type arguments are truncated to integers.

If tails or type is non-numeric, T_Test returns the #VALUE! error value.

If tails is any value other than 1 or 2, T_Test returns the #NUM! error value.

T_Test uses the data in array1 and array2 to compute a non-negative t-statistic. If tails=1, T_Test returns the probability of a higher value of the t-statistic under the assumption that array1 and array2 are samples from populations with the same mean. The value returned by T_Test when tails=2 is double that returned when tails=1 and corresponds to the probability of a higher absolute value of the t-statistic under the “same population means” assumption.

Applies to