CONFIDENCE.T Function
Returns the margin of error for a mean, using the t distribution.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
CONFIDENCE.T returns the ± margin around a sample average when the standard deviation comes from the sample itself — the usual situation. It uses the t distribution, so the margin is wider than CONFIDENCE.NORM's for small samples.
alpha is 1 minus the confidence level: 0.05 for 95%.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| alpha | Yes | 1 − confidence level, such as 0.05 for 95%. |
| standard_dev | Yes | The sample standard deviation; must be greater than 0. |
| size | Yes | The sample size; at least 2. |
Examples
Example 1 — Confidence interval for the new average
Average order value ($) at eight Northstar stores, before and after a checkout redesign.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Store | Before | After | Measure | Result |
| 2 | Store 1 | 42 | 46 | Margin (95%) | 2.23 |
| 3 | Store 2 | 38 | 44 | Avg after | 45.38 |
| 4 | Store 3 | 45 | 49 | Low | 43.14 |
| 5 | Store 4 | 40 | 43 | High | 47.61 |
| 6 | Store 5 | 37 | 41 | ||
| 7 | Store 6 | 44 | 48 | ||
| 8 | Store 7 | 41 | 47 | ||
| 9 | Store 8 | 39 | 45 |
The true average order after the redesign is likely between about $43.14 and $47.61.
Example 2 — t vs. normal for a small sample
Standard deviation 1.5 with only 8 values:
Returns about 1.25, compared with 1.04 from CONFIDENCE.NORM(0.05,1.5,8).
Common mistakes
- #DIV/0! size is 1.
- #NUM! alpha is 0 or less or 1 or more, or standard_dev is 0 or negative.
- alpha, not confidence. Pass 0.05 for 95%.
Notes
- Related functions: CONFIDENCE.NORM, T.INV.2T, STDEV.S, T.TEST.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.