How to Use CONFIDENCE.NORM in Google Sheets in 2020?

CONFIDENCE.NORMCalculates the width of half the confidence interval for a normal distribution.

Sample Usage




CONFIDENCE.NORM(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.


CONFIDENCE.NORM 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.NORM.
You can use CONFIDENCE or CONFIDENCE.NORM to perform this function.

See Also

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