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: