Calculates the width of half the confidence interval for a normal distribution.
Sample Usage
CONFIDENCE.NORM(0.05,1.6,250)
CONFIDENCE.NORM(A2,A3,A4)
Syntax
CONFIDENCE.NORM(alpha, standard_deviation, pop_size)
alpha- One minus the desired confidence level. E.g.0.1for0.9, or 90%, confidence.standard_deviation- The standard deviation of the population.pop_size- The size of the population.
Notes
CONFIDENCE.NORMcalculates the width of half the confidence interval such that a value picked at random from the data set has1-alphaprobability of lying within the mean plus or minus the result ofCONFIDENCE.NORM.- You can use
CONFIDENCEorCONFIDENCE.NORMto perform this function.
See Also
ZTEST: Returns the one-tailed P-value of a Z-test with standard distribution.