T.INV()

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

Note

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().

See Also

T.DIST.2T(), T.TEST()

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.