Syntax: @FTEST(R1, R2)
R1 = a range
R2 = a range
@FTEST returns the significance level (alpha) of the two-sided F-test on the variances of the data specified by ranges R1 and R2. Alpha is the probability of error in rejecting the null hypothesis that var(R1)=var(R2).
Examples:
@FTEST(A1..A4, B1..B4) = 0.57065573, where A1..A4 = .5, .98, .22, .1, and B1..B4 = .87, .6, .21, .49
@FTEST(H5..H9, K5..K12) = 0.62049415, where H5..H9 = 14, 35, 37, 0, 33, and K5..K12 = 67, 77, 94, 34, 99, 56, 86, 67