CONFIDENCE.T

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.

Syntax

CONFIDENCE.T(
    alpha,
    standard_dev,
    size
)

Parameters
  • 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.
Returned value

The CONFIDENCE.T function returns a real number.

Additional Information

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.

Examples

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)

CONFIDENCE.T function
Related functions
Category
Statistical
Submitted by admin on Sat, 07/20/2019 - 13:49