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.