Overview
A 90%, 95% or 99% confidence interval gives a range of plausible values for a population mean, based on your sample.
Enter the sample mean, standard deviation and size, and the confidence code: 1 for 90%, 2 for 95% or 3 for 99%.
Worked examples
| Inputs | Result |
|---|---|
| Sample Mean54.2Sample Standard Deviation12.4Sample Size (n)120Confidence level95% | 95% CI: [51.98, 56.42]Margin of error: 2.22 |
Show 2 more examples
| Sample Mean100Sample Standard Deviation15Sample Size (n)50Confidence level95% | 95% CI: [95.84, 104.16]Margin of error: 4.16 |
| Sample Mean3.2Sample Standard Deviation0.4Sample Size (n)200Confidence level90% | 90% CI: [3.15, 3.25]Margin of error: 0.05 |
How it works
The standard error is s ÷ √n. Multiplying by 1.645, 1.96 or 2.576 gives the margin of error, which is added to and subtracted from the mean. It uses z values, so for samples under about 30 a t-based interval would be slightly wider.
The formula
| x̄ | Sample mean |
| s | Sample standard deviation |
| n | Sample size |
Practical tips
- At 95%, a mean of 54.2 with s = 12.4 and n = 120 gives 51.98 to 56.42.
- Quadrupling the sample halves the width.
- Report the interval along with the sample size and how the sample was taken.
Frequently asked questions
What does the confidence level mean?
If you repeated the sampling many times, that share of intervals built this way would contain the true mean.
Why not always use 99%?
Higher confidence gives a wider, less precise interval.
Should I use t instead of z?
For small samples, yes. In Excel, T.INV.2T gives the t value.