FTEST function

Category: Compatibility
Introduced: Excel 365

Summary

Returns the result of an F-test

Syntax

FTEST(array1,array2) The FTEST function syntax has the following arguments:
• Array1 Required. The first array or range of data.
• Array2 Required. The second array or range of data.

Example

=F.TEST(A2:A6,B2:B6)

Microsoft Support Page

https://support.microsoft.com/en-us/office/f-test-function-100a59e7-4108-46f8-8443-78ffacb6c0a7

Back to Functions