[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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:

TINV(0.054644927,60) results in 1.95999999

end example]