UNISTAT - the ultimate
Excel statistics add-in
Separate Variance t-Test in Excel with Unistat
The Unistat statistics add-in extends Excel with Separate Variance t-Test capabilities.
Further documentation is available at section 6.1.3 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.
Separate Variance t-Test
Data variable: Wages
Subsample selected by: Region
| Region | Cases | Mean | Standard Deviation | Standard Error |
|---|---|---|---|---|
| East | 13 | 102.1769 | 13.2478 | 3.6743 |
| North | 10 | 101.8600 | 14.7329 | 4.6590 |
| Total | 23 | 102.0391 | 13.9037 | 2.8991 |
| t-Statistic | 0.0534 |
|---|---|
| Degrees of Freedom | 18.3524 |
| 2-Tail Probability | 0.9580 |
| Difference between means | 0.3169 |
| 95% Confidence Interval | -11.9528 <> 12.5867 |
Data variable: Energy
Subsample selected by: Region
| Region | Cases | Mean | Standard Deviation | Standard Error |
|---|---|---|---|---|
| East | 13 | 101.9300 | 15.2888 | 4.2404 |
| North | 10 | 101.6110 | 15.3486 | 4.8537 |
| Total | 23 | 101.7913 | 15.3145 | 3.1933 |
| t-Statistic | 0.0495 |
|---|---|
| Degrees of Freedom | 19.4733 |
| 2-Tail Probability | 0.9610 |
| Difference between means | 0.3190 |
| 95% Confidence Interval | -13.1413 <> 13.7793 |