Scribd
Upload
7 views9 pages

Regression Analysis with Two Predictors

The document describes a regression analysis conducted with the variables Y, X1, and X2. It includes a model summary showing R, R-square, adjusted R-square, and standard error of the estimate. An ANOVA table is presented showing the regression values, residuals, and total values. Finally, coefficients, collinearity statistics, and variance proportions are displayed.

Uploaded by

Arizal Ilhami
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as RTF, PDF, TXT or read online on Scribd
7 views9 pages

Regression Analysis with Two Predictors

The document describes a regression analysis conducted with the variables Y, X1, and X2. It includes a model summary showing R, R-square, adjusted R-square, and standard error of the estimate. An ANOVA table is presented showing the regression values, residuals, and total values. Finally, coefficients, collinearity statistics, and variance proportions are displayed.

Uploaded by

Arizal Ilhami
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as RTF, PDF, TXT or read online on Scribd

REGRESSION

/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA COLLIN TOL
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT Y

/METHOD=ENTER X1 X2.

Regression

Notes

Output Created 10-Feb-2016 09:51:57

Comments

Input Active Dataset DataSet0

Filter <none>

Weight <none>

Split File <none>

N of Rows in Working Data File 174

Missing Value Handling Definition of Missing User-defined missing values are treated as
missing.

Cases Used Statistics are based on cases with no


missing values for any variable used.

Syntax REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
COLLIN TOL
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT Y
/METHOD=ENTER X1 X2.

Resources Processor Time 00:00:00.124

Elapsed Time 00:00:00.106

Memory Required 1628 bytes

Additional Memory Required for


0 bytes
Residual Plots

[DataSet0]

Variables Entered/Removedb
Variables
Model Variables Entered Removed Method

1 X2, X1a . Enter

a. All requested variables entered.

b. Dependent Variable: Y

Model Summary

Std. Error of the


Model R R Square Adjusted R Square Estimate

1 .150a .022 .011 2.909

a. Predictors: (Constant), X2, X1

ANOVAb

Model Sum of Squares df Mean Square F Sig.

1 Regression 33.256 2 16.628 1.965 .143a

Residual 1446.772 171 8.461

Total 1480.029 173

a. Predictors: (Constant), X2, X1

b. Dependent Variable: Y

Coefficientsa

Standardized
Unstandardized Coefficients Coefficients Collinearity Statistics

Model B Std. Error Beta t Sig. Tolerance VIF

1 (Constant) 26.588 3.450 7.706 .000

X1 .114 .096 .091 1.179 .240 .970 1.031

X2 .095 .070 .105 1.365 .174 .970 1.031

a. Dependent Variable: Y

Collinearity Diagnosticsa

Model Eigenvalue Condition Index Variance Proportions


Dimensi
on (Constant) X1 X2

1 1 2.991 1.000 .00 .00 .00

2 .006 22.098 .02 .81 .34

3 .003 33.596 .98 .19 .66

a. Dependent Variable: Y

REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA COLLIN TOL
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT Y
/METHOD=ENTER X1 X2

/SCATTERPLOT=(*SRESID ,*ZPRED).

Regression

Notes

Output Created 10-Feb-2016 09:59:19

Comments

Input Active Dataset DataSet0

Filter <none>

Weight <none>

Split File <none>

N of Rows in Working Data File 174

Missing Value Handling Definition of Missing User-defined missing values are treated as
missing.

Cases Used Statistics are based on cases with no


missing values for any variable used.

Syntax REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
COLLIN TOL
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT Y
/METHOD=ENTER X1 X2
/SCATTERPLOT=(*SRESID ,*ZPRED).

Resources Processor Time 00:00:00.749


Elapsed Time 00:00:00.862

Memory Required 1636 bytes

Additional Memory Required for


232 bytes
Residual Plots

[DataSet0]

Variables Entered/Removedb

Variables
Model Variables Entered Removed Method

1 X2, X1a . Enter

a. All requested variables entered.

b. Dependent Variable: Y

Model Summaryb

Std. Error of the


Model R R Square Adjusted R Square Estimate

1 .150a .022 .011 2.909

a. Predictors: (Constant), X2, X1

b. Dependent Variable: Y

ANOVAb

Model Sum of Squares df Mean Square F Sig.

1 Regression 33.256 2 16.628 1.965 .143a

Residual 1446.772 171 8.461

Total 1480.029 173

a. Predictors: (Constant), X2, X1

b. Dependent Variable: Y

Coefficientsa

Model Unstandardized Coefficients Standardized t Sig. Collinearity Statistics


Coefficients
B Std. Error Beta Tolerance VIF

1 (Constant) 26.588 3.450 7.706 .000

X1 .114 .096 .091 1.179 .240 .970 1.031

X2 .095 .070 .105 1.365 .174 .970 1.031

a. Dependent Variable: Y

Collinearity Diagnosticsa

Variance Proportions
Dimensi
Model on Eigenvalue Condition Index (Constant) X1 X2

1 1 2.991 1.000 .00 .00 .00

2 .006 22.098 .02 .81 .34

3 .003 33.596 .98 .19 .66

a. Dependent Variable: Y

Residuals Statisticsa

Minimum Maximum Mean Std. Deviation N

Predicted Value 32.06 34.31 33.41 .438 174

Std. Predicted Value -3.085 2.066 .000 1.000 174

Standard Error of Predicted


.222 .931 .363 .120 174
Value

Adjusted Predicted Value 31.78 34.24 33.40 .458 174

Residual -10.896 7.377 .000 2.892 174

Std. Residual -3.746 2.536 .000 .994 174

Stud. Residual -3.788 2.677 .001 1.004 174

Deleted Residual -11.141 8.220 .008 2.951 174

Stud. Deleted Residual -3.946 2.727 .000 1.015 174

Mahal. Distance .013 16.739 1.989 2.280 174

Cook's Distance .000 .273 .007 .024 174

Centered Leverage Value .000 .097 .011 .013 174

a. Dependent Variable: Y

Charts
REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA COLLIN TOL
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT Y
/METHOD=ENTER X1 X2
/SCATTERPLOT=(*SRESID ,*ZPRED)

/RESIDUALS DURBIN.

Regression

Notes

Output Created 10-Feb-2016 10:02:04

Comments

Input Active Dataset DataSet0

Filter <none>

Weight <none>

Split File <none>


N of Rows in Working Data File 174

Missing Value Handling Definition of Missing User-defined missing values are treated as
missing.

Cases Used Statistics are based on cases with no


missing values for any variable used.

Syntax REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
COLLIN TOL
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT Y
/METHOD=ENTER X1 X2
/SCATTERPLOT=(*SRESID ,*ZPRED)
/RESIDUALS DURBIN.

Resources Processor Time 00:00:00.515

Elapsed Time 00:00:00.482

Memory Required 1636 bytes

Additional Memory Required for


232 bytes
Residual Plots

[DataSet0]

Variables Entered/Removedb

Variables
Model Variables Entered Removed Method

1 X2, X1a . Enter

a. All requested variables entered.

b. Dependent Variable: Y

Model Summaryb

Std. Error of the


Model R R Square Adjusted R Square Estimate Durbin-Watson

1 .150a .022 .011 2.909 1.808

a. Predictors: (Constant), X2, X1

b. Dependent Variable: Y
ANOVAb

Model Sum of Squares df Mean Square F Sig.

1 Regression 33.256 2 16.628 1.965 .143a

Residual 1446.772 171 8.461

Total 1480.029 173

a. Predictors: (Constant), X2, X1

b. Dependent Variable: Y

Coefficientsa

Standardized
Unstandardized Coefficients Coefficients Collinearity Statistics

Model B Std. Error Beta t Sig. Tolerance VIF

1 (Constant) 26.588 3.450 7.706 .000

X1 .114 .096 .091 1.179 .240 .970 1.031

X2 .095 .070 .105 1.365 .174 .970 1.031

a. Dependent Variable: Y

Collinearity Diagnosticsa

Variance Proportions
Dimensi
Model on Eigenvalue Condition Index (Constant) X1 X2

1 1 2.991 1.000 .00 .00 .00

2 .006 22.098 .02 .81 .34

3 .003 33.596 .98 .19 .66

a. Dependent Variable: Y

Residuals Statisticsa

Minimum Maximum Mean Std. Deviation N

Predicted Value 32.06 34.31 33.41 .438 174

Std. Predicted Value -3.085 2.066 .000 1.000 174


Standard Error of Predicted
.222 .931 .363 .120 174
Value

Adjusted Predicted Value 31.78 34.24 33.40 .458 174

Residual -10.896 7.377 .000 2.892 174

Std. Residual -3.746 2.536 .000 .994 174

Stud. Residual -3.788 2.677 .001 1.004 174

Deleted Residual -11.141 8.220 .008 2.951 174

Stud. Deleted Residual -3.946 2.727 .000 1.015 174

Mahal. Distance .013 16.739 1.989 2.280 174

Cook's Distance .000 .273 .007 .024 174

Centered Leverage Value .000 .097 .011 .013 174

a. Dependent Variable: Y

Charts

You might also like