How to use F.TEST Function in Excel

The F.TEST function returns the result of an F-test, the two-tailed probability that the variances in array1 and array2 are not significantly different. Use this function to determine whether two samples have different variances. For example, given test scores from public and private schools, you can test whether these schools have different levels of test score diversity.

Syntax:= F.TEST(array1,array2)

The F.TEST function syntax has the following arguments:

  1. Array1 (required argument) – This is the first array of data.
  2. Array2 (required argument) – This is the second array of data.

Example: Let’s look at some Excel F.TEST function examples and explore how to use the F.TEST function as a worksheet function in Microsoft Excel:

Suppose we are given the following IQ scores of two groups:

F.TEST Function - How to use F.TEST Function in Excel

Using the F.TEST function, we will calculate the probability that there is no significant difference between the variances of the two datasets.

The formula to use is:

Syntax:  =F.TEST(A2:A13,B2:B13)

Result: 0.660020116

F.TEST Function in Excel - How to use F.TEST Function in Excel

Note:

  • The arguments must be either numbers or names, arrays, or references that contain numbers.
  • If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
  • If the number of data points in array1 or array2 is less than 2, or if the variance of array1 or array2 is zero, F.TEST returns the #DIV/0! error value.

Add a Comment

Your email address will not be published. Required fields are marked *