Wauvel

Excel like a finance pro.

← The library

Compatibility function

FTEST

Returns the result of an F-test; replaced by F.TEST.

Rarely usedDifficulty 1450 · AdvancedUsage rank #443 of 520
Practice · 2 questions →

When to use it

The two-tailed F-test for equal variances. Replaced by F.TEST.

The shape of it

Syntax
=FTEST(array1, array2)

Worked examples

  • Similar variances

    =FTEST({6,7,9,15,21},{20,28,31,38,40}) → 0.64831

    No evidence of different variances.

  • Different variances

    =FTEST(A2:A31,B2:B31) → 0.012

    Different variances.

  • Identical

    =FTEST(A2:A31,A2:A31) → 1

    A sample against itself.

Worth knowing

  • Same as F.TEST.
  • Run before choosing the T.TEST type.
  • Sensitive to non-normality.

Where it goes wrong

  • #DIV/0! for fewer than two values or zero variance.
  • Flagged by the Compatibility Checker.

Related

FORECASTMODEPERCENTILEQUARTILERANKSTDEV

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.