Formula Functions > Functions D to G > FTEST |
This function returns the result of an F-test, which returns the one-tailed probability that the variances in two arrays are not significantly different.
FTEST(array1,array2)
The arguments may be arrays of values.
Accepts arrays of numeric data for both arguments. Returns numeric data.
FTEST(A1:D34,A35:D68)
FTEST(R1C1:R34C4,R35C1:R68C4)
This function is available in product version 1.0 or later.
ZTEST | TTEST | Statistical Functions