Manuals/calci/FTEST
Jump to navigation
Jump to search
FTEST (arr1, arr2)
Where arr1 is the first array or range of data and arr2 is the second array or range of data.
F-test calculates the two-tailed probability that the variances in arr1 and arr2 are not significantly different.
· The arguments must either be numbers or names, arrays, or references that contain numbers.
· When the number of data points in arr1 or arr2 is less than 2, or if the variance of arr1 or arr2 is zero FTEST displays NaN.
FTEST
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 5 | 17 | ||
| Row2 | 10 | 28 | ||
| Row3 | 4 | 35 | ||
| Row4 | 8 | 48 | ||
| Row5 | 19 | 40 | ||
| Row6 | 0.21573734399999997 | |||
| Row7 |
AVEDEV (N1, N2...) Where N1, N 2 ... are positive integers.
i.e =FTEST (C1R1:C1R5, C2R1:C2R5) is 0.2157