Skip to Content

CONFIDENCE.NORM

Returns the confidence interval for a population mean, using a normal distribution

Syntax

CONFIDENCE.NORM(alpha, standard_dev, size)

Parameters

  • alpha: Required. The significance level
  • standard_dev: Required. The population standard deviation
  • size: Required. The sample size

Example

=CONFIDENCE.NORM(0.05, 2.5, 50)
Returns: NumberSince: Excel 2010