FTEST

**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

**Excel function:** *N/A*

Grey Trout Software

02 March 2003