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
array1: The first sample.array2: The second sample.
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
Two samples
A B C D 1 A B 2 6 20 0.648 3 7 28 4 9 31 5 15 38 6 21 40 In D2:
=F.TEST(A2:A6, B2:B6)→ 0.648Well above 0.05: no sign the spreads differ, so an equal-variance t-test is reasonable.
Common mistakes
- Normal data. The F-test is sensitive to data that is not normally distributed.
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.
- Czech: F.TEST
- Danish: F.TEST
- Dutch: F.TEST
- Finnish: F.TESTI
- French: F.TEST
- German: F.TEST
- Hungarian: F.PRÓB
- Italian: TESTF
- Norwegian: F.TEST
- Polish: F.TEST
- Portuguese (Brazil): TESTE.F
- Portuguese (Portugal): TESTE.F
- Russian: F.ТЕСТ
- Spanish: PRUEBA.F.N
- Swedish: F.TEST
- Turkish: F.TEST
Also written as FTEST.