T.TEST
Formulas / T.TESTDetermine 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.
Frequently Asked Questions
What is the T.TEST function?
What types of tests can be performed with the T.TEST function?
- Paired t-test
- Two-sample equal variance t-test
- Two-sample unequal variance t-test
What is the purpose of the T.TEST function?
