FTEST

Syntax:

FTEST ( array-1 , array-2 )

Description: Computes the result of an F-test.

Arguments:

Name	Type	Description
array-1	number, name, array, reference to number	If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included.
array-2

 

Return Type and Value: number – The two-tailed probability that the variances in array-1 and array-2 are not significantly different.

However, if

• The number of data points in array-1 or array-2 is less than 2, the return value is unspecified.

• The variance of array-1 or array-2 is zero, the return value is unspecified.

[Example:

If the cells D6:D10 contain 6, 7, 9, 15, and 21, and the cells E6:E10 contain 20, 28, 31, 38, and 40, FTEST(D6:D10,E6:E10) results in 0.648317847

end example]