TINV Excel Formula
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
Categories
Recent Posts
- How to Use the MS Excel Keyboard Shortcuts
- How to Locate Duplicate Records Quickly By Using Conditional Formatting in MS Excel
- How to Use PasteSpecial – Procedures for Microsoft Excel 2003 and Microsoft Excel 2007
- How to Sort using an AutoFilter – Understanding and Learning the Feature
- How to Base a Chart Off of Auto Filtered Records
- How to Use IF IsError Together?
- How to Use Custom Views
- How to Create Pivt Table
- How to Manipulate PivotTable after It has Been Created
- How to Update the Data in a Pivot Table
- How to Create Dynamic Named Ranges
- How to Use an Array
- How to Embed 8 If Statements into 1
- How to Edit a Recorded Macro?
- How to Record a Macro