Question

Run a multiple linear regression in SPSS, create a series of tables that depict the results. Test for multicollinearity in SPSS format a table and discuss findings.

stats	gcse
1	1
1	1
1	3
2	3
2	3
2	4
2	5
3	1
3	2
3	3
3	3
3	4
3	4
4	2
4	2
4	2
5	3
5	3
5	5
5	6
6	4
6	5
6	4
6	4
6	4

Answer 1

Answer:

Given Table,

Stats	gcse
1	1
1	1
1	3
2	3
2	3
2	4
2	5
3	1
3	2
3	3
3	3
3	4
3	4
4	2
4	2
4	2
5	3
5	3
5	5
5	6
6	4
6	5
6	4
6	4
6	4

Steps in SPSS:

Analyze--->Regression--->Linear--->Statistics--->Collinearity diagnostics:

Model	Un standardized Coefficient		Standardized Coefficient	t	sig.	Collinearity Statistics
	B	Std. Error	Beta			Tolerance	VIF
1 (Constant) stats	1.875	.572	.480	3.277	.003	1.000	1.000
	.375	.143		2.625	.015

Dependent Variable :gcse

To check Multi-Collinearity use VIF(Variance Inflation Factor).

If the VIF is equal to 1 there is no multi-Collinearity among factors.