T.TEST function - The function returns the probability associated with Student's t-Test in Excel

The following article introduces you to the T.TEST function - one of the functions in the statistical function group is very popular in Excel.

T.TEST function - The function returns the probability associated with Student's t-Test in Excel Picture 1

Description: The function returns the probability associated with a Student's t-Test. Support functions from Excel 2010 onwards.

Syntax: T.TEST (array1, array2, tails, type)

Inside:

- array1: The first dataset, is a required parameter.

- array2: The second dataset, a required parameter.

- tails: Determine the value of the distribution, the required parameters include:

+ tails = 1 -> use 1-side distribution.

+ tails = 1 -> use a 2-sided distribution.

- type: type of t test to be performed, required parameters include:

+ type = 1 -> test performs pairs.

+ type = 2 -> tests performed with 2 samples with the same variance.

+ type = 3 -> tests performed with 2 other samples with variance.

Attention:

- If two arrays have different data points and type = 1 -> the function returns the # N / A error value .

- Argument values ​​are not whole numbers -> they are truncated to whole numbers.

- If tails are not numeric -> the function returns the #VALUE! Error value .

- If tails are outside of its scope -> the function returns the #NUM! Error value

For example:

Calculate the probability associated with a Student's t-test as described in the following data table:

T.TEST function - The function returns the probability associated with Student's t-Test in Excel Picture 2

- Calculate the probability associated with the Student's t-test in pairs with a 2-sided distribution. In the cell to calculate enter the formula : = T.TEST (C6: C10, D6: D10,2,1)

T.TEST function - The function returns the probability associated with Student's t-Test in Excel Picture 3

- Press Enter -> probability associated with the Student's t-test in pairs with 2-sided distribution is:

T.TEST function - The function returns the probability associated with Student's t-Test in Excel Picture 4

- Calculate the probability associated with Student's t-test of two test pieces with the same variance with 1-sided distribution. In a cell to calculate enter the formula : = T.TEST (C6: C10, D6: D10,1,2)

T.TEST function - The function returns the probability associated with Student's t-Test in Excel Picture 5

- Press Enter -> the probability associated with Student's t test is two samples with the same variance with 1-side distribution:

T.TEST function - The function returns the probability associated with Student's t-Test in Excel Picture 6

Above are instructions and some specific examples when using the T.TEST function in Excel.

Good luck!