FTEST(R1, R2)

 

Description

This function returns the significance level of the two-sided F-test on the variances of the data specified by the ranges R1 and R2.  The return value is the probability of error in rejecting the null hypothesis that the variance of R1 is equal to the variance of R2.

 

Parameters

 

R1

A range.

 

R2

A range.

 

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.