The CONFIDENCE.T function returns the confidence interval for the mean value of a sample of a population, using a Student's t distribution, given an alpha confidence value.
The function returns a real number x, with the associated confidence interval being given by the range [mean value - x, mean value + x]. This means that, for any sample in the population, the probability of obtaining a sample mean further than x from the mean of the original sample will be the alpha value.
CONFIDENCE.T(
alpha,
standard_dev,
size
)
- alpha: Value used to calculate the confidence level. This is calculated as 100*(1-alpha) or, in other words, an alpha value of 0.05 represents a 95% confidence level.
- standard_dev: Standard deviation of the data.
- size: Population size.
The CONFIDENCE.T function returns a real number.
If any of the arguments are not numeric, the function returns the #VALUE! error.
If alpha is less than or equal to 0, or greater than or equal to 1, the function returns the #NUM! error.
If the indicated standard deviation is less than or equal to zero, the function also returns the #NUM! error.
If the sample size equals 1, the function returns a #DIV/0! error.
If the sample size is not a whole number, it is automatically rounded.
Given a set of 100 values whose standard deviation is 4, the 95% confidence interval using a Student's T distribution is given by the following measure:
Intervalo de confianza = CONFIDENCE.T(0,05, 4, 100)