Collapse All Expand All

This function returns the result of an F-test, which returns the two-tailed probability that the variances in two arrays are not significantly different.

Syntax

F.TEST(array1,array2)

Arguments

The arguments may be arrays of values.

Data Types

Accepts arrays of numeric data for both arguments. Returns numeric data.

Examples

F.TEST(A1:D34,A35:D68)

F.TEST(R1C1:R34C4,R35C1:R68C4)

 

 

---

Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.