Table of Contents
The T.DIST.RT function in Google Sheets is a statistical function that calculates the right-tailed probability of the T-distribution. This function is useful for analyzing data sets with small sample sizes and is commonly used in hypothesis testing and confidence interval calculations. To use the T.DIST.RT function, simply enter the required parameters, such as the value, degrees of freedom, and cumulative probability, into the function’s syntax. The function will then return the probability value, which can be used to make informed decisions about the data set. Overall, the T.DIST.RT function is a powerful tool for performing statistical analysis in Google Sheets.
T.DIST.RT function
Returns the right tailed Student distribution for a value x. Along with T.DIST.2T, this function replaces TDIST and is equivalent to calling TDIST with the tails argument set to 1.
Parts of a T.DIST.RT 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: A1 has T.DIST.RT(1.96, 60)
Example 2: A1 has T.DIST.RT(-1.98, 2)
Notes
- If deg_freedom is less than 1, returns an #NUM error.
- This formula along with
T.DIST.2Treplace theTDISTformula.T.DIST.RTis equivalent to calling theTDISTformula with tails = 1.
Examples
Result for A1=T.DIST.RT(1.96, 60)
| A | B | |
| 1 | 0.027322464868265 | |
| 2 |
Result for A1=T.DIST.RT(-1.98, 2)
| A | B | |
| 1 | 0.9068737480782105 | |
| 2 |
Related functions
- T.DIST: The T.DIST function returns the right tailed Student distribution for a value x.
- T.DIST.2T: The T.DIST.2T function returns the two 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 can I use the T.DIST.RT function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-t-dist-rt-function-in-google-sheets/
stats writer. "How can I use the T.DIST.RT function in Google Sheets?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-t-dist-rt-function-in-google-sheets/.
stats writer. "How can I use the T.DIST.RT function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-t-dist-rt-function-in-google-sheets/.
stats writer (2024) 'How can I use the T.DIST.RT function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-t-dist-rt-function-in-google-sheets/.
[1] stats writer, "How can I use the T.DIST.RT function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How can I use the T.DIST.RT function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.