Friday, December 10, 2010
We calculate the t stat by subtracting the hypothesised mean from the sample mean, and then dividing by the standard error. Now it can happen that the hypothesised mean is larger than the sample mean. The result is that the t stat is negative. That is OK. But when you put it into Excel, just type the t stat as an absolute value (that means drop the negative sign).