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
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
Arguments
| Argument | Required? | What it does |
|---|---|---|
| alpha | Yes | 1 − confidence level, such as 0.05 for 95%. |
| standard_dev | Yes | The population standard deviation; must be greater than 0. |
| size | Yes | The 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.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | Average | 6.2 |
| 3 | Std deviation | 1.5 |
| 4 | Calls | 40 |
| 5 | Margin (95%) | 0.46 |
| 6 | Low | 5.74 |
| 7 | High | 6.66 |
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
- CONFIDENCE.NORM replaces the older CONFIDENCE function.
- Related functions: CONFIDENCE.T, NORM.S.INV, STDEV.S.

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.