Functions
CONFIDENCE.NORM
Confidence interval half-width (normal)
Try it
When to use it
When should I use CONFIDENCE.NORM?
Use CONFIDENCE.NORM to compute the half-width of a confidence interval when the population standard deviation is known and the sampling distribution is normal — the modern replacement for CONFIDENCE.
Used in
Syntax
CONFIDENCE.NORM(alpha,stdev,size)Examples
=CONFIDENCE.NORM(0.05,1.6,250) // => 0.19833441049735873