Unistat Statistics Software | Heterogeneity of Regression Test in Excel

Heterogeneity of Regression in Excel with UNISTAT

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

For further information visit UNISTAT User's Guide section 7.4.5. Heterogeneity of Regression.

Here we provide a sample 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	Probability	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	Probability	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	Probability	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	Probability	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