While working with **Microsoft Excel**, sometimes, we have to **calculate** the F critical value. Calculating the F critical value in **Excel **is an easy task. This is a time-saving task also. Today, in this article, weâ€™ll learn **two **quick and suitable steps to find F 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 F Critical Value

The F critical value is a number to which your F-value is compared. In general, you can reject the null hypothesis if your computed F value in a test is greater than your F critical value. In an F 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 F critical value in **Excel **when you will know the **probability**, the **degree of freedom **of the **Numerator**, and the **degree of freedom **of the **Denominator**. You can apply the **F.INV.RT** function to find the F critical value in Excel. The **F.INV.RT** function is,

=**F.INV.RT(probability, deg_freedom1, deg_freedom2)**

Where,

**Probability:**The probability is the significant level that has been used.**Deg_freedom1:**The deg_freedom1 is the degree of freedom of the**numerator**.**Deg_freedom2:**The deg_freedom2 is the degree of freedom of the**denominator**.

## 2 Easy Steps to Find F Critical Value in Excel

Letâ€™s assume we have an **Excel **worksheet that contains the information about probability and degree of freedom. The **probability**, the **degree of freedom 1**, and the **degree of freedom 2**Â are given in Columns **B, C**, and **D **respectively. From our dataset, we will find F critical value in Excel. We can easily calculate the F **critical value **in **Excel **by using **the F.INV.RT Function**, and so on. Hereâ€™s an overview of the dataset for todayâ€™s task.

### Step 1: Create Dataset to Find F Critical Value

In this portion, we will create a dataset to find F critical value in **Excel**. As we use the **F.INV.RT** function to find the F critical value. The function has three arguments. So we need a dataset that has 3 columns, and we also need another extra column to find the F critical value. We will create a heading named â€ś **F critical value**â€ť. Hence, our dataset is like the below screenshot.

### Step 2: Use F.INT.RT Function to Find F Critical Value in Excel

In this step, we will calculate the F critical value which is an easy task. This is time-saving also. To do that, we will use the **F.INV.RT** function. Letâ€™s follow the instructions below to find F critical value!

- First of all, select a cell. We will select cell
**E5**for the convenience of our work.

- After selecting cell
**E5**, write down the**INV.RT**function in that cell. The**F.INV.RT**function is,

`=F.INV.RT(B5,C5,D5)`

- Where
**B5**is the**probability**,**C5**is the**deg_freedom1**, and**D5**is the**deg_freedom2**of the**F.NV.RT**function.

- Further, simply press
**ENTER**on your keyboard. As a result, you will get**5.390345863**as the return of the**F.INV.RT**function which is the**F critical value.**

- Now, place your cursor on the bottom-right corner of cell
**E5**. Hence, instantly, an**autoFill**sign will appear in front of you. - After that,
**autoFill**the**INV.RT**function to the rest of the cell in column**E**.

- After completing the above instructions, you will be able to find out the F critical value which 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 calculate the F critical value in **Excel**.

đź‘‰** #NUM!** error happens when the value of probability, the **degree of freedom **of the **Numerator**, and the **degree of freedom **of the **Denominator** are invalid.

đź‘‰ **#DIV/0!** error happens when a value is divided by **zero(0)** or the cell reference is **blank**.

đź‘‰ In **Microsoft 365**, Excel will show the **#Value! Error** if you donâ€™t select the proper dimension. The **#Value!** error occurs when any of the elements of the matrices is not a number.

## Conclusion

I hope all of the suitable methods mentioned above to **find F 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.