| | | If any of the arguments are not numeric, then #VALUE! is returned. |
| | | If "probability" < 0, then #NUM! is returned. |
| | | If "probability" > 1, then #NUM! is returned. |
| | | If "degrees_freedom" is not an integer, it is truncated. |
| | | If "degrees_freedom" < 1, then #NUM! is returned. |
| | | TINV is calculated as TINV = p( t |
| | | A one-tailed t-value can be returned by replacing probability with 2*probability. For a probability of 0.05 and degrees of freedom of 10, the two-tailed value is calculated with TINV(0.05,10), which returns 2.28139. The one-tailed value for the same probability and degrees of freedom can be calculated with TINV(2*0.05,10), which returns 1.812462. |
| | | The accuracy of this function was improved in Excel 2003. For more information please refer to this Knowledge Base Article (828340). |
