F.TEST FunctionWayne Becker20151008T06:18:33+00:00
The F.TEST function returns the twotailed 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.
Syntax
=F.TEST(array1,array2)
Arguments
Argument 
Description 
array1 
The first array or range of data 
array2 
The second array or range of data 
Examples

A 
B 
C 
D 
E 
F 
1 
Array1 
Array2 

Formula 
Result 
Notes 
2 
8 
17 

=F.TEST(A2:A5,B2:B5) 
0.818729 
Ftest 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 
