[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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]