CONFIDENCE.T function
Returns the confidence interval for a population mean, using a Student's t distribution
Syntax
CONFIDENCE.T(alpha, standard_dev, size)Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| alpha | Yes | 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.0.05 |
| standard_dev | Yes | The population standard deviation for the data range and is assumed to be known.2.5 |
| size | Yes | The sample size.50 |
Try CONFIDENCE.T
Recognize the one-observation t margin boundary
=CONFIDENCE.T(A2,B2,C2)A sample size of one supplies zero degrees of freedom. Microsoft documents a division error for this CONFIDENCE.T input, rather than a zero-width mean interval.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
CONFIDENCE.T · top-level call
=CONFIDENCE.T(A2,B2,C2)1 / 3 · alpha
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.
CONFIDENCE.T reference ↗Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.