Guide for performing a T-Test in Excel
1. Open your data file in Excel.
2. From the Data tab, choose Data Analysis.
3. Scroll down until you see t-Test: Two-Sample Assuming Equal Variances; highlight it, then click on OK.
4. Using the mouse, highlight the cells containing the data for one of the samples. After they have been selected, click on the box labeled "Variable 2 Range". Using the mouse, highlight the cells containing the data for the other sample.
5. In the section labeled "Output Options", click on the circle beside output range; then click in the box beside it. Using the mouse, select a cell on your worksheet into which you would like the results to be placed. Click OK to continue.
The results of the T-Test will appear in the designated range. There is a significant difference between the two sample means if the absolute value of the t statistic is greater than the t critical value or P is less than the a level you have set.
Original work on this document was done by Central Virginia Governor's School student Christian Neeley (Class of '98).
Copyright © 1998 Central Virginia Governor's School for Science and Technology Lynchburg, VA