Skip to Content

F.TEST

Returns the result of an F-test, the two-tailed probability

Syntax

F.TEST(array1, array2)

Parameters

  • array1: Required. The first array or range of data
  • array2: Required. The second array or range of data

Example

=F.TEST(A1:A10, B1:B10)
Returns: NumberSince: Excel 2010