|
<< Click to Display Table of Contents >> F.TEST (F-test) |
Syntax:
F.TEST(Array1, Array2)
Description:
This returns the test statistics of an F-test.
An F-test can be used to check the consistency of the variances of two samples.
Array1 and Array2 are the two arrays (samples) to be evaluated.
They both have to consist of at least 2 values; otherwise the function returns a #DIV/0! error value (division by zero).
If the variance of Array1 or Array2 is 0, the function returns a #DIV/0! error value.
Compatibility notes:
Microsoft Excel supports this function only in version 2010 or later. The function is unknown in older versions.
See also: