Fix a Missing Two-Sample t-Test in Excel Data Analysis ToolPak
Question details
The user needs to find and run a two-sample t-test in Excel's Data Analysis ToolPak.

- Product
- Microsoft Excel Analysis ToolPak
- Device & OS
- not provided
- Scenario
- The user wants to compare two sets of observations using a t-test in Excel.
- Observed behavior
- The Data Analysis ToolPak is installed, but a two-sample t-test option does not appear.
Open the workbook in the desktop version of Excel and arrange each group of observations in a separate column. Check whether the observations are independent or paired so you can select the appropriate test.
Enable Analysis ToolPak and find the correct t-test
Use this method to verify that the add-in is active and locate the t-test under its full name.
In Excel for Windows, select File > Options > Add-ins. Under Manage, choose Excel Add-ins and click Go.
Select the Analysis ToolPak check box and click OK. If it is already selected, confirm the selection and restart Excel.
Select Data > Data Analysis, then scroll through the Analysis Tools list to the t-test entries.
For independent groups, select t-Test: Two-Sample Assuming Equal Variances or t-Test: Two-Sample Assuming Unequal Variances. For matched observations, select t-Test: Paired Two Sample for Means.
Select the two input ranges, specify the hypothesized mean difference, alpha, and output location, then click OK.

Use Excel's T.TEST function to compare two samples
Use a worksheet formula if the Data Analysis dialog does not show the test you need.
Compare spreadsheet data with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and work with your data while moving between office applications.

Frequently Asked Questions
Why can't I find an option named simply “Two-Sample t-Test”?
Excel lists separate options in Data > Data Analysis: t-Test: Two-Sample Assuming Equal Variances and t-Test: Two-Sample Assuming Unequal Variances. Paired data has its own option, t-Test: Paired Two Sample for Means.
Which t-test should I choose for two independent groups?
Choose an independent two-sample test. Use the equal-variances option when equal population variances are justified; otherwise, consider the unequal-variances option.
When should I use the paired t-test?
Choose t-Test: Paired Two Sample for Means in Data > Data Analysis when each observation in one range is matched to an observation in the other, such as before-and-after measurements for the same people.
What can I do if Data Analysis is missing from the Data tab?
In Excel for Windows, go to File > Options > Add-ins, select Excel Add-ins under Manage, click Go, and enable Analysis ToolPak. In Excel for Mac, check Tools > Excel Add-ins.
Can I get a t-test result without the ToolPak?
You can use the T.TEST function in a worksheet cell. For example, =T.TEST(A2:A11,B2:B11,2,3) returns the p-value for a two-tailed, unequal-variance test using those two ranges.




