UNISTAT - the ultimate Excel statistics add-in

Heterogeneity of Regression Test in Excel with Unistat

The Unistat statistics add-in extends Excel with Heterogeneity of Regression Test capabilities.

Further documentation is available at section 7.4.5 of the manual, Heterogeneity of Regression.

Sample output

Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.

Heterogeneity of Regression Test

Test Results

X Axis: Age, Dependent Variable: Capacity, classified by Age Group

Regression	Cases	Intercept	Slope	Residual SS	R-DF
1	12	8.1834	-0.0851	5.1311	10
2	28	6.2300	-0.0465	7.6050	26
3	44	5.6803	-0.0306	14.7991	42
Pooled	*	*	*	27.5352	78
Common	84	6.0048	-0.0398	30.0347	80
Total	84	6.0333	-0.0405	30.1964	82

Null hypothesis: All slopes are equal
F(2,78)	3.5402
Right-Tail Probability	0.0338
Null hypothesis: All intercepts are equal
F(2,80)	0.2153
Right-Tail Probability	0.8067
Null hypothesis: All regressions are identical
F(4,78)	1.8846
Right-Tail Probability	0.1215

Multiple comparisons for slopes

Method: 95% Tukey-HSD interval.
** denotes significantly different pairs.
A pairwise test result is significant if its q stat value is greater than the table q.

Group	SSQ(x)	Slope	1	3
1	912.2500	-0.0851		**	\|
2	2282.7143	-0.0465			\|\|
3	6197.1591	-0.0306	**		\|

Comparison	Difference	Standard Error	q Stat	Table q	Significance	Lower 95%	Upper 95%	Result
3 - 1	0.0545	0.0146	3.7276	3.3765	0.0269	0.0051	0.1039	**
2 - 1	0.0386	0.0161	2.3890	3.3765	0.2155	-0.0159	0.0931
3 - 2	0.0159	0.0101	1.5771	3.3765	0.5075	-0.0182	0.0500

Multiple comparisons for intercepts

Method: 95% Tukey-HSD interval.
** denotes significantly different pairs.
A pairwise test result is significant if its q stat value is greater than the table q.

Group	Cases	Intercept
1	12	5.9630	\|
2	28	6.0013	\|
3	44	6.0729	\|

Comparison	Difference	Standard Error	q Stat	Table q	Significance	Lower 95%	Upper 95%
3 - 1	0.1099	0.1428	0.7698	3.3765	0.8497	-0.3723	0.5922
2 - 1	0.0383	0.1669	0.2297	3.3765	0.9856	-0.5252	0.6018
3 - 2	0.0716	0.1001	0.7156	3.3765	0.8686	-0.2663	0.4095

Multiple comparisons for slopes

Method: 95% Dunnett interval.
Control Group: 1, Two-Tailed Test
** denotes significantly different pairs.
A pairwise test result is significant if its q stat value is greater than the table q.

Group	SSQ(x)	Slope	1
1	912.2500	-0.0851		\|
2	2282.7143	-0.0465		\|
3	6197.1591	-0.0306	**	\|

Comparison	Difference	Standard Error	q Stat	Table q	Significance	Lower 95%	Upper 95%	Result
3 - 1	0.0545	0.0207	2.6358	2.1922	0.0168	0.0092	0.0998	**
2 - 1	0.0386	0.0228	1.6893	2.1922	0.1442	-0.0115	0.0886

Multiple comparisons for intercepts

Method: 95% Dunnett interval.
Control Group: 1, Two-Tailed Test
** denotes significantly different pairs.
A pairwise test result is significant if its q stat value is greater than the table q.

Group	Cases	Intercept
1	12	5.9630	\|
2	28	6.0013	\|
3	44	6.0729	\|

Comparison	Difference	Standard Error	q Stat	Table q	Significance	Lower 95%	Upper 95%	Result
3 - 1	0.1099	0.2020	0.5443	2.2066	0.7704	-0.3357	0.5556
2 - 1	0.0383	0.2360	0.1624	2.2066	0.9755	-0.4825	0.5591

DownloadUnistat 6.0
For Windows