| Statistic | Equations | Excel |
|---|---|---|
| Square root | =SQRT(number) | |
| Sample size | n | =COUNT(data) |
| Sample mean | =AVERAGE(data) | |
| Population mean | m x P(x) |
=AVERAGE(data) |
| Sample standard deviation | sx |
=STDEV(data) |
| Population standard deviation | s |
=STDEVP(data) |
| Slope | =SLOPE(y data, x data) | |
| Intercept | =INTERCEPT(y data, x data) | |
| Correlation | =CORREL(y data, x data) | |
| Find a probability p from a z value | =NORMSDIST(z) | |
| Find a z value from a probability p | =NORMSINV(p) | |
| Standard error of the population mean | ||
| Standard error of the sample mean | ||
| Determining the z-statistic zc from a | =NORMSINV(1-a/2) | |
| Error tolerance E of a mean for n ³ 30 using s | =CONFIDENCE(a,s,n) | |
| Error tolerance E of a mean for n ³ 30 using sx | =CONFIDENCE(a,sx,n) | |
| Error tolerance E of a mean for n < 30. Can also be used for n ³ 30. | [no Excel function, determine tc and then multiply by standard error of the mean as shown in the equation] | |
| Determining tc from a and the degrees of freedom df. | =TINV(a,df) | |
| Calculate a confidence interval for a population mean m from
a sample mean |
