Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11T.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.
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!
Lesley MontoyaYou should read it
- ZTEST function - Returns the probability value on one side of the z test in Excel
- TDIST function - The function returns the probability of the Student distribution in Excel
- FTEST function - The function returns the result of an F-Test in Excel
- CHISQ.TEST function - The function returns the independence test in Excel
- Z.TEST function - The function returns one-sided value of the z test in Excel
- BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excel
- T.INV function - The function returns the inverse value of the Student t distribution in Excel
- F.INV function - The function returns the inverse of the probability distribution F in Excel
May be interested
- CHISQ.TEST function - The function returns the independence test in Excel
chisq.test function: the function returns the independence test. the function returns the value from the distribution (({chi ^ 2})) when squared for statistics and the appropriate degrees of freedom. support function from excel 2010 version. syntax: chisq.test (actual_range, expected_range) - GUSSE function - The function returns the probability that an element of the population is normalized in Excelgusse function: the function returns the probability that an element of the normalized population will fall into the mean and the standard deviation. support functions from excel 2013 onwards. syntax: gauss (z)
- CHISQ.INV.RT function - The function returns the inverse of the right end probability of the distribution when squared in Excelchisq.inv.rt function: the function returns the inverse of the right end probability of the distribution when squared. support function from excel 2010 version. syntax: chisq.inv.rt (probability, deg_freedom)
- F.DIST.RT function - The function returns the right probability distribution F for 2 data sets in Excelf.dist.rt function: the function returns the right probability distribution f for 2 data sets. support functions from the excel 2010 version. syntax: f.dist (x, deg_freedom1, deg_freedom2)
- CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excelchisq.inv function: the function returns the inverse of the probability of the left end of the distribution when squared. support functions from the excel 2010 version. syntax: chisq.inv (probability, deg_freedom)
- BINOM.DIST function - Function returns the probability of binomial distribution of individual terms in Excelbinom.dist function: the function returns the binomial distribution probability of an individual term. support functions from the excel 2010 version. syntax: binom.dist (number_s, trials, probability_s, cumulative)
- Z.TEST function - The function returns one-sided value of the z test in Excelz.test: the function returns the one-sided p value of the z test. support functions from excel 2010 onwards. syntax: z.test (array, x, [sigma])
- CHISQ.DIST.RT function - The function returns the right end probability of the distribution when squared in Excelchisq.dist.rt function: the function returns the probability of the right end of the distribution when squared. support function from excel 2010 version. syntax: chisq.dist.rt (x, deg_freedom)
- PROB function - The function returns the probability that values in a range are between two limits in Excelprob function: the function returns the probability that values in a range are between two limits. syntax: prob (x_range, prob_range, [lower_limit], [upper_limit])
- GAMMA.INV function - The function returns the inverse of the gamma distribution in Excelgamma.inv: the function returns the inverse of the gamma distribution, using this function to study their distribution variables that may be symmetrical. support functions from excel 2010 onwards. syntax: gamma.inv (probability, alpha, beta)
Office information
- TREND - The function returns values in a linear trend in Excel
- TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel
- VAR.P function - Function that calculates variance based on the entire set, ignoring logical values and text in Excel
- VAR.S function - Function that calculates variance based on a sample, ignoring logical values and text in Excel
- VARA - Function that calculates variance based on a sample, including logical values and text in Excel
- VARPA function - Function that calculates variance based on the entire set, including logical values and text in Excel
TREND - The function returns values in a linear trend in Excel
TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel
VAR.P function - Function that calculates variance based on the entire set, ignoring logical values and text in Excel
VAR.S function - Function that calculates variance based on a sample, ignoring logical values and text in Excel
VARA - Function that calculates variance based on a sample, including logical values and text in Excel
VARPA function - Function that calculates variance based on the entire set, including logical values and text in Excel