T.DIST.2T
TheT.DIST.2T
function 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
T.DIST.2T
formula? - Examples of using
T.DIST.2T
formula T.DIST.2T
formula not working?- Similar formulas to
T.DIST.2T
Usage
Use the 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.
Examples
Here are a few example use cases that explain how to use theT.DIST.2T
formula in Google Sheets.
Hypothesis Testing
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.
Common Mistakes
T.DIST.2T
not working? Here are some common mistakes people make when using the T.DIST.2T
Google 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
The 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.
Related Formulas
The following functions are similar to T.DIST.2T
or are often used with it in a formula:
-
T.DIST
The
T.DIST
function 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.TEST
The
T.TEST
function 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.2T
The
T.INV.2T
function 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.INV
The
T.INV
function 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.
Learn More
You can learn more about the T.DIST.2T
Google Sheets function on Google Support.