Author: Oscar Cronquist Article last updated on October 22, 2018

The F.TEST function calculates the two-tailed probability from an F-test, the value shows if the variances from two data sets are not significantly different.

This function was introduced in Excel 2010 has replaced the FTEST which is now outdated.

Formula in cell D12:

=F.TEST(B3:B9,D3:D9)

Excel Function Syntax

F.TEST(array1, array2)

Arguments

array1 Required. The first data set.
array2 Required. The second data set.

Comments

The arguments must contain numbers or cell references to numbers.

Text, boolean and empty values are ignored.

The F.TEST function returns

  • #DIV/0! error value if the number of items in each data set don't match.
  • #VALUE! error value if any argument is non-numeric.

The LINEST function calculates the F statistic whereas the F.TEST function calculates the probability.