F-Test Formula

The F-test formula one may use to perform the statistical test that helps the person conducting the test find whether the two population sets having the normal distribution of the data points have the same standard deviation.

F-Test is any test that uses F-distribution. F-value is a value on the F-distribution. Various statistical tests generate an F value. The value can determine whether the test is statistically significant. For example, to compare two variances, one has to calculate the ratio of the two variances, which is as under:

F Value = Larger Sample Variance / Smaller Sample Variance = σ₁²  / σ₂²

While F-test in Excel, we need to frame the null and alternative hypotheses. Then, we need to determine the level of significance under which the test has to carry. Subsequently, we must determine the degrees of freedom of the numerator and denominator. It will help determine the F-table value. The F-value seen in the table is then compared to the calculated F-value to determine whether or not to reject the null hypothesis.

Example #1

A statistician was carrying out an F-Test. He got the F statistic as 2.38. The degrees of freedom obtained by him were 8 and 3. Find out the F value from the F Table and determine whether we can reject the null hypothesis at a 5% significance level (one-tailed test).

Solution:

We must look for 8 and 3 degrees of freedom in the F Table. The F critical value obtained from the table is 8.845. Since the F statistic (2.38) is lesser than the F Table Value (8.845), we cannot reject the null hypothesis.

Example #2

An insurance company sells health insurance and motor insurance policies. Customers pay premiums for these policies. The CEO of the insurance company wonders if premiums paid by either of the insurance segments (health insurance and motor insurance) are more variable than another. He finds the following data for premiums paid:

Conduct a two-tailed F-test with a level of significance of 10%.

Solution:

• Step 1: Null Hypothesis H₀: σ₁² = σ₂²

Alternate Hypothesis H_a: σ₁² _≠  σ₂²

• Step 2: F statistic = F Value = σ₁²  / σ₂² = 200/50 = 4
• Step 3: df₁ = n₁ – 1 = 11-1 =10

df_{2 =}  n₂ – 1 = 51-1 = 50

• Step 4: Since it is a two-tailed test, alpha level = 0.10/2 = 0.050. The F value from the F Table with degrees of freedom as 10 and 50 is 2.026.
• Step 5: Since F statistic (4) is more than the table value obtained (2.026), we reject the null hypothesis.

Example #3

The bank has a head office in Delhi and a branch in Mumbai. There are long customer queues at one office, while customer queues are short at the other. The Operations Manager of the bank wonders if the customers at one branch are more variable than the number of customers at another. He carries out a research study of customers.

The variance of Delhi head office customers is 31, and that for the Mumbai branch is 20. The sample size for the Delhi head office is 11, and that for the Mumbai branch is 21. Carry out a two-tailed F-test with a level of significance of 10%.

Solution:

• Step 1: Null Hypothesis H₀: σ₁² = σ₂²

Alternate Hypothesis H_a: σ₁² _≠  σ₂²

• Step 2: F statistic = F Value = σ₁²  / σ₂² = 31/20 = 1.55
• Step 3: df₁ = n₁ – 1 = 11-1 = 10

df_{2 =}  n₂ – 1 = 21-1 = 20

• Step 4: Since it is a two-tailed test, alpha level = 0.10/2 = 0.05. The F value from the F Table with degrees of freedom as 10 and 20 is 2.348.
• Step 5: Since the F statistic (1.55) is lesser than the table value obtained (2.348), we cannot reject the null hypothesis.

One can use the F-Test formula in a wide variety of settings:

1. The F-Test is used to test the hypothesis that the variances of two populations are equal.
2. It is used to test the hypothesis that the means of given normally distributed populations with the same standard deviation are equal.
3. It is used to test the hypothesis that a proposed regression model fits the data well.

Workers in an organization pay daily wages. However, the organization's CEO is concerned about the wage variability between males and females in the organization. Below are the data taken from a sample of males and females.

Conduct a one-tailed F-Test at a 5% level of significance.

Solution:

• Step 1: H₀: σ₁² = σ₂², H₁: σ₁² _≠  σ₂²
• Step 2: Click on Data Tab > Data Analysis in Excel.

• Step 3: The below-mentioned window will appear. Select "F-Test Two-Sample for Variances" and then click on "OK."

• Step 4: Click on the "Variable 1 Range" box and select the range A2:A8. Click on the "Variable 2 Range" box and select the range B2: B7. Click A10 in the "Output Range." Select 0.05 as "Alpha" as a significance level is 5%. Then, click on "OK."

It will display the values for F statistic and F table value along with other data.

• Step 4: From the above table, we can see F statistic (8.296) is greater than F critical one-tail (4.95), so we will reject the null hypothesis.

Note 1: The variance of "Variable 1" has to be higher than that of "Variable 2." Otherwise, calculations made in Excel will be wrong. If not, then swap the data.

Note 2: If the "Data Analysis" button is unavailable in Excel, go to File > Options. Under Add-ins, select Analysis ToolPak and click on the Go button. Next, check "Analysis Tool Pack" and click on "OK."

Note 3: Excel uses a formula to calculate the F table value. Its syntax is: