Statistical
CONFIDENCE.T Function in Excel
Returns the confidence interval for a population mean using Student's t-distribution.
Syntax
- =CONFIDENCE.T(alpha, standard_dev, size)
Arguments
- alpha (required): Significance level
- standard_dev (required): Sample standard deviation
- size (required): Sample size
Examples
- =CONFIDENCE.T(0.05, 2.5, 50) - 95% confidence interval (t) - Result: 0.71
CONFIDENCE.T for data analysis
- Confirm whether you need entire columns, filtered subsets, or distinct values.
- Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
- Pivot tables complement single-cell statistical formulas for exploration.
Common errors
- #NUM! if size < 2
Use cases
- Small sample confidence
- Statistical inference
- Research
Frequently asked questions
- What is the CHISQ.INV function in Excel? CHISQ.INV returns the inverse of the chi-squared distribution. Given a probability and degrees of freedom, it returns the critical value for hypothesis testing.
- How do I use CHISQ.INV for hypothesis testing? Use CHISQ.INV to find critical values. For example, =CHISQ.INV(0.95, 3) gives the value where 95% of the distribution falls below, used to determine if your test statistic is significant.
- What's the relationship between CHISQ.DIST and CHISQ.INV? They're inverse functions. If CHISQ.DIST(x, df, TRUE) = p, then CHISQ.INV(p, df) = x. Use them together for complete chi-squared analysis.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.