# How to Find Critical Value in Excel?

Get FREE Advanced Excel Exercises with Solutions!

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. In this article, I will elucidate how to find critical value in Excel by showing 2 useful methods.

## How to Find Critical Value in Excel: 2 Useful Methods

This is the dataset that I am going to work with. I have assumed the Degree of Freedom (n) = 14 and Level of Significance (Î±) = 0.1. I will calculate the T-values and Z-values using these parameters.

### 1. Find T Critical Value in Excel

The T critical value is basically the indicator of determining the statistical significance of a T-test. Depending on the type of test, the calculation process varies.

#### 1.1 Use T.INV Function for Left-Tailed Test

Here we will learn how to calculate the T critical value for a Left-Tailed Test. We need to use the T.INV function in this case.

Steps:

• Go to C8. Write down the following formula.
`=T.INV(C4,C5)`

• Now press ENTER. Excel will return the result.

#### 1.2 Combine ABS and T.INV Functions for Right-Tailed Test

Now I will calculate the T critical value for a right-tailed test. This time I will use the ABS function along with the T.INV function.

Steps:

• Go to C9. Write down the following formula.
`=ABS(T.INV(C4,C5))`

Explanation:

Here the T.INV(C4,C5) returns the T-value for the left-tailed test and the ABS function adjusts the result for a right-tailed one.

• Now press ENTER. Excel will return the result.

#### 1.3 Apply T.INV.2T Function for Two-Tailed Test

Now letâ€™s focus on a two-tailed test. To calculate the T critical value for a two-tailed test, we ought to use the T.INV.2T function.

Steps:

• Go to C10. Write down the following formula
`=T.INV.2T(C4,C5)`

• Then press ENTER. Excel will show the result.

### 2. Use of NORM.S.INV Function to Find Z Critical Value in Excel

Now I will put some light on Z critical value. It is a statistical term widely used to determine the statistical significance of a hypothesis. In this case, the population parameters are of concern. We need to calculate the Z critical value for 3 different types of cases.

• Left-tailed test
• Right-tailed test
• Two-tailed test

I will discuss all the cases one by one.

#### 2.1 For Left-Tailed Test

In this section, I will focus on the left-tailed test.

Steps:

• Go to C8 and write down the following formula
`=NORM.S.INV(C4)`

• Then press ENTER. Excel will return the output.

#### 2.2 For Right-Tailed Test

In this section, I will explain how to calculate the Z critical value for a right-tailed test.

Steps:

• Go to C9 and write down the following formula
`=NORM.S.INV(1-C4)`

• Then press ENTER. You will get the result.

#### 2.3 For Two-Tailed Test

Excel can also compute the Z critical value for two-tailed tests. There are two values corresponding to a two-tailed test.

Steps:

• Go to C10. Write down the following formula
`=NORM.S.INV(C4/2)`

• Now press ENTER to get the output.

• Similarly, write down the following formula in C11.
=NORM.S.INV(1-C4/2)

• After that, press ENTER to calculate the result.

## Things to Remember

• The ABS function adjusts the T value for a right-tailed test.
• The T and Z critical values differ from the T and Z values. We calculate the T and Z values from the sample statistic and population parameters. Then we compare those values with the critical values to determine the statistical significance of a hypothesis.
• T values are used when the standard deviation of the population is unknown and the sample size is relatively small.

## Conclusion

In this article, I have demonstrated 2 handy methods to find critical value in Excel. I hope it helps everyone. And lastly, if you have any suggestions, ideas, or feedback please feel free to comment below.

## Related Articles

<< Go Back to Critical Value in Excel | Excel for StatisticsÂ |Â Learn Excel

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF