21.76.1.TTEST(array1,array2,tails,type) returns the probability associated with a Student's 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 |