ExcelFlux

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

RowAB
6Reading AReading B
712
845
997
Record 1
=FTEST(A7:A9,B7:B9)

Illustrative output0.5588235294

See the inputs and instructions for all 3 examples

Compatibility 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
Microsoft Excel reference