CONFIDENCE.NORM function
CONFIDENCE.NORM returns the plus-or-minus amount to put around a sample mean for a confidence interval when the population standard deviation is known. Alpha is the miss rate, such as 0.05.
Example
Read it as a sentence: find the margin of error at the 0.05 significance level for a standard deviation of 2.5 and a sample of 50.
A
B
C
D
1
0.692951912
2
3
Syntax
CONFIDENCE.NORM(alpha, standard_dev, size)
-
alpha(required) - Significance level, e.g. 0.05 for 95% confidence.
-
standard_dev(required) - Known population standard deviation.
-
size(required) - Sample size.
Returns: The margin of error for a mean, using the normal distribution.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=CONFIDENCE.NORM(0.05,2.5,50) | 0.692951912 | Working example |
=CONFIDENCE.NORM("0.05",2.5,50) | 0.692951912 | Text-number in first arg |
=CONFIDENCE.NORM({0.05,0.05},2.5,50) | 0.692951912 | Array in first arg (lifts, spills) |
=CONFIDENCE.NORM(0.05,2.5,1) | 4.899909961 | Size 1 |
=CONFIDENCE.NORM(0.05,2.5,50.9) | 0.692951912 | Fractional size truncated |
=CONFIDENCE.NORM("abc",2.5,50) | #VALUE! | Non-numeric text in first arg |
=CONFIDENCE.NORM(NA(),2.5,50) | #N/A | Error in first arg |
=CONFIDENCE.NORM(0,2.5,50) | #NUM! | Alpha 0 |
Watch out for
- alpha is the miss rate (0.05), not the confidence level (0.95).
- Assumes a known standard deviation; use CONFIDENCE.T otherwise.
- It returns only the margin, not the interval; add and subtract it from the mean.
Where it works
- Excel
- CONFIDENCE.NORM arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .