Home › Functions › Statistical › CONFIDENCE.T
fx
CONFIDENCE.T
Statistical  ·  Since: Excel 2003  ·  9 languages

Returns the confidence interval for a population mean, using a Student's t distribution.

🌐 Translations

English CONFIDENCE.T
Deutsch KONFIDENZ.T
Français INTERVALLE.CONFIANCE.STUDENT
Español INTERVALO.CONFIANZA.T
Italiano CONFIDENZA.T
Português INT.CONFIANÇA.T
Nederlands VERTROUWELIJKHEID.T
Polski UFNOŚĆ.T
Русский ДОВЕРИТ.СТЬЮДЕНТ

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

CONFIDENCE.T(alpha,standard_dev,size)

Arguments

alpha (required) — The significance level used to compute the confidence level. The confidence level equals 100*(1 - alpha)%, or in other words, an alpha of 0.05 indicates a 95 percent confidence level.
standard_dev (required) — The population standard deviation for the data range and is assumed to be known.
size (required) — The sample size.

▶ Examples

=CONFIDENCE.T(0.05,1,50)

Related functions

Copied to clipboard