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
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
Arguments
| Argument | Required? | What it does |
|---|---|---|
| array1 | Yes | The first sample. |
| array2 | Yes | The second sample. |
Examples
Example 1 — Do order values vary differently?
Average order value ($) at eight Northstar stores, before and after a checkout redesign.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Store | Before | After | Measure | Result |
| 2 | Store 1 | 42 | 46 | p-value | 0.8915 |
| 3 | Store 2 | 38 | 44 | Var before | 7.93 |
| 4 | Store 3 | 45 | 49 | Var after | 7.13 |
| 5 | Store 4 | 40 | 43 | ||
| 6 | Store 5 | 37 | 41 | ||
| 7 | Store 6 | 44 | 48 | ||
| 8 | Store 7 | 41 | 47 | ||
| 9 | Store 8 | 39 | 45 |
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

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.