Functions
FTEST
F-test (legacy)
Try it
When to use it
When should I use FTEST instead of F.TEST?
FTEST is the legacy version of F.TEST; use F.TEST in new spreadsheets. FTEST is kept for backward compatibility.
Used in
Syntax
FTEST(array1,array2)Examples
=FTEST({92,75,97,85,87,82,79},{84,89,87,95,82,71}) // => 0.8600520776898234
=FTEST({1,2,3,4,5},{1,2,3,4,5}) // => 1