Spread Formula Reference
FTEST
Support Options
Formula Functions > Functions D to G > FTEST

Glossary Item Box

This function returns the result of an F-test, which returns the one-tailed probability that the variances in two arrays are not significantly different.

Syntax

FTEST(array1,array2)

Arguments

The arguments may be arrays of values.

Data Types

Accepts arrays of numeric data for both arguments. Returns numeric data.

Examples

FTEST(A1:D34,A35:D68)

FTEST(R1C1:R34C4,R35C1:R68C4)

Version Available

This function is available in product version 1.0 or later.

See Also

ZTEST | TTEST | Statistical Functions

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.