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

CasesMeanStandard DeviationStandard 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

CasesMeanStandard DeviationStandard 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

GenderCasesMeanStandard DeviationStandard 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

GenderCasesMeanStandard DeviationStandard 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


DownloadUnistat 6.0
For Windows