CONFIDENCE.NORM function
CONFIDENCE.NORM(alpha, standardDeviation, size) CONFIDENCE.NORM(alpha; standardDeviation; size)
alpha
Number or { Number }
The significance level, which determines the desired confidence level.
standardDeviation
Number or { Number }
The (known) standard deviation of a normal distribution.
size
Number or { Number }
The size of a sample from a distribution.
Returns
Number or { Number }
A confidence interval for a normal distribution.
Returns a confidence interval for a normal distribution.
Examples
CONFIDENCE.NORM(0.05, 2.5,
50)CONFIDENCE.NORM(0,05;
2,5; 50)
Returns roughly 0.69.
CONFIDENCE.NORM(0.05, 1.5,
100)CONFIDENCE.NORM(0,05;
1,5; 100)
Returns roughly 0.29.