T.TEST

Formulas / T.TEST
Determine if two samples come from the same two underlying populations with the same mean.
`T.TEST(array1,array2,tails,type)`
• array1 - required; first data set
• array2 - required; second data set
• tails - required; number of distribution tails
• type - required; type of t-Test to perform

Examples

• `=T.TEST(A2:A10, B2:B10, 2, 1)`

In this example, the T.TEST function is used to perform a two-sample t-test with paired data (dependent samples) to determine whether the means of two data sets (A2:A10 and B2:B10) are significantly different. The third argument, 2, specifies a two-tailed test, and the fourth argument, 1, specifies a paired t-test. The formula returns the p-value for the test, which can be used to determine whether the difference between the means is statistically significant.

• `=T.TEST(C2:C15, D2:D15, 1, 2)`

In this example, the T.TEST function is used to perform a two-sample t-test with independent data (independent samples) to determine whether the mean of the first data set (C2:C15) is significantly greater than the mean of the second data set (D2:D15). The third argument, 1, specifies a one-tailed test, and the fourth argument, 2, specifies a two-sample equal variance t-test (independent samples with equal variances). The formula returns the p-value for the test, which can be used to determine whether the difference between the means is statistically significant.

Summary

The T.TEST function is used to perform a student's t-test, which requires arguments for array1, array2, tails, and type. All arguments are required to use the T.TEST function.

• T.TEST is a function in Sourcetable that performs a t-Test by computing a non-negative t-statistic using data in the two arrays (array1 and array2). The arguments for T.TEST are array1, array2, tails, and type. All of these arguments are required.