The Excel F.TEST Function

Basic Description

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

The F.TEST function is new to Excel 2010. However, this is simply a renamed version of the Ftest function, which is available in earlier versions of Excel.

The syntax of the Excel F.Test function is:

F.TEST( array1, array2 )

where the supplied array1 and array2 are two arrays of data values, that represent samples from two different populations. If the arrays contain logical values or empty cells, these are ignored by the F.Test function.


Example of use of the Excel F.Test Function

F.Test Function Example

Columns A and B of the spreadsheet on the right contain the reaction times of a sample of individuals from two different groups. Cell C2 of the spreadsheet shows the use of the Excel F.TEST function to calculate the probability that there is no significant difference between the variances of the two data sets.

The result of the F.Test function in cell C2 is 0.954035559.

Further examples of the Excel F.Test function can be found on the Microsoft Office website.


F.Test Function Error

If you get an error returned from the Excel F.Test Function, this is likely to be the Excel #DIV/0! error :

Common Error
#DIV/0! - Occurs if either:
- the number of values in either array1 or array2 is less than 2
or
- the variance of array1 or array2 is equal to 0
Return to the Excel Statistical Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net