F.TEST

F.TEST(array1, array2)

Returns the probability value from an f distribution.

array1The first array.
array2The second array.

REMARKS
* For an illustrated example refer to the page under Distributions
* The f distribution is a continuous distribution
* This is similar to the CHISQ.TEST, T.TEST and Z.TEST functions.
* This function was added in Excel 2010 to replace the FTEST function.
* 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