Most intro statistics courses expect you to run your analysis in software, and Excel is often the first one students touch. The good news: you only need a handful of functions and one add-in to cover most intro-level assignments.

Step 1: Turn on the Data Analysis ToolPak

This free add-in isn't on by default. In Excel: File → Options → Add-ins → at the bottom, select "Excel Add-ins" and click Go → check "Analysis ToolPak" → OK. You'll now see a "Data Analysis" button under the Data tab.

The functions you'll use constantly

  • =AVERAGE(range) — the mean
  • =MEDIAN(range) — the median
  • =STDEV.S(range) — standard deviation for a sample (use this one for homework unless told otherwise)
  • =STDEV.P(range) — standard deviation for an entire population (less common in homework)
  • =COUNT(range) — sample size

Running a t-test with the ToolPak

  1. Enter your two groups' data in two columns.
  2. Go to Data → Data Analysis → choose the appropriate t-test option (paired, or two-sample assuming equal/unequal variances, depending on your design).
  3. Select your two data ranges when prompted.
  4. Excel outputs a table including the t-statistic and the p-value (look for "P(T<=t) two-tail" for a standard two-tailed test).

Worked example

Column A has 20 quiz scores from Class 1, Column B has 20 quiz scores from Class 2. To compare the two class averages:

Data → Data Analysis → t-Test: Two-Sample Assuming Unequal Variances → select A1:A20 and B1:B20 → OK.

Excel returns a table with both means, the t-statistic, and the p-value — if "P(T<=t) two-tail" is below 0.05, the difference between the classes is statistically significant.

Common mistakes

Using STDEV.P instead of STDEV.S. For a sample (almost always the case in homework), use STDEV.S — STDEV.P assumes you have data for the entire population, which is rare.

Not seeing the "Data Analysis" button and assuming Excel doesn't have it. It's just not enabled by default — go back to Step 1 rather than trying to calculate everything manually with formulas.

Stuck on a statistics assignment right now?

Tell us what you're working on and get matched with a tutor who explains the reasoning, not just the answer — free quote by email or WhatsApp.

Get a free quote

Related reading