F.TEST
Returns the result of an F-test.
StatisticalStatistics & Analysis
What it does
Legacy F-Test.
Syntax
FTEST(array1, array2)
Arguments
array1(range) — Range 1.array2(range) — Range 2.
Examples
Legacy FTest
Calculate p-value.
FORMULA
=FTEST(A1:A5, B1:B5)
RESULT
0.6
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | A | B |
| 2 | 1 | 2 |