CONFIDENCE.NORM

The CONFIDENCE.NORM function returns the confidence interval for the mean value of a sample from a population, using a normal 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.NORM(
    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.NORM 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, or the sample size is less than 1, the function also returns the #NUM! 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 is given by the following measure:

Intervalo de confianza = CONFIDENCE.NORM(0,05, 4, 100)

Confidence interval
Related functions
Category
Statistical
Submitted by admin on Sat, 07/20/2019 - 11:40