Spread Formula Reference
Formula Functions / Functions D to G / FTEST
In This Topic
    FTEST
    In This Topic

    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