F.TEST(array1, array2)

Returns the probability value from an f distribution.

array1The first array.
array2The second array.

* This function was added in Excel 2010 to replace the FTEST function.
* The f distribution is a [[continuous distribution]].
* This is similar to the CHISQ.TEST, T.TEST and Z.TEST functions.
* For the Microsoft documentation refer to support.microsoft.com

1=F.TEST({1, 2}, {1, 2}) = 1

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top