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: