CONFIDENCE.NORM (Alpha, StandardDeviation, Size) CONFIDENCE.NORM (Alpha; StandardDeviation; Size)
Alpha
Number Number
The significance level, which determines the desired confidence level.
StandardDeviation
Number Number
The (known) standard deviation of the population.
Size
Number Number
The size of the sample.
Returns
Number Number
The margin of error of the mean of a population.
Returns the margin of error of the mean of a population, given the standard deviation of the population and the size of a sample. The confidence interval extends this far on either side of the mean of the sample. Setting the Alpha parameter to 0.05 gives a 95% confidence interval. This function uses the 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.