Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > FTEST
 

FTEST(array1, array2)

 
 Returns the result of an F-test.

 array1The first array.
 array2The second array.

 REMARKS
 
  		• An F-test returns the one-tailed probability that the variances in array1 and array2 are not significantly different.
     
  		• The arguments must be either numbers or names, arrays, or cell references that contain numbers.
     
  		• If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
     
  		• If the number of data points in array1 or array2 is less than 2, or if the variance of array1 or array2 is zero, then #DIV/0! is returned.
     
  		• This function claims to return the probability for the F-value in a one tailed test for the null hypothesis that the variances of two samples are equal. This actually returns the result for a two-tailed test.
     
  		• This function can be used to determine whether two samples have different variances.

     EXAMPLES
     
     A
    1=FTEST({1,2,3},{4,5,6}) = 1
    2=FTEST({6,7,9,15,21},{20,28,31,38,40}) = 0.648
    		 
     Functions - F | Index - F | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top