Difference between revisions of "Manuals/calci/TINV"

From ZCubes Wiki
Jump to navigation Jump to search
Line 1: Line 1:
−
<div style="font-size:30px">'''TINV(prob,df) '''</div><br/>
+
<div style="font-size:30px">'''TINV (Probability,DegreeOfFreedom) '''</div><br/>
−
*<math>prob </math> is the probability value for the two tailed T-distribution.
+
*<math>Probability </math> is the probability value for the two tailed T-distribution.
−
*<math> df </math> is the degrees of freedom.
+
*<math> DegreeOfFreedom </math> is the degrees of freedom.
  
 
==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(prob,df)</math>, <math>prob </math> is the probability value related with the two tailed distribution and <math> df </math> is the number of degrees of freedom which is characterize the distribution.  
+
*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(x,df,2)</math>.  
+
*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>df</math> value is decimal then it is converted in to integers.
+
*Suppose <math>DegreeOfFreedom</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.   
+
*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.prob<0 or prob>1 or df<1.
+
     2.Probability<0 or Probability>1 or DegreeOfFreedom<1.
  
 
==Examples==
 
==Examples==

Revision as of 15:37, 12 June 2018

TINV (Probability,DegreeOfFreedom)


  • 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
    1.Any one of the argument is non-numeric. 
    2.Probability<0 or Probability>1 or DegreeOfFreedom<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

Related Videos

TINV

See Also

References


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/TINV&oldid=210237"