next up previous contents index
Next: FV Up: A. Function Reference Previous: FREQUENCY   Contents   Index


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


next up previous contents index
Next: FV Up: A. Function Reference Previous: FREQUENCY   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003