In math courses at the national campus Spring 2001 the campuswide population mean grade point average (GPA) µ was 1.613. During the Spring 2001 term at the national campus 15 Yapese male students attained a sample mean GPA x of 1.133 with a standard deviation sx of 1.407 in math courses. For a confidence level of 90%, is the Yapese male math GPA statistically significantly different than the national campus math GPA?
| Statistic or Parameter | Symbol | Equations | Excel | 
|---|---|---|---|
| Basic Statistics | |||
| Square root | Ö | =SQRT(number) | |
| Sample size | n | =COUNT(data) | |
| Sample mean | x | Sx/n | =AVERAGE(data) | 
| Sample standard deviation | sx | =STDEV(data) | |
| Sample Coefficient of Variation | CV | 100(sx/x) | =100*STDEV(data)/AVERAGE(data) | 
| 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 value from an x | z | ![]()  | 
    |
| 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 a t-statistic (tstat) | t | ![]()  | 
    |
| 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) | |