How to Find T Critical Value in Excel (with Easy Steps)

While working with Microsoft Excel, sometimes, we have to calculate the T critical value. Calculating the T critical value in Excel is an easy task. This is a time-saving task also. Today, in this article, we’ll learn four quick and suitable steps to find T critical value in Excel effectively with appropriate illustrations.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Introduction to T Critical Value

The T critical value is a number to which your T-value is compared. In general, you can reject the null hypothesis if your computed T value in a test is greater than your T critical value. In a T-Test, however, the statistic is merely one measure of significance. The p-value should also be taken into account.

You will be able to find T critical value in Excel when you will know the probability and the degree of freedom. You can apply the T.INV function for the left-tailed test to find the T critical value in Excel. The T.INV function is,

=T.INV(probability, deg_freedom)

find t critical value in excel

Where,

  • Probability: The probability is the significant level that has been used.
  • Deg_freedom: The deg_freedom is the degree of freedom.

You can also use the T.INV.2T function for the two-tailed test to find the T critical value in Excel. The T.INV.2T function is,

=T.INV.2T(probability, deg_freedom)

Where

  • Probability: The probability is the significant level that has been used.
  • Deg_freedom: The deg_freedom is the degree of freedom.

4 Easy Steps to Find T Critical Value in Excel

Let’s assume we have an Excel worksheet that contains the information about probability and degree of freedom. The probability and the degree of freedom are given in Column  C. From our dataset, we will find T critical value in Excel. We can easily find T critical value in Excel by using the T.INV and T.INV.2T Functions, and so on. You will use the T.INV function to calculate the T critical value for the left-tailed test. You will also apply the T.INV.2T function to calculate the T critical value for the two-tailed test. Here’s an overview of the dataset for today’s task.

find t critical value in excel


Step 1: Create Dataset with Parameters

In this portion, we will create a dataset to find T critical value in Excel. As we use the T.INV and T.INV.2T functions to find the T critical value. Both functions have two arguments. So we need a dataset that has the value of probability and the degree of freedom, and we also need another extra column to find the T critical value. Let’s say, we have the value of probability is 0.05 and the degree of freedom is 36 to calculate the T critical value. We will create a dataset with a heading named “ Calculation of T critical value”. Hence, our dataset is like the below screenshot.

find t critical value in excel


Step 2: Find T Critical Value for Left-Tailed Test

In this step, we will calculate the T critical value which is an easy task. This is time-saving also. We will use the T.INV function to calculate the T critical value for the left-tailed test. Let’s follow the instructions below to find T critical value for the left-tailed test!

  • First of all, select a cell. We will select cell C8 for the convenience of our work.

Find T Critical Value for Left-Tailed Test

  • After selecting cell C8, write down the INV function in that cell. The T.INV function is,
=T.INV(C4,C5)
  • Where C4 is the probability, C5 is the deg_freedom of the INV function.

  • Further, simply press ENTER on your keyboard. As a result, you will get -1.688297714 as the return of the INV function which is the T critical value.

Find T Critical Value for Left-Tailed Test


Step 3: Determine T Critical Value for Right-Tailed Test

In this portion, we will calculate the T critical value using the ABS and T.INV functions. This is a time-saving task also. We will use the ABS and T.INV functions to calculate the T critical value for the right-tailed test. Let’s follow the instructions below to find T critical value for the right-tailed test!

  • First, select a cell. We will select cell C9 for the convenience of our work.

Determine T Critical Value for Right-Tailed Test

  • After selecting cell C9, Type the ABS and INV functions in that cell. The ABS and T.INV functions are,
=ABS(T.INV(C4,C5))

Formula Breakdown:

  • Where C4 is the probability, C5 is the deg_freedom of the INV function.
  • INV(C4,C5) is the number of the ABS function which returns a positive integer value.

  • Hence, simply press ENTER on your keyboard. As a result, you will get 688297714 as the return of the ABS and T.INV functions which is the T critical value.

Determine T Critical Value for Right-Tailed Test


Step 4: Perform Two-Tailed Test to Find T Critical Value

Last but not the least, we will calculate the T critical value using the T.INV.2T function. This is an easy task. This is time-saving also. We will use the T.INV.2T function to calculate the T critical value for the two-tailed test. Let’s follow the instructions below to find T critical value for the two-tailed test!

  • First, select a cell. We will select cell C10 for the convenience of our work.

Perform Two-Tailed Test to Find T Critical Value

  • Hence, write down the INV.2T function in that cell. The T.INV.2T function is,
=T.INV.2T(C4,C5)
  • Where C4 is the probability, C5 is the deg_freedom of the INV.2T function.

  • Further, simply press ENTER on your keyboard. As a result, you will get 028094001 as the return of the T.INV.2T function which is the T critical value that has been given in the below screenshot.

Perform Two-Tailed Test to Find T Critical Value


Things to Remember

👉 If the probability is less than zero or greater than or equal to 1 then we will not find out the T critical value in Excel. That is the limitation of probability.

👉 #NUM! error happens when the value of probability and the degree of freedom are invalid.

👉 #DIV/0! error happens when a value is divided by zero(0) or the cell reference is blank.


Conclusion

I hope all of the suitable methods mentioned above to find T critical value will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo