CONFIDENCE.T function
CONFIDENCE.T returns the margin of error for a mean using Student's t distribution, which suits small samples where the population spread is unknown. The result is a little wider than CONFIDENCE.NORM.
Example
Read it as a sentence: find the margin of error using the t distribution at the 0.05 significance level for a standard deviation of 2.5 and a sample of 30.
A
B
C
D
1
0.933515341895251
2
3
Syntax
CONFIDENCE.T(alpha, standard_dev, size)
-
alpha(required) - Significance level, e.g. 0.05.
-
standard_dev(required) - Sample standard deviation.
-
size(required) - Sample size; must be above 1.
Returns: The margin of error for a mean, using Student's t distribution.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=CONFIDENCE.T(0.05,2.5,50) | 0.710492139 | Working example |
=CONFIDENCE.T("0.05",2.5,50) | 0.710492139 | Text-number in first arg |
=CONFIDENCE.T({0.05,0.05},2.5,50) | 0.710492139 | Array in first arg (lifts, spills) |
=CONFIDENCE.T(0.05,2.5,50.9) | 0.710492139 | Fractional size truncated |
=CONFIDENCE.T("abc",2.5,50) | #VALUE! | Non-numeric text in first arg |
=CONFIDENCE.T(NA(),2.5,50) | #N/A | Error in first arg |
=CONFIDENCE.T(0,2.5,50) | #NUM! | Alpha 0 |
=CONFIDENCE.T(1,2.5,50) | #NUM! | Alpha 1 |
Watch out for
- size of 1 returns #DIV/0!.
- Use the sample standard deviation (STDEV.S).
Where it works
- Excel
- CONFIDENCE.T arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .