The F.TEST function returns the two-tailed probability that the variances in in the two supplied arrays are not significantly different.

  • This function was introduced in Excel 2010 and so is not available in earlier versions.
  • The F.TEST function replaces the FTEST function included in earlier versions of Excel.




Argument Description
array1 The first array or range of data
array2 The second array or range of data


  A B C D E F
1 Array1 Array2   Formula Result Notes
2 8 17   =F.TEST(A2:A5,B2:B5) 0.818729 F-test for the data sets in A2:A5 and B2:B5
3 1 19        
4 4 11        
5 7 13        

Common Function Error(s)

Problem What went wrong
#DIV/0! Occurs if either:

  the number of values in either array1 or array2 is less than 2
  the variance of array1 or array2 is equal to 0