How to Use Excels TINV Function

By eHow Computers Editor

Rate: (0 Ratings)

Excel's TINV function analyzes data to find its probabilities and inverse probabilities. It is essentially a more in-depth analysis than the TDIST Excel function because it uses a two-tail analysis instead of a one-tail analysis.

Flag Article

Instructions

Difficulty: Moderately Easy

Step1

Enter your data into an Excel spreadsheet cell. This data should be the probability of the Students t-distribution, a number that needs analysis because it comes from sample pool that is too small to accurately analyze on it's own.

Step2

Choose another cell and enter the degree of freedom. The cells do not need to be adjoining each other. The degree of freedom is essentially the chances of change in a number. For example, four out of five gives you four opportunities for change, or four degrees of freedom.

Step3

Go to a third cell and enter your formula =TINV(X,Y). X and Y will be the numbers you entered in Steps 1 and 2, respectively. The results of your statistical analysis will be displayed in this cell.

Step4

Evaluate your results. Your results should tell you that your initial t-distribution is either correct or that it's incorrect. If the results you achieve are a numerical value, your analysis is correct. If the result is an error, your analysis is incorrect and you need to adjust your t-distribution.

Step5

Adjust your t-distribution accordingly until you've achieved an accurate result based upon your small sample pool. By playing with the numbers, you should end up with a numerical value as a result of the TINV function.