F.TEST (Numbers1, Numbers2) F.TEST (Numbers1; Numbers2)
Numbers1
The first set of values.
Numbers2
The second set of values.
Returns
Number Number
The two-tailed probability of an F-test.
Returns the two-tailed probability of an F-test, which tests whether the variances of two sets of data differ. A small result, such as one below 0.05, indicates that the two sets of data come from populations with different variances.
Example
F.TEST ({ 6, 7, 9, 15, 21 }, { 20, 28, 31, 38, 40 })
F.TEST ({ 6; 7; 9; 15; 21 }; { 20; 28; 31; 38; 40 })
Returns roughly 0.65.