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.


Frequently Asked Questions

What is the T.TEST function?
The T.TEST function is a statistical function in Sourcetable that calculates the probability of a Student's T-Test. It is commonly used to test the probability of two samples.
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?
The T.TEST function is useful for testing the difference in food spending between two populations.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV