In the coconut grinding competition a group of n = 36 students took an average of = 3 minutes with a sample standard deviation sx = 1 minute.
Statistic or Parameter | Symbol | Equations | Excel |
---|---|---|---|
Normal Statistics | |||
Calculate a z-statistic from an x | z | =(x - µ)/(sx/SQRT(n)) | |
Calculate a t-statistic (t-stat) | t | =(x - µ)/(sx/SQRT(n)) | |
Calculate an x from a z | =µ + zc*sx/sqrt(n) | ||
Find a probability p from a z value | =NORMSDIST(z) | ||
Find a z value from a probability p | =NORMSINV(p) |