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 z_{c} 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 t_{c} and then multiply by standard error of the mean as shown in the equation] | |
Determining t_{c} from a and the degrees of freedom df. | =TINV(a,df) | |
Calculate a confidence interval for a population mean m from a sample mean and an error tolerance E | -E<m<+E |