Table of Contents
The T.DIST.2T function in Google Sheets is a statistical function that calculates the probability of a Student’s t-distribution. This function is useful for analyzing data when the sample size is small and the population standard deviation is unknown. To use the T.DIST.2T function, simply enter the required parameters, including the value of t, the degrees of freedom, and the optional boolean value for cumulative probability, into the designated cells. The function will then return the probability of the t-distribution, which can be useful for making informed decisions and conducting statistical analysis. Overall, the T.DIST.2T function is a valuable tool for those working with small data sets and who require accurate probability calculations.
T.DIST.2T function
The T.DIST.2T function returns the two tailed Student distribution for a value x. Along with T.DIST.RT, this function replaces TDIST and is equivalent to calling TDIST with the tails argument set to 2.
Parts of a T.DIST.2T function
T.DIST.2T(x, degrees_freedom)
| Part | Description |
x | Required. The x value to evaluate the distribution at. |
degrees_freedom | Required. The degrees of freedom. |
Sample formulas
Example 1: T.DIST.2T(1.96, 60)
Example 2: T.DIST.2T(1, 2)
Notes
- If deg_freedom is less than 1, returns an #NUM error.
- If x is negative, returns an #NUM error.
- Along with
T.DIST.RT, this formula replaces theTDISTformula. This is equivalent to calling theTDISTformula with tails = 2.
Examples
Result for A1=T.DIST.2T(1.96, 60)
| A | B | |
| 1 | 0.054644929736529 | |
| 2 |
Result for A1=T.DIST.2T(1, 2)
| A | B | |
| 1 | 0.42264973081037 | |
| 2 |
Related functions
- T.DIST: The T.DIST function returns the right tailed Student distribution for a value x.
- T.DIST.RT: Returns the right tailed Student distribution for a value x.
- TDIST: Calculates the probability for Student’s t-distribution with a given input (x).
Cite this article
stats writer (2024). How do I use the T.DIST.2T function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-the-t-dist-2t-function-in-google-sheets/
stats writer. "How do I use the T.DIST.2T function in Google Sheets?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-the-t-dist-2t-function-in-google-sheets/.
stats writer. "How do I use the T.DIST.2T function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-the-t-dist-2t-function-in-google-sheets/.
stats writer (2024) 'How do I use the T.DIST.2T function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-the-t-dist-2t-function-in-google-sheets/.
[1] stats writer, "How do I use the T.DIST.2T function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How do I use the T.DIST.2T function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.