F.TEST Function

Returns the two-tailed p-value of an F-test comparing two variances.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice F.TEST in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

F.TEST checks whether two samples vary by genuinely different amounts. It returns the two-tailed p-value for the ratio of their variances. A p-value is the chance of seeing a difference at least this big if there were really no difference. Below 0.05 is the usual cut-off for calling a result statistically significant.

A common use is choosing the t-test type: if F.TEST isn't significant, T.TEST type 2 (equal variance) is reasonable; otherwise use type 3.

Syntax

=F.TEST(array1, array2) Explain

Arguments

ArgumentRequired?What it does
array1YesThe first sample.
array2YesThe second sample.

Examples

Example 1 — Do order values vary differently?

Average order value ($) at eight Northstar stores, before and after a checkout redesign.

E2fx=F.TEST(B2:B9,C2:C9)
ABCDE
1StoreBeforeAfterMeasureResult
2Store 14246p-value0.8915
3Store 23844Var before7.93
4Store 34549Var after7.13
5Store 44043
6Store 53741
7Store 64448
8Store 74147
9Store 83945
=F.TEST(B2:B9,C2:C9) Explain

p ≈ 0.89: the spread is about the same before and after, so an equal-variance t-test is fine.

Common mistakes

  • #DIV/0! Either sample has fewer than two values, or a variance is 0.
  • Sensitive to outliers. The F-test assumes roughly bell-shaped data; one outlier can change it a lot.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.