Excel functions / Statistics
CONFIDENCE.T function
The margin of error of a sample mean, using Student's t-distribution. Add it to and subtract it from the mean for the confidence interval.
Syntax
=CONFIDENCE.T(alpha, standard_dev, size)
Arguments
alpha: The significance level: 0.05 for 95% confidence.standard_dev: The standard deviation of the sample.size: How many values the sample has.
When to use it
CONFIDENCE.T gives the margin of error of a sample mean using Student's t-distribution, which suits small samples better than CONFIDENCE.NORM.
Examples
Margin of error for 50 values with SD 1
A B C D 1 SD Size 2 1 50 0.2842 In D2:
=CONFIDENCE.T(0.05, A2, B2)→ 0.2842
Common mistakes
- A sample of one. One value has no spread to work from: #DIV/0!.
CONFIDENCE.T in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: CONFIDENCE.T
- Danish: KONFIDENST
- Dutch: VERTROUWELIJKHEID.T
- Finnish: LUOTTAMUSVÄLI.T
- French: INTERVALLE.CONFIANCE.STUDENT
- German: KONFIDENZ.T
- Hungarian: MEGBÍZHATÓSÁG.T
- Italian: CONFIDENZA.T
- Norwegian: KONFIDENS.T
- Polish: UFNOŚĆ.T
- Portuguese (Brazil): INT.CONFIANÇA.T
- Portuguese (Portugal): INT.CONFIANÇA.T
- Russian: ДОВЕРИТ.СТЬЮДЕНТ
- Spanish: INTERVALO.CONFIANZA.T
- Swedish: KONFIDENS.T
- Turkish: GÜVENİLİRLİK.T
Try CONFIDENCE.T in the playground
Related functions
- CONFIDENCE.NORM: The margin of error for an average: add and subtract it to get the confidence interval.
- T.INV.2T: The t-value with a given share of the distribution beyond it, counting both tails. This is the critical value of a two-sided test.
- STDEV: Standard deviation of a sample.