|
<< Click to Display Table of Contents >> F.TEST (F-test) |
Syntax:
F.TEST(Array1, Array2)
Description:
Returns the test statistics of an F-test.
An F-test can be used to check the consistency of the variances between 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 zero, the function returns a #DIV/0! error value.
Compatibility notes:
Microsoft Excel supports this function only in version 2010 or later. In older versions, the function is unknown.
See also: