Difference between revisions of "Manuals/calci/TINV"

Revision as of 06:09, 30 January 2014

TINV(prob,df)

This function gives the $t$ value of the T-distribution.
This function is called the inverse function of the T-distribution.
In $TINV(prob,df)$ , $prob$ is the probability value related with the two tailed distribution and $df$ is the number of degrees of freedom which is characterize the distribution.
i.e., This function is the inverse value of $TDIST(x,df,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 $df$ value is decimal then it is converted in to integers.
If $TDIST(x,df,t)=prob$ , then $TINV(prob,df)=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.prob<0 or prob>1 or df<1.

@@ Line 11: / Line 11: @@
 *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 <math>df<math> value is decimal then it is converted in to integers.
+*Suppose <math>df</math> value is decimal then it is converted in to integers.
 *If <math>TDIST(x,df,t)=prob </math>, then <math> TINV(prob,df)=x</math> for the two tailed T-distribution.
 *<math> TINV </math> using the iterating method to find the value of <math> x </math>.