Advanced Excel Statistical - T.INV Function

Description

The T.INV function returns the left-tailed inverse of the Student's t-distribution.

Syntax

T.INV (probability,deg_freedom)

Arguments

Argument Description Required/ Optional
Probability The probability associated with the Student's tdistribution. Required
Deg_freedom The number of degrees of freedom with which to characterize the distribution. Required.

Notes

  • If deg_freedom is not an integer, it is truncated.

  • If either argument is nonnumeric, T.INV returns the #VALUE! error value.

  • If probability <= 0 or if probability > 1, T.INV returns the #NUM! error value.

  • If deg_freedom < 1, T.INV returns the #NUM! error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

T.Inv Function
advanced_excel_statistical_functions.htm
Advertisements