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