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

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)

find f critical value in excel

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.

find f critical value in excel


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.

find f critical value in excel

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

find f critical value in excel

  • After completing the above instructions, you will be able to find out the F critical value which has been given in the below screenshot.

find f critical value in excel


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.

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