TINV Excel Formula

Author Zaheer    Category Formulas     Tags ,

In Microsoft Excel application, this TINV function is a statistical function and this article will describe and discuss the improvement of this function for Excel 2003 as well as for later versions, which affects its results in various intense cases when it is being compared to Microsoft Excel’s previous versions. As stated, TINV function is considered as the inverse function of TDIST function. The TDIST’s last argument is the exact tails number within the student’s distribution, which is one of the examples. In one positive x value, TDIST significantly returns its probability for the t-distributed arbitrary variable having the df or degrees of freedom, which is equal to or greater than x or is equal to or less than negative x.

In addition, TINV function definitely returns the x value while TDIST returns the p value. Therefore, this function is evaluated through the search procedure, which returns the right x value by evaluating the certain statistical function for the different x values until the function finds the value of x that the function is acceptably near to p.

NOTE

This distribution is founded by one of the employee in Guinness brewery, which is found in Dublin, Ireland.

For the simple and explainable definition of TINV function for Excel, this function takes back the t-value from the t-distribution of the Student as degrees of freedom and as the probability function. The syntax for the TINV function within MS Excel is TINV (probability, degrees_freedom). This Probability is associated with “student’s t-distribution” that is two-tailed. The degrees_freedom is considered as the figure of specified degrees of freedom, which is characterized by the distribution.

Interpretation and Remarks:

  • If each of the arguments is considered as non-numeric, then TINV displays the #VALUE! value.
  • If the probability is less than zero, then it returns the error value of #NUM!.
  • If the degrees_freedom is less than one then the TINV function returns ITS error value #NUM!.
  • If the degrees_freedom is never considered as an integer, then it’s truncated.
  • TINV function takes back the value of t, then P(x >t) is equal to the probability wherein x are random variables.
  • The t-value that is one-tailed is returned by restoring the probability having 2*probability. With the 0.05 probability as well as degree of freedom of ten, the value that is two-tailed is being calculated with the function, =TINV (0.05, 10) that returns 2.28139. This is for the similar degrees of freedom and probability that are calculated with the function TINV (2*0.05, 10) that returns the result of 1.812462.

In few tables, the probability is being explained as (1-p). For instance, given the value for the probability then TINV seeks the x value that TDIST(x, degree_freedom, 2) is equal to the probability. Moreover, the TINV function precision is depending on the TDIST precision. In addition, TINV function uses a search iterative technique. Moreover, if the search hasn’t definitely converged after one hundred iterations, then the function TINVdisplays the #N/A value.

It is imperative that you have to learn this statistical function so that you can easily use it in solving existing data problems within your spreadsheet in Microsoft Excel.

Further readings

Post comment