CONFIDENCE

Calculates the width of half the confidence interval for a normal distribution.

Sample Usage

CONFIDENCE(0.05,1.6,250)

CONFIDENCE(A2,A3,A4)

Syntax

CONFIDENCE(alpha, standard_deviation, pop_size)

  • alpha - One minus the desired confidence level. E.g. 0.1 for 0.9, or 90%, confidence.

  • standard_deviation - The standard deviation of the population.

  • pop_size - The size of the population.

Notes

  • CONFIDENCE calculates the width of half the confidence interval such that a value picked at random from the data set has 1-alpha probability of lying within the mean plus or minus the result of CONFIDENCE.

See Also

ZTEST: Returns the one-tailed P-value of a Z-test with standard distribution.

Examples

Was this article helpful?
How can we improve it?