Table of Contents
The T.INV function in Google Sheets is used to find the inverse of the Student’s t-distribution. This function allows users to determine the critical value of a t-statistic based on a given probability and degrees of freedom. To use the T.INV function, the user must input the probability and degrees of freedom into the designated cells, and the function will return the corresponding t-statistic. This can be useful in statistical analysis and hypothesis testing. The T.INV function can be accessed through the “fx” button in the formula bar or by typing it directly into a cell. It is a valuable tool for users looking to calculate critical values in their data analysis.
T.INV
Calculates the negative inverse of the one-tailed TDIST function.
Sample Usage
T.INV(0.35, 1)
T.INV(A1, A2)
Syntax
T.INV(probability, degrees_freedom)
probability– The probability associated with the t-distribution.Must be greater than
0and less than1.
degrees_freedom– The number of degrees of freedom.Truncated to an integer in the calculation if a non-integer is provided as an argument.
Must be greater than or equal to
1.
Notes
T.INVis to be used for the negative inverse of the one-tailedTDISTfunction.Both arguments to
T.INVmust be numeric or a destination cell whose value is numeric.
See Also
TDIST: Calculates the probability for Student’s t-distribution with a given input (x).
TINV: Calculates the inverse of the two-tailed TDIST function.
Examples
In this example, T.INV uses a probability value of 0.05757 and degrees_freedom of 45 to compute the result.
[wpcc-iframe height=”180″ src=”https://docs.google.com/spreadsheets/d/1ZwtLloKFtL8KGUNg0e2di4ucoidhTKBEE2XMyKNK6MI/pubhtml?widget=true&headers=false” width=”350″]
Cite this article
stats writer (2024). How do you use the T.INV function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-you-use-the-t-inv-function-in-google-sheets/
stats writer. "How do you use the T.INV function in Google Sheets?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-do-you-use-the-t-inv-function-in-google-sheets/.
stats writer. "How do you use the T.INV function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-you-use-the-t-inv-function-in-google-sheets/.
stats writer (2024) 'How do you use the T.INV function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-you-use-the-t-inv-function-in-google-sheets/.
[1] stats writer, "How do you use the T.INV function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How do you use the T.INV function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.