Manuals/calci/TINV

TINV (Probability,DegreeOfFreedom)

$Probability$ is the probability value for the two tailed T-distribution.
is the degrees of freedom.
- TINV(), returns the inverse of the Students t-distribution.

Description

This function gives the $t$ value of the T-distribution.
This function is called the inverse function of the T-distribution.
In $TINV(Probability,DegreeOfFreedom)$ , $Probability$ is the probability value related with the two tailed distribution and $DegreeOfFreedom$ is the number of degrees of freedom which is characterize the distribution.
i.e., This function is the inverse value of $TDIST(Number,DegreeOfFreedom,2)$ .
Suppose we want to find the inverse value of one tailed distribution, then we have to multiply 2 with the prob value.
For e.g., TINV(0.078,20) = 1.857683 which is the inverse value of two tailed T-distribution.
TINV(2*0.078,20)=1.474181542 which is the inverse value of one tailed T-distribution.
Suppose $DegreeOfFreedom$ value is decimal then it is converted in to integers.
If $TDIST(Number,DegreeOfFreedom,Tail)=prob$ , then $TINV(Probability,DegreeOfFreedom)=x$ for the two tailed T-distribution.
$TINV$ using the iterating method to find the value of $x$ .
Suppose the iteration has not converged after 100 searches, then the function gives the error result.
This function will give the result as error when

    1.Any one of the argument is non-numeric. 
    2.Probability<0 or Probability>1 or DegreeOfFreedom<1.