| Statistic or Parameter |
Symbol |
Equations |
Excel |
| Confidence interval statistics |
| Degrees of freedom |
df |
= n-1 |
=COUNT(data)-1 |
| Find a zc value from a confidence level c |
zc |
|
=ABS(NORMSINV((1-c)/2)) |
| Find a tc value from a confidence level c |
tc |
|
=TINV(1-c,df) |
| Calculate an error tolerance E of a mean for n >= 30 using sx |
E |
 |
=zc*sx/SQRT(n) |
| Calculate an error tolerance E of a mean for n < 30 using sx. Can also be used for n >= 30. |
E |
 |
=tc*sx/SQRT(n) |
| Calculate a confidence interval for a population mean µ from a sample mean x and an error tolerance E |
|
x-E<= µ <=x+E |
|