WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » F-Test in Excel

F-Test in Excel

By Tanuj KumarTanuj Kumar | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What is F-Test in Excel?

F-test in excel is a test that is used to decide if two populations having normal distribution have similar variances or the standard deviation. This is an essential part of the Analysis of Variance (ANOVA). F-test is used to check the hypothesis of the fairness of two variances. It gives you the result of an independent variable. So sample data used in F-test is not dependent. It can easily evaluate multiple models at the same time in a large variety of settings.

How to Enable F-test in Excel?

  • Step 1 – You need to enable the Analysis ToolPak add-ins in your worksheet to use the F-test. In Excel, click on a file in the extreme left-hand side, goes to Options at the end, and click.

F-test step 1

  • Step 2 – Once you clicked on options, select Add-ins on the left side, Excel Add-ins is selected in view and manage box, and click Go.

F-test step 2

  • Step 3 – In the Add-ins dialog box, click on Analysis Toolpak, and click OK.

F-test step 3

  • This will add the Data Analysis tools in the right-hand side to the Data tab of our Excel ribbon.

F-test step 4

How to do F-Test in Excel? (Step by Step)

You can download this F-Test Excel Template here – F-Test Excel Template

Step 1 – Data to be used for F-test Analysis.

F-test Example 1

Once Analysis Toolpak workbook, follow the steps as mentioned below to practice the analysis of the F-test:

Step 2 – On the Data tab in the Excel ribbon, click on the Data Analysis.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example 1-1

Step 3 – After you click on data analysis, a dialog box opened. Click on the F-test and click OK to enable the function.

Example 1-2

Step 4 – Enter Variable Range 1 and 2

    1. Enter the variable 1 Range and select the range from your data.
    2. Enter the variable 1 Range and select the range from your data.

Example 1-3

Step 5 – Select the Output range.

Example 1-4

Step 6 – Click Ok, will get the analysis of data in the cell where you have selected the cell:

Example 1-5

Things to Remember

  • F-test can be used when you want to analyses the lecture of two professors, which means that both the professors are teaching the same subject, but you want to determine the quality or when you test two samples of bottle gourd under two different experimental conditions.
  • By using F-test, we will compute the likelihood that there is no critical distinction between the variances of the two datasets.
  • One of the important observation of F-test result is to check whether two of the samples shows the different variance or not.
  • Sometimes it occurs the error while calculating the f-test. A reason may be:
  • Value of array 1 and array 2 is less than the number 2.
  • Array 1 and Array 2 variance equal to the zero.
  • While calculating the F-test in Excel, it requires two sample data test can’t be processed on single data.
  • The function ignores the text if there is any text in the sample data.
  • The result will always be in numbers.

Recommended Articles

This has been a step by step guide to F-Test in Excel. Here we discuss how to perform F-Test along with practical examples and a downloadable excel template. You may learn more about excel from the following articles –

  • Normal Distribution Graph in Excel
  • FORECAST Function in Excel
  • NORM.S.INV Function
  • T-TEST in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download F-Test Excel Template

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More