T.DIST.2Tfunction returns the two-tailed probability of the Student's t-distribution. This function is commonly used in hypothesis testing to determine if two sets of data have different means. It is also used in confidence interval estimation, where it calculates the probability that the difference between two population means falls within a specified range.
- How to use
- Examples of using
T.DIST.2Tformula not working?
- Similar formulas to
T.DIST.2T formula with the syntax shown below, it has 2 required parameters:
- x (required):
The numeric value at which to evaluate the distribution.
- degrees_freedom (required):
The degrees of freedom of the distribution. Must be a positive integer greater than or equal to 1.
ExamplesHere are a few example use cases that explain how to use the
T.DIST.2Tformula in Google Sheets.
You can use the
T.DIST.2T function to determine if two sets of data have different means. For example, you might use it to test if a new process produces different results than an old process.
Confidence Interval Estimation
You can use the
T.DIST.2T function to estimate the probability that the difference between two population means falls within a specified range. For example, you might use it to estimate the probability that the difference between the heights of men and women falls within a certain range.
T.DIST.2Tnot working? Here are some common mistakes people make when using the
T.DIST.2TGoogle Sheets Formula:
Forgetting to convert degrees of freedom
The degrees of freedom parameter in
T.DIST.2T must be a positive integer. If a non-integer value is used or the value is not converted from a sample size, the formula will result in an error.
Using the wrong input order
T.DIST.2T function requires the input x to be listed before degrees_freedom. If the input order is reversed, the formula will return an error.
The following functions are similar to
T.DIST.2T or are often used with it in a formula:
T.DISTfunction returns the probability of a Student's t-distribution with a specified degrees of freedom. This function is usually used in hypothesis testing to determine the probability that a sample mean is within a specified range of values.
T.TESTfunction calculates the probability associated with a Student's t-test. This function is commonly used in statistics to determine whether two samples are likely to have come from the same two underlying populations that have the same mean. It returns the probability that the two samples are different. The function assumes that the two samples are independent of each other and have equal variances.
T.INV.2Tfunction returns the two-tailed inverse of the t-distribution. This is commonly used in hypothesis testing to determine the critical value of t for a given level of significance and degrees of freedom.
T.INVfunction returns the inverse of the Student's t-distribution for the provided probability and degrees of freedom. This function is commonly used to calculate a critical value from the t-distribution when working with small sample sizes.
You can learn more about the
T.DIST.2T Google Sheets function on Google Support.