| Statistic or Parameter |
Symbol |
Equations |
Excel |
| Basic Statistics |
| Square root |
Ö |
|
=SQRT(number) |
| Sample size |
n |
|
=COUNT(data) |
| Sample mean |
 |
Sx/n |
=AVERAGE(data) |
| Population mean |
µ |
SX/N |
=AVERAGE(populationData) |
| Sample standard deviation |
sx or s |
 |
=STDEV(data) |
| Sample Coefficient of Variation |
CV |
100(sx/) |
=100*STDEV(data)/AVERAGE(data) |
| Linear Regression Statistics |
| Slope |
b |
|
=SLOPE(y data, x data) |
| Intercept |
a |
|
=INTERCEPT(y data, x data) |
| Correlation |
r |
|
=CORREL(y data, x data) |
| Coefficient of Determination |
r² |
|
=(CORREL(y data, x data))^2 |
|
|
|
|
| Normal Statistics |
| Calculate a z value from an x |
z |
=  |
=STANDARDIZE(x, m, s) |
| Calculate an x value from a z |
x |
= s z + m |
= s*z+m |
| Calculate a z-statistic from an x |
z |
 |
=(-µ)/(sx/SQRT(n)) |
| Calculate a t-statistic (tstat) |
t |
 |
=(-µ)/(sx/SQRT(n)) |
| Calculate an x from a z |
|
 |
=m + zc*sx/sqrt(n) |
| Find a probability p from a z value |
|
|
=NORMSDIST(z) |
| Find a z value from a probability p |
|
|
=NORMSINV(p) |
| Confidence interval statistics |
| Degrees of freedom |
df |
= n-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 m from
a sample mean x and an error tolerance E |
|
x-E< m
<x+E |
|
| Hypothesis Testing |
| Calculate t-critical for a two-tailed test |
tc |
|
=TINV(a,df) |
| Calculate t-critical for a one-tailed test |
tc |
|
=TINV(2*a,df) |
| Calculate a p-value from a t-statistic |
p |
|
= TDIST(ABS(tstat),df,#tails) |
