FTEST function
the result of an F-test.
Compatibility · Guided Excel example
Where can you use it?
Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.
Scenario in the workbook
Check the legacy variance-comparison formula. Its output is a p-value.
A worked example from the workbook
| Row | A | B |
|---|---|---|
| 6 | Reading A | Reading B |
| 7 | 1 | 2 |
| 8 | 4 | 5 |
| 9 | 9 | 7 |
Record 1
=FTEST(A7:A9,B7:B9)Illustrative output0.5588235294
See the inputs and instructions for all 3 examplesCompatibility function for older workbooks.
Worked examples
Check the legacy variance-comparison formula. Its output is a p-value.
Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.
| Row | A | B |
|---|---|---|
| 6 | Reading A | Reading B |
| 7 | 1 | 2 |
| 8 | 4 | 5 |
| 9 | 9 | 7 |
| Trial | Expression | Sample output |
|---|---|---|
| Record 1 | =FTEST(A7:A9,B7:B9) |
0.5588235294 |
| Record 2 | =FTEST(A7:A8,B7:B8) |
1 |
| Record 3 | =FTEST(A8:A9,B8:B9) |
0.4844757664 |