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.

F.TEST takes 2 required arguments and no optional arguments:

Syntax: F.TEST(array1, array2)

The arguments for the F.TEST function are:
Argument Required? Description
array1 Required The first array or range of data.
array2 Required The second array or range of data.
comments powered by Disqus