# F Test in Excel

In this tutorial we will learn how to perform F Test in Excel. When we want to compare two variances we use F Test. F Test is the test of null hypothesis, which states the variance of two population are equal.

H0: σ12 = σ22
H1: σ12 ≠ σ22

Alternate hypothesis H1 states that the two population variances are not equal.

#### Data:

We will be using the scores of students across two different subjects to depict example on F test in Excel, Which is shown below. Step 1: On the top right corner of the data tab click data analysis. Step 2: Select F – Test Two Sample for Variances and click ok. Step 3: Click in the Input Range boxes and select the Variable 1 Range A2:A10 and Variable 2 Range B2:B10.  And select the output range as D2, as shown below and click ok. The result of F – Test will be Note: Variance of variable 1 should be greater than variance of variable 2. If not swap the data.

• F value is nothing but ratio of variable 1 variance to variable 2 variance i.e. 606.75/379.11 = 1.6004.
• If F > F Critical one-tail, we reject the null hypothesis. In our case F < F Critical one-tail, so we can’t reject null hypothesis. The variances of two population are equal.