TINV

Syntax:

TINV ( probability , degrees-freedom )

Description: Computes the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom.

Arguments:

Name

Type

Description

probability

number

A probability associated with the two-tailed Student's t-distribution.

degrees-freedom

number

The number of degrees of freedom with which to characterize the distribution, truncated to an integer.

Return Type and Value: number – The t-value of the Student's t-distribution.

However, if

  • probability < 0 or probability > 1, #NUM! is returned.

  • degrees-freedom < 1, #NUM! is returned.

example: