Most intro college statistics courses expect you to actually run these tests in software, not by hand — and Excel is usually the first tool students learn it in. Here's what you need to know to go from a blank spreadsheet to a working statistical analysis.
Getting your data into Excel correctly
Put each variable in its own column, with a clear header in row 1, and each observation (each student, each trial) in its own row. Almost every function and tool in Excel assumes this layout — getting it wrong here causes problems in every step after.
Key built-in functions
- =AVERAGE(range) — the mean
- =STDEV.S(range) — sample standard deviation (use this one for a sample, which is almost always what you have in coursework)
- =STDEV.P(range) — population standard deviation (only if you truly have the entire population, not a sample)
- =VAR.S(range) — sample variance
- =COUNT(range) — sample size (n)
Turning on the Data Analysis ToolPak
For anything beyond basic descriptive statistics — t-tests, ANOVA, regression — you need Excel's Data Analysis ToolPak, which isn't turned on by default. Go to File → Options → Add-ins, then at the bottom select "Excel Add-ins" and click Go. Check the box for "Analysis ToolPak" and click OK. You'll now see a "Data Analysis" button under the Data tab.
Running a t-test in Excel
Click Data → Data Analysis → choose the appropriate t-Test option (paired, or two-sample assuming equal/unequal variances depending on your data), select your two data ranges, and Excel outputs the t-statistic and p-value directly — no manual formula needed.
Worked example: standard deviation in Excel
You have exam scores in cells A2 through A26 (25 students).
To find the mean: =AVERAGE(A2:A26)
To find the sample standard deviation: =STDEV.S(A2:A26)
These two numbers are usually the starting point for almost every other calculation in an intro stats assignment — confidence intervals, t-tests, and more all build on them.
Common mistakes
Using STDEV.P instead of STDEV.S. Coursework almost always deals with a sample, not a full population — using the population version understates your true uncertainty.
Forgetting to enable the Data Analysis ToolPak. Without it, t-tests, ANOVA, and regression tools simply won't appear under the Data tab, which is the most common reason students get stuck before they've even started.
Stuck on a stats problem 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