Manuals/calci/TINV

TINV(prob,df)

• $prob$ is the probability value for the two tailed T-distribution.
• $df$ is the degrees of freedom.

Description

• 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.

Examples

1. =TINV(0.0742,55) = 1.820015422
2. =TINV(2*0.0371,55) = 1.820015422
3. =TINV(0.65482,29) = 0.451735616
4. =TINV(0.5,5) = 0.726686844

See Also

• TTEST
• TDIST

References

• Student's t-distribution