Excel functions / Statistics

F.TEST function

The F-test: the chance that two samples would have variances this different if their populations varied equally. Two-tailed.

Syntax

=F.TEST(array1, array2)

Arguments

When to use it

F.TEST compares the spread of two samples and gives a two-tailed p-value: the chance their variances would differ this much if their populations varied equally. It is a check before choosing which t-test to use.

Examples

  1. Two samples

    ABCD
    1AB
    26200.648
    3728
    4931
    51538
    62140

    In D2: =F.TEST(A2:A6, B2:B6) → 0.648

    Well above 0.05: no sign the spreads differ, so an equal-variance t-test is reasonable.

    Try this example

Common mistakes

F.TEST in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Also written as FTEST.

Try F.TEST in the playground

Related functions