Excel functions / Statistics
CONFIDENCE.NORM function
The margin of error for an average: add and subtract it to get the confidence interval.
Syntax
=CONFIDENCE.NORM(alpha, standard_dev, size)
Arguments
alpha: 1 minus the confidence level: 0.05 for 95%.standard_dev: The standard deviation of the population.size: How many were sampled.
When to use it
CONFIDENCE.NORM gives the margin of error of a sample mean, using the normal distribution: the mean plus or minus this is the confidence interval. Give it alpha (0.05 for 95% confidence), the standard deviation and the sample size. For small samples, CONFIDENCE.T is more accurate.
Examples
Margin of error for 50 measurements
A B C D 1 SD Size 2 8 50 2.22 In D2:
=CONFIDENCE.NORM(0.05, A2, B2)→ 2.22Four times the sample, half the margin
A B C D 1 SD Size 2 8 200 1.11 In D2:
=CONFIDENCE.NORM(0.05, A2, B2)→ 1.11
Common mistakes
- Alpha is not the confidence. For 95% confidence, alpha is 0.05, not 0.95.
CONFIDENCE.NORM in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: CONFIDENCE.NORM
- Danish: KONFIDENS.NORM
- Dutch: VERTROUWELIJKHEID.NORM
- Finnish: LUOTTAMUSVÄLI.NORM
- French: INTERVALLE.CONFIANCE.NORMAL
- German: KONFIDENZ.NORM
- Hungarian: MEGBÍZHATÓSÁG.NORM
- Italian: CONFIDENZA.NORM
- Norwegian: KONFIDENS.NORM
- Polish: UFNOŚĆ.NORM
- Portuguese (Brazil): INT.CONFIANÇA.NORM
- Portuguese (Portugal): INT.CONFIANÇA.NORM
- Russian: ДОВЕРИТ.НОРМ
- Spanish: INTERVALO.CONFIANZA.NORM
- Swedish: KONFIDENS.NORM
- Turkish: GÜVENİLİRLİK.NORM
Also written as CONFIDENCE.
Try CONFIDENCE.NORM in the playground
Related functions
- CONFIDENCE.T: The margin of error of a sample mean, using Student's t-distribution. Add it to and subtract it from the mean for the confidence interval.
- NORM.S.INV: The z-score below which a given share of the standard normal distribution falls.
- STDEV: Standard deviation of a sample.
- AVERAGE: The arithmetic mean of the numbers.