F.TEST

F.TEST(array1, array2)

Returns the probability value from an f distribution.

array1The first array.
array2The second array.

REMARKS
* 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

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


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