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.