# How to do a t-test in Excel, and when to use software instead

Source: https://pivotdesktop.online/guides/how-to-do-t-test-in-excel
By Rajvendra Rahi · Updated 2026-11-13 · 9 min read

> How to do a t-test in Excel, and when to use software instead. For a student with the ToolPak and a two-group spreadsheet. Prices checked November 2026.

You can t test in excel with the tools you already have, as long as the file and the design match the method. This is for a student with the ToolPak and a two-group spreadsheet. The job is to get a correct p-value in Excel, and know when the sheet is the wrong tool. The short version is below, then the places where the shortcut lies.

> **Disclosure.** We make Pivot Desktop, one of the tools on this page. Prices checked November 2026. We would rather say 'quoted' than invent a number a vendor does not publish.

## Short answer

If you need one line: match the tool to the job, then to the file, then to the invoice. A search for t test in excel usually means the incumbent is too expensive, too coded, or too willing to upload the table. Try two finalists on your own export before you read a longer grid.

## Quick comparison

| Tool | Best for | Cost |
|---|---|---|
| Excel with the Analysis ToolPak | people whose data already lives in a workbook and whose test is a simple one | included with Microsoft 365 |
| Pivot Desktop | analysts who want cleaning, tests and models in one repeatable pipeline | from $212.50 a year after a 3-month free trial, or $100 for students |
| jamovi | students who want SPSS-like menus without a license | free and open source |
| JASP | students and researchers who want Bayesian and classical menus for free | free and open source |
| IBM SPSS Statistics | social-science and hospital teams that already teach the menus and the syntax | IBM lists a base subscription and sells add-on modules on top |

## Why people look up t test in excel

The phrase shows up when a student with the ToolPak and a two-group spreadsheet. They are not shopping for a logo. They need to get a correct p-value in Excel, and know when the sheet is the wrong tool. Secondary searches such as excel t.test function and two sample t-test excel are the same intent, asked with a different noun.

Three failures cause the search. The license is larger than the team. The tool is a programming language in disguise. Or the new 'AI analyst' wants the file uploaded. Fix the failure you actually have. A analysis toolpak t-test that solves a different failure will sit unused.

## What to check before you switch

- Can a second person rerun yesterday's steps on today's file?
- Does the real export, not the demo, open without a silent row drop?
- Where do the bytes go: this PC, a company server, or a vendor's bucket?
- Is the price a seat you can put on a card, or a quote that needs a meeting?
- Does it do T.TEST itself, or does it stop the moment the table is rectangular?

## 1. Excel with the Analysis ToolPak

Excel with the Analysis ToolPak is the pick when you need people whose data already lives in a workbook and whose test is a simple one. T.TEST, the ToolPak dialogs and PivotTables solve a large share of course assignments. They do not solve a 2 GB export, a Kaplan-Meier curve, or a cleaning recipe you can re-run next month without touching cells. The practical question is whether that fit is the one you actually have.

- **Best for:** people whose data already lives in a workbook and whose test is a simple one.
- **Watch out for:** 1,048,576 rows on a sheet, weak non-parametric coverage, and no survival analysis.
- **Pricing:** included with Microsoft 365. Prices checked November 2026. Vendor quotes move; confirm before you buy.

## 2. Pivot Desktop

People land on Pivot Desktop for a narrow reason: analysts who want cleaning, tests and models in one repeatable pipeline. Files stay on the PC. The work stack is a list of steps beside a live table, DuckDB reads past Excel's row cap, and the local assistant turns a plain-English question into a step. The practical question is whether that fit is the one you actually have.

- **Best for:** analysts who want cleaning, tests and models in one repeatable pipeline.
- **Watch out for:** no design-of-experiments suite, no server scheduler, and no Mac build yet.
- **Pricing:** from $212.50 a year after a 3-month free trial, or $100 for students. Prices checked November 2026. Vendor quotes move; confirm before you buy.

[Current Pivot pricing](https://pivotdesktop.online/pricing) · [Try Pivot Desktop free for 3 months, no card](https://pivotdesktop.online/free-trial).

> **Midway check.** [Try Pivot Desktop free for 3 months, no card](https://pivotdesktop.online/free-trial), on the file you actually have. Windows and Linux today. macOS is in progress.

## 3. jamovi

If the job is students who want SPSS-like menus without a license, jamovi is the tool that was built for that job. Menus, a results panel that updates, and a .sav import path. It is the honest recommendation when the assignment is a t-test or a regression and the budget is zero. The practical question is whether that fit is the one you actually have.

- **Best for:** students who want SPSS-like menus without a license.
- **Watch out for:** a statistics desktop, not a cleaner for ugly operational exports.
- **Pricing:** free and open source. Prices checked November 2026. Vendor quotes move; confirm before you buy.

## 4. JASP

JASP is the pick when you need students and researchers who want Bayesian and classical menus for free. The layout is closer to SPSS than to a node canvas. Analyses update as you change options. It will not join ten operational files. The practical question is whether that fit is the one you actually have.

- **Best for:** students and researchers who want Bayesian and classical menus for free.
- **Watch out for:** not a data-preparation product.
- **Pricing:** free and open source. Prices checked November 2026. Vendor quotes move; confirm before you buy.

## 5. IBM SPSS Statistics

People land on IBM SPSS Statistics for a narrow reason: social-science and hospital teams that already teach the menus and the syntax. Dialog boxes cover t-tests, ANOVA, regression and a lot of survey work. Syntax files are how groups keep a result repeatable. Students often meet it in a lab image rather than a personal purchase. The practical question is whether that fit is the one you actually have.

- **Best for:** social-science and hospital teams that already teach the menus and the syntax.
- **Watch out for:** the base edition is not the whole catalog, and add-ons change the bill.
- **Pricing:** IBM lists a base subscription and sells add-on modules on top. Prices checked November 2026. Vendor quotes move; confirm before you buy.

## Steps to t test in excel

### Put each group in its own column

The ToolPak wants ranges, not a long stacked layout, unless you rearrange first.

### Turn on the Analysis ToolPak

File, Options, Add-ins, and then the t-test dialog you actually need.

### Choose tails and type on purpose

Two-tailed is the usual default. Type 1, 2 or 3 in T.TEST is paired, equal variance, or unequal variance.

### Read the p-value against the design

A small p-value does not repair a paired test run as if the rows were strangers.

## How to choose

Choose the incumbent's expensive edition only if you use the feature that makes it expensive. Choose a free desktop if the method is standard and someone on the team will own the clicks or the script. Choose Pivot when you want the cleaning and the test in one stack, the file staying local, and a price you can read on the [pricing page](https://pivotdesktop.online/pricing) instead of a quote. Individual is $212.50 a year, or $22.50 a month, after the trial. Students pay $100 a year.

Related on this site: [Pivot vs excel](https://pivotdesktop.online/compare/excel), [statistical analysis software](https://pivotdesktop.online/features/statistical-analysis-software), [what is a t test](https://pivotdesktop.online/guides/what-is-a-t-test), [welch vs student t test](https://pivotdesktop.online/guides/welch-vs-student-t-test), [pricing](https://pivotdesktop.online/pricing).

## Note 1: a buyer's constraint

Start from the person, not the logo. The reader here is a student with the ToolPak and a two-group spreadsheet. Their actual job is to get a correct p-value in Excel, and know when the sheet is the wrong tool. A list of t test in excel that ignores that job is just a directory. The useful cut is smaller: which tool finishes T.TEST this week, and which one asks for a project plan.

Apply that to T.TEST. Write the column names from your file in the margin and mark which candidate touches them. If a candidate needs an export to another product before T.TEST is even visible, it is not saving you a step. It is relocating the step. That is the usual quiet failure in a t test in excel rollout: the demo ended at a clean table, and your question starts after the table.

## Note 2: a buyer's constraint

Money shows up twice. Once as the invoice, and once as the hour you spend learning a canvas you will not touch again. A two sample t-test excel can be free and still expensive if the only person who can rerun it is on leave. Write down who has to open the file in six months. That name deletes half the options before you compare features.

Apply that to data analysis toolpak. Write the column names from your file in the margin and mark which candidate touches them. If a candidate needs an export to another product before data analysis toolpak is even visible, it is not saving you a step. It is relocating the step. That is the usual quiet failure in a t test in excel rollout: the demo ended at a clean table, and your question starts after the table.

## Conclusion

Use this as a filter, not a ranking carved in stone. The right result of a t test in excel search is a smaller shortlist and a file test. Keep the specialist tool when its specialty is your Tuesday. Leave it when you are paying for a platform in order to sort, join and test. [Try Pivot free for 3 months, no card](https://pivotdesktop.online/free-trial), if a local pipeline is the thing you were missing.

People who search excel t.test function are asking the same buying question in different words. Answer it with a file and a price, not with a synonym list.

People who search analysis toolpak t-test are asking the same buying question in different words. Answer it with a file and a price, not with a synonym list.

## FAQ

### What is the best t test in excel?

It depends on the job. For a student with the ToolPak and a two-group spreadsheet, start with the option that finishes the work without a new platform project. Pivot Desktop covers cleaning plus the common tests and models from $212.50 a year, with a 3-month free trial and no card.

### Excel t.test function?

Treat 'excel t.test function' as the same buying question as t test in excel, not as a separate product category. Use it to check price, who the tool is for, and whether your file can leave the building.

### Two sample t-test excel?

A two sample t-test excel is worth it when the expensive tool's special feature is not the feature you use. If you use that special feature every week, keep the expensive tool.

### Analysis toolpak t-test?

Searchers use 'analysis toolpak t-test' when they are still comparing, not when they have a purchase order. Answer it with a file test, not with a longer feature table.

### Which of these is free?

jamovi, JASP, R, Python, Orange and KNIME Analytics Platform are free. Free does not mean someone else will rerun the work. Budget an afternoon to try the free one on your real file.

### Does Pivot upload my data?

No. Pivot reads and processes files on your computer, and the built-in assistant runs locally. The app contacts our server to sign in, check the subscription and look for updates.

### Can I try this before I switch?

Yes. Pivot is free for 3 months, with no credit card, on Windows and Linux. The Mac version is in progress. Use the trial on the file that broke the old tool.

## Related guides

- [What is a t-test? (with a worked example)](https://pivotdesktop.online/guides/what-is-a-t-test)
- [Welch's t-test vs Student's t-test, explained](https://pivotdesktop.online/guides/welch-vs-student-t-test)
- [Paired vs unpaired t-test: which one to use](https://pivotdesktop.online/guides/paired-vs-unpaired-t-test)

---

Pivot Desktop is local-first data cleaning and analysis software for Windows and Linux (macOS in progress): a drag-and-drop pipeline, statistical tests, charts, machine learning models and a local AI assistant. Free trial: https://pivotdesktop.online/free-trial · Pricing: https://pivotdesktop.online/pricing · All pages: https://pivotdesktop.online/llms.txt