|
<< Click to Display Table of Contents >> FTEST (F-test) |
Note: FTEST is supplemented by the new identical function F.TEST, which is available in newer versions of Microsoft Excel (2010 or later).
Syntax:
FTEST(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.
See also: