Syntax. T.INV(probability,degrees_freedom)
Definition. This function returns the left quantile of a Student’s t-distribution.
Arguments
probability (required). The probability associated with the two-tailed Student’s t-distribution
degrees_freedom (required). The number of degrees of freedom with which to characterize the distribution
If one of the arguments isn’t a numeric expression, the T.INV() function returns the #VALUE!
error.
If probability is less than 0 or greater than 1, the T.INV() function returns the #NUM!
error.
If degrees_freedom isn’t an integer, the decimal places are truncated. If degrees_freedom is less than 1, the function returns the #NUM!
error.
Background. You will find more information about t-values or critical values in the description of T.INV.2T().
Example. You will find more information about the use of this function in the description of T.INV.2T().
Sample Files
Use the TINV or T.INV worksheet in the Probability.xls or Probability.xlsx sample file. The sample files are found in the Chapter12 folder. For more information about the sample files, see the section titled Using the Sample Files.
18.191.176.194