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

TTEST(array1, array2, tails, type)

 
 Returns the probability associated with a Student's t-Test. Use TTEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean.

 array1The first array.
 array2The second array.
 tailsThe number of distribution tails:
1 = one-tailed distribution
2 = two-tailed distribution
 typeThe kind of t-Test to perform:
1 = paired
2 = two sample equal variance (homoscedastic)
3 = two sample unequal variance (heteroscedastic)

 REMARKS
 
  		• If "array1" and "array2" have a different number of data points, and type = 1 (paired), then #N/A is returned.
     
  		• If "tails" is not an integer, it is truncated.
     
  		• If "tails" < 1, then #NUM! is returned.
     
  		• If "tails" > 1, then #NUM! is returned.
     
  		• If "tails" is not numeric, then #VALUE! is returned.
     
  		• If "type" is not an integer, it is truncated.
     
  		• if "type" < 1, then #NUM! is returned.
     
  		• If "type" > 3, then #NUM! is returned.
     
  		• If "type" is not numeric, then #VALUE! is returned.

     EXAMPLES
     
     A
    1=TTEST({3,4,5,8,9,1,2,4,5},{6,19,3,2,14,4,5,17,1},2,1) = 0.196
    2=TTEST({1,2,3,4,5},{1,2,3,4,5},2,1) = #DIV/0!
    		 
     Functions - T | Index - T | Office Online 

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