F-Test in Excel - EASY Excel Tutorial 11/16/16, 9:27 PM
Excel Easy
#1 Excel tutorial on the net Excel Introduction Basics Functions Data Analysis VBA 300 Examples Ask us
F-Test Search Entire Site Go
This example teaches you how to perform an F-Test in Excel. The F-Test is used to test the null hypothesis that
the variances of two populations are equal. Chapter < >
Below you can find the study hours of 6 female students and 5 male students. Analysis ToolPak
H 0: σ 12 = σ 22
H 1: σ 12 ≠ σ 22 Learn more, it's easy
Histogram
Descriptive Statistics
Anova
F-Test
t-Test
Moving Average
Exponential Smoothing
To perform an F-Test, execute the following steps.
Correlation
1. On the Data tab, click Data Analysis.
Regression
Download Excel File
f-test.xls
Note: can't find the Data Analysis button? Click here to load the Analysis ToolPak add-in. Follow Excel Easy
2. Select F-Test Two-Sample for Variances and click OK.
3. Click in the Variable 1 Range box and select the range A2:A7.
4. Click in the Variable 2 Range box and select the range B2:B6.
5. Click in the Output Range box and select cell E1.
http://www.excel-easy.com/examples/f-test.html Page 1 of 2
F-Test in Excel - EASY Excel Tutorial 11/16/16, 9:27 PM
6. Click OK.
Result:
Important: be sure that the variance of Variable 1 is higher than the variance of Variable 2. This is the case, 160 >
21.7. If not, swap your data. As a result, Excel calculates the correct F value, which is the ratio of Variance 1 to
Variance 2 (F = 160 / 21.7 = 7.373).
Conclusion: if F > F Critical one-tail, we reject the null hypothesis. This is the case, 7.373 > 6.256. Therefore, we
reject the null hypothesis. The variances of the two populations are unequal.
5/10 Completed! Learn more about the analysis toolpak >
Back to Top: F-Test | Go to Next Chapter: Create a Macro
EXCEL EASY • FREE EXCEL HELP • COPYRIGHT (C) 2010-2016 • ALL RIGHTS RESERVED
MICROSOFT EXCEL TUTORIAL | HOW TO USE VBA | EXCEL FORMULAS | DROP-DOWN LIST
http://www.excel-easy.com/examples/f-test.html Page 2 of 2
