Spread Formula Reference
Formula Functions / Functions D to G / F.TEST
In This Topic
    F.TEST
    In This Topic

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

    Syntax

    F.TEST(array1,array2)

    Arguments

    The arguments may be arrays of values.

    Data Types

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

    Examples

    F.TEST(A1:D34,A35:D68)

    F.TEST(R1C1:R34C4,R35C1:R68C4)

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.

    See Also

    FTEST