UNISTAT - the ultimate
Excel statistics add-in
Pooled Variance t-Test in Excel with Unistat
The Unistat statistics add-in extends Excel with Pooled Variance t-Test capabilities.
Further documentation is available at section 6.1.2 of the manual, t- and F-Tests.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Pooled Variance t-Test
Subsample selected by: Gender = Female
| Cases | Mean | Standard Deviation | Standard Error | |
|---|---|---|---|---|
| CA | 19 | 9.4211 | 1.2164 | 0.2791 |
| HB | 19 | 9.1684 | 2.7045 | 0.6205 |
| Total | 38 | 9.2947 | 2.0969 | 0.3402 |
| t-Statistic | 0.3713 |
|---|---|
| Degrees of Freedom | 36.0000 |
| 2-Tail Probability | 0.7126 |
| Difference between means | 0.2526 |
| 95% Confidence Interval | -1.1271 <> 1.6324 |
Subsample selected by: Gender = Male
| Cases | Mean | Standard Deviation | Standard Error | |
|---|---|---|---|---|
| CA | 29 | 10.2759 | 1.5094 | 0.2803 |
| HB | 29 | 10.9621 | 2.6540 | 0.4928 |
| Total | 58 | 10.6190 | 2.1590 | 0.2835 |
| t-Statistic | -1.2103 |
|---|---|
| Degrees of Freedom | 56.0000 |
| 2-Tail Probability | 0.2312 |
| Difference between means | -0.6862 |
| 95% Confidence Interval | -1.8220 <> 0.4496 |
Pooled Variance t-Test
Data variable: CA
Subsample selected by: Gender
| Gender | Cases | Mean | Standard Deviation | Standard Error |
|---|---|---|---|---|
| Female | 19 | 9.4211 | 1.2164 | 0.2791 |
| Male | 29 | 10.2759 | 1.5094 | 0.2803 |
| Total | 48 | 9.9375 | 1.4021 | 0.2024 |
| t-Statistic | -2.0657 |
|---|---|
| Degrees of Freedom | 46.0000 |
| 2-Tail Probability | 0.0445 |
| Difference between means | -0.8548 |
| 95% Confidence Interval | -1.6878 <>-0.0218 |
Data variable: HB
Subsample selected by: Gender
| Gender | Cases | Mean | Standard Deviation | Standard Error |
|---|---|---|---|---|
| Female | 19 | 9.1684 | 2.7045 | 0.6205 |
| Male | 29 | 10.9621 | 2.6540 | 0.4928 |
| Total | 48 | 10.2521 | 2.6739 | 0.3859 |
| t-Statistic | -2.2727 |
|---|---|
| Degrees of Freedom | 46.0000 |
| 2-Tail Probability | 0.0278 |
| Difference between means | -1.7936 |
| 95% Confidence Interval | -3.3822 <>-0.2051 |