Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

TTEST(array1,array2,tails,type) returns the probability associated with a Students t-test

If type equals 1, TTest is performed Paired If type equals 2, TTest is performed Two-sample equal variance (homoscedastic) If type equals 3, TTest is performed Two-sample unequal variance (heteroscedastic) Input the formula: =TTEST(A2:A10,B2:B10,2,1). Press Enter to get the result. Referenced from Excel Help