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

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


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

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999