The following article introduces you to the T.TEST function - one of the functions in the statistical function group is very popular in Excel.
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:
- 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)
- Press Enter -> probability associated with the Student's t-test in pairs with 2-sided distribution is:
- 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)
- Press Enter -> the probability associated with Student's t test is two samples with the same variance with 1-side distribution:
Above are instructions and some specific examples when using the T.TEST function in Excel.
Good luck!