Difference between revisions of "Manuals/calci/TINV"
Jump to navigation
Jump to search
| (6 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''TINV( | + | <div style="font-size:30px">'''TINV (Probability,DegreeOfFreedom) '''</div><br/> |
| − | *<math> | + | *<math>Probability </math> is the probability value for the two tailed T-distribution. |
| − | *<math> | + | *<math> DegreeOfFreedom </math> is the degrees of freedom. |
| + | **TINV(), returns the inverse of the Students t-distribution. | ||
==Description== | ==Description== | ||
*This function gives the <math>t</math> value of the T-distribution. | *This function gives the <math>t</math> value of the T-distribution. | ||
*This function is called the inverse function of the T-distribution. | *This function is called the inverse function of the T-distribution. | ||
| − | *In <math> TINV( | + | *In <math> TINV(Probability,DegreeOfFreedom)</math>, <math>Probability</math> is the probability value related with the two tailed distribution and <math> DegreeOfFreedom </math> is the number of degrees of freedom which is characterize the distribution. |
| − | *i.e., This function is the inverse value of <math> TDIST( | + | *i.e., This function is the inverse value of <math> TDIST (Number,DegreeOfFreedom,2)</math>. |
*Suppose we want to find the inverse value of one tailed distribution, then we have to multiply 2 with the prob value. | *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. | *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. | *TINV(2*0.078,20)=1.474181542 which is the inverse value of one tailed T-distribution. | ||
| − | *Suppose <math> | + | *Suppose <math>DegreeOfFreedom</math> value is decimal then it is converted in to integers. |
| − | *If <math>TDIST( | + | *If <math>TDIST (Number,DegreeOfFreedom,Tail)=prob </math>, then <math> TINV (Probability,DegreeOfFreedom)=x</math> for the two tailed T-distribution. |
*<math> TINV </math> using the iterating method to find the value of <math> x </math>. | *<math> TINV </math> using the iterating method to find the value of <math> x </math>. | ||
*Suppose the iteration has not converged after 100 searches, then the function gives the error result. | *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 | *This function will give the result as error when | ||
1.Any one of the argument is non-numeric. | 1.Any one of the argument is non-numeric. | ||
| − | 2. | + | 2.Probability<0 or Probability>1 or DegreeOfFreedom<1. |
==Examples== | ==Examples== | ||
| Line 25: | Line 26: | ||
#=TINV(0.5,5) = 0.726686844 | #=TINV(0.5,5) = 0.726686844 | ||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|sn5_vMaB1YE|280|center|TINV}} | ||
| + | |||
==See Also== | ==See Also== | ||
*[[Manuals/calci/TTEST | TTEST]] | *[[Manuals/calci/TTEST | TTEST]] | ||
| Line 30: | Line 35: | ||
==References== | ==References== | ||
| + | *[http://en.wikipedia.org/wiki/Student%27s_t-distribution Student's t-distribution] | ||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 16:23, 8 August 2018
TINV (Probability,DegreeOfFreedom)
- is the probability value for the two tailed T-distribution.
- is the degrees of freedom.
- TINV(), returns the inverse of the Students t-distribution.
is the probability value for the two tailed T-distribution.
is the degrees of freedom.
Description
- This function gives the value of the T-distribution.
- This function is called the inverse function of the T-distribution.
- In , is the probability value related with the two tailed distribution and is the number of degrees of freedom which is characterize the distribution.
- i.e., This function is the inverse value of .
- 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 value is decimal then it is converted in to integers.
- If , then for the two tailed T-distribution.
- using the iterating method to find the value of .
- 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
value of the T-distribution.
, 
.
, then 
for the two tailed T-distribution.
using the iterating method to find the value of 
. 1.Any one of the argument is non-numeric.
2.Probability<0 or Probability>1 or DegreeOfFreedom<1.
Examples
- =TINV(0.0742,55) = 1.820015422
- =TINV(2*0.0371,55) = 1.820015422
- =TINV(0.65482,29) = 0.451735616
- =TINV(0.5,5) = 0.726686844
Related Videos
See Also
References