Unistat Statistics Software | t-Tests and F-Tests in Excel

t- and F-Tests in Excel with UNISTAT

The UNISTAT statistics add-in extends Excel with t- and F-Tests capabilities.

For further information visit UNISTAT User's Guide section 6.1.1. t- and F-Tests.

Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.

For CA and HB
Subsample selected by: Gender = Male

	Difference	Standard Error	t-Statistic	Degrees of Freedom	1-Tail Probability	2-Tail Probability	Lower 95%	Upper 95%
Mean(CA) – 0	10.2759	0.2803	36.6614	28.0000	0.0000	0.0000	9.7017	10.8500
Mean(HB) – 0	10.9621	0.4928	22.2426	28.0000	0.0000	0.0000	9.9525	11.9716
Pooled Variance	-0.6862	0.5670	-1.2103	56.0000	0.1156	0.2312	-1.8220	0.4496
Separate Variance	-0.6862	0.5670	-1.2103	44.3976	0.1163	0.2326	-1.8286	0.4562
Paired	-0.6862	0.5368	-1.2782	28.0000	0.1058	0.2117	-1.7859	0.4135

	F-Statistic	d.f. Numerator	d.f. Denominator	Right-Tail Probability	2-Tail Probability	Lower 95%	Upper 95%
F-Test	3.0917	28	28	0.0019	0.0039	1.4515	6.5851
Levene’s F Test	10.7675	1	56		0.0018

For CA and HB
Subsample selected by: Gender = Female

	Difference	Standard Error	t-Statistic	Degrees of Freedom	1-Tail Probability	2-Tail Probability	Lower 95%	Upper 95%
Mean(CA) – 0	9.4211	0.2791	33.7609	18.0000	0.0000	0.0000	8.8348	10.0073
Mean(HB) – 0	9.1684	0.6205	14.7768	18.0000	0.0000	0.0000	7.8649	10.4720
Pooled Variance	0.2526	0.6803	0.3713	36.0000	0.3563	0.7126	-1.1271	1.6324
Separate Variance	0.2526	0.6803	0.3713	24.9956	0.3568	0.7135	-1.1485	1.6538
Paired	0.2526	0.6380	0.3960	18.0000	0.3484	0.6968	-1.0877	1.5929

	F-Statistic	d.f. Numerator	d.f. Denominator	Right-Tail Probability	2-Tail Probability	Lower 95%	Upper 95%
F-Test	4.9438	18	18	0.0007	0.0014	1.9047	12.8321
Levene’s F Test	9.0816	1	36		0.0047

Data variable: CA
Subsample selected by: Gender = Male,Female

	Valid Cases	Mean	Standard Deviation	Difference	Standard Error	t-Statistic	Degrees of Freedom	1-Tail Probability	2-Tail Probability	Lower 95%	Upper 95%
Mean(Male) – 0	29	10.2759	1.5094	10.2759	0.2803	36.6614	28.0000	0.0000	0.0000	9.7017	10.8500
Mean(Female) – 0	19	9.4211	1.2164	9.4211	0.2791	33.7609	18.0000	0.0000	0.0000	8.8348	10.0073
Pooled Variance			1.4021	0.8548	0.4138	2.0657	46.0000	0.0223	0.0445	0.0218	1.6878
Separate Variance				0.8548	0.3955	2.1613	43.9098	0.0181	0.0362	0.0577	1.6520

	Variance 1	Variance 2	F-Statistic	d.f. Numerator	d.f. Denominator	Right-Tail Probability	2-Tail Probability	Lower 95%	Upper 95%
F-Test	2.2783	1.4795	1.5399	28	18	0.1712	0.3424	0.6256	3.4962
Levene’s F Test			0.7562	1	46		0.3890

Data variable: HB
Subsample selected by: Gender = Male,Female

	Valid Cases	Mean	Standard Deviation	Difference	Standard Error	t-Statistic	Degrees of Freedom	1-Tail Probability	2-Tail Probability	Lower 95%	Upper 95%
Mean(Male) – 0	29	10.9621	2.6540	10.9621	0.4928	22.2426	28.0000	0.0000	0.0000	9.9525	11.9716
Mean(Female) – 0	19	9.1684	2.7045	9.1684	0.6205	14.7768	18.0000	0.0000	0.0000	7.8649	10.4720
Pooled Variance			2.6739	1.7936	0.7892	2.2727	46.0000	0.0139	0.0278	0.2051	3.3822
Separate Variance				1.7936	0.7924	2.2636	38.1230	0.0147	0.0294	0.1897	3.3976

	Variance 1	Variance 2	F-Statistic	d.f. Numerator	d.f. Denominator	Right-Tail Probability	2-Tail Probability	Lower 95%	Upper 95%
F-Test	7.0439	7.3145	1.0384	18	28	0.4528	0.9056	0.4574	2.5559
Levene’s F Test			0.0199	1	46		0.8885