CONFIDENCE
Returns the confidence interval for a population mean.
CompatibilityCompatibility / LegacyLegacy / Older Versions
What it does
Returns the confidence interval for a population mean, using a normal distribution (Legacy function).
Syntax
CONFIDENCE(alpha, standard_dev, size)
Arguments
alpha(number) — Significance level (e.g., 0.05 for 95% confidence).standard_dev(number) — Standard deviation of the population.size(number) — Sample size.
Examples
Legacy Confidence
Calculate interval width.
FORMULA
=CONFIDENCE(0.05, 2.5, 50)
RESULT
0.692
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | Alpha | StdDev | Size |
| 2 | 0.05 | 2.5 | 50 |