Pooled Two Sample T Test Formula. Then our t score formula works just fine. Therefore this pooled variance t procedure might not be the most adequate for the situation.
Stderr pooled r1 r2 b pooled standard error of the samples defined by ranges r1 and r2. This is typically done with a two sample t test. T x 1 x 2 μ 1 μ 2 s p 2 1 n 1 1 n 2 t frac overline x 1 overline x 2 mu 1 mu 2 sqrt s p 2 frac 1 n 1 frac 1 n 2 t s p 2 n 1 1 n 2 1 x 1 x 2 μ 1 μ 2.
Pooled variance t procedure in ms excel.
If the p value that corresponds to the test statistic t with n1 n2 1 degrees of freedom is less than your chosen significance level common choices are 0 10 0 05 and 0 01 then you can reject the null hypothesis. T x y μ x μ y s p 1 n 1 m t n m 2. If the p value that corresponds to the test statistic t with n1 n2 1 degrees of freedom is less than your chosen significance level common choices are 0 10 0 05 and 0 01 then you can reject the null hypothesis. In excel we run a t test.
