CONFIDENCE.NORM Function

Returns the margin of error for a mean, using the normal distribution.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice CONFIDENCE.NORM in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

CONFIDENCE.NORM returns the ± margin around a sample average: the confidence interval is average − margin to average + margin. alpha is 1 minus the confidence level, so 0.05 means 95% confidence.

It assumes the standard deviation is known (or the sample is large). For small samples where you estimate the standard deviation, use CONFIDENCE.T.

Syntax

=CONFIDENCE.NORM(alpha, standard_dev, size) Explain

Arguments

ArgumentRequired?What it does
alphaYes1 − confidence level, such as 0.05 for 95%.
standard_devYesThe population standard deviation; must be greater than 0.
sizeYesThe sample size; at least 1.

Examples

Example 1 — Average call length ± margin

40 calls averaged 6.2 minutes; the standard deviation of call length is 1.5 minutes.

B5fx=CONFIDENCE.NORM(0.05,B3,B4)
AB
1MeasureValue
2Average6.2
3Std deviation1.5
4Calls40
5Margin (95%)0.46
6Low5.74
7High6.66
=CONFIDENCE.NORM(0.05,B3,B4) Explain

We can be 95% confident the true average call is between about 5.74 and 6.66 minutes.

Common mistakes

  • alpha, not confidence. Pass 0.05 for 95%, not 0.95.
  • #NUM! alpha is 0 or less or 1 or more, standard_dev is 0 or negative, or size is less than 1.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.