How to Do a Paired Two Sample T

1. Enter your first set of data in column A. Enter your second set of data in column B. Make sure you only put one data result in each cell.
2. In cell C1 type '=TTEST(.' Do not hit 'Enter.'
3. Highlight your first data set and type ',.'
4. Highlight your second data set and type ',.'
5. Type '2,1).' Press 'Enter.' You formula in the cell should look like '=TTEST(A1:A5,B1:B5,2,1).' The cell returns the t Test result.