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.

**Table of Contents**hide

## 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)**

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.

### 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.

### 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.

- 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.**

### 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.

- 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.**

### 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.

- 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.

## 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.