Science courses at the national campus Fall 2001 and Spring 2002 had an overall mean grade µ = 2.103
Five hundred and eight (508) female students in science courses at the national campus Fall 2001 and Spring 2002 had a mean grade point x = 2.000 with a standard deviation sx = 1.221. At an alpha a = 0.05, is the female student mean grade point statistically significantly different than the overall mean grade point in science courses at the national campus Fall 2001 and Spring 2002? Use a two-tailed test.
Statistic or Parameter | Symbol | Equations | Excel |
---|---|---|---|
Confidence interval statistics | |||
Degrees of freedom | df | = n-1 | =COUNT(data)-1 | Hypothesis Testing |
Calculate a t-statistic t | t | ||
Calculate t-critical for a two-tailed test | tc | =TINV(a,df) | |
Calculate a p-value from a t-statistic (2 tail) | p | = TDIST(ABS(tstat),df,2) |