CONFIDENCE

Description

The CONFIDENCE function returns a value for creating a statistical confidence interval for a sample of a specified size from a population with a known standard deviation. The confidence estimate assumes that values in the sample are normally distributed.

Syntax

CONFIDENCE(alpha, stdev, size)

  • alpha: The probability that the true population value lies outside the interval. So, 1 minus alpha is the confidence level that the true population value lies within the interval centered on the sample value. An alpha of 0.05 corresponds to a confidence
    level of 0.95, or 95%.
  • stdev: The standard deviation of the population.
  • size: The size of the sample.

Examples


CONFIDENCE