FTEST

Definition: FTEST is a function that returns the result of an F-test, which compares the variances of two sets of data.

Syntax: =FTEST(array1, array2)

Situation: This formula is suitable when you need to compare the variances of two sets of data.

Example: If you have two sets of data in arrays A1:A10 and B1:B10, the result of an F-test can be found using the formula =FTEST(A1:A10, B1:B10).