Scribd
Upload
11 views12 pages

Regression Analysis of Variables x1 and x2

The document contains the output of a regression analysis with the following key results: 1) A regression model was created with variable x1_total to predict variable y_total. This model had an R-square value of 0.536, indicating it explains over 50% of the variance in y_total. 2) A second regression model was created using variable x2_total, which had a lower R-square value of 0.423. 3) A third model included both x1_total and x2_total and had the highest R-square value of 0.536, suggesting it may be the best fitting regression model based on the data analyzed.

Uploaded by

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

Regression Analysis of Variables x1 and x2

The document contains the output of a regression analysis with the following key results: 1) A regression model was created with variable x1_total to predict variable y_total. This model had an R-square value of 0.536, indicating it explains over 50% of the variance in y_total. 2) A second regression model was created using variable x2_total, which had a lower R-square value of 0.423. 3) A third model included both x1_total and x2_total and had the highest R-square value of 0.536, suggesting it may be the best fitting regression model based on the data analyzed.

Uploaded by

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

Regression

Variables Entered/Removedb

Mode Variables Variables


l Entered Removed Method
1 x1_totala . Enter
a. All requested variables entered.
b. Dependent Variable: y_total

Model Summaryb

Mode Adjusted R Std. Error of


l R R Square Square the Estimate
1 .732 a .536 .526 2.314
a. Predictors: (Constant), x1_total
b. Dependent Variable: y_total

ANOVAb

Sum of
Model Squares df Mean Square F Sig.
1 Regression 297.002 1 297.002 55.454 .000 a
Residual 257.078 48 5.356
Total 554.080 49
a. Predictors: (Constant), x1_total
b. Dependent Variable: y_total

Coefficientsa

Standardized
Unstandardized Coefficients Coefficients Collinearity Statistics
Model B Std. Error Beta t Sig. Tolerance VIF
1 (Constant) 7.958 4.219 1.886 .065
x1_total .761 .102 .732 7.447 .000 1.000 1.000
a. Dependent Variable: y_total

Collinearity Diagnosticsa

Variance Proportions
Dime
Mode nsio Condition
l n Eigenvalue Index (Constant) x1_total
1 1 1.997 1.000 .00 .00
2 .003 25.742 1.00 1.00
a. Dependent Variable: y_total
Residuals Statisticsa

Minimum Maximum Mean Std. Deviation N


Predicted Value 34.58 44.47 39.28 2.462 50
Std. Predicted Value -1.909 2.107 .000 1.000 50
Standard Error of
Predicted Value .328 .770 .446 .124 50
Adjusted Predicted Value 34.64 45.64 39.30 2.483 50
Residual -9.467 3.857 .000 2.291 50
Std. Residual -4.091 1.667 .000 .990 50
Stud. Residual -4.338 1.684 -.004 1.021 50
Deleted Residual -10.645 3.936 -.017 2.439 50
Stud. Deleted Residual -5.505 1.717 -.029 1.136 50
Mahal. Distance .003 4.439 .980 1.185 50
Cook's Distance .000 1.170 .034 .164 50
Centered Leverage Value .000 .091 .020 .024 50
a. Dependent Variable: y_total

Charts
Scatterplot

Dependent Variable: y_total

2
Regression Studentized Residual

-2

-4

-2 -1 0 1 2 3

Regression Standardized Predicted Value

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

Regression
Variables Entered/Removedb

Mode Variables Variables


l Entered Removed Method
1 x2_totala . Enter
a. All requested variables entered.
b. Dependent Variable: y_total

Model Summaryb

Mode Adjusted R Std. Error of


l R R Square Square the Estimate
1 .650 a .423 .411 2.581
a. Predictors: (Constant), x2_total
b. Dependent Variable: y_total

ANOVAb

Sum of
Model Squares df Mean Square F Sig.
1 Regression 234.246 1 234.246 35.155 .000 a
Residual 319.834 48 6.663
Total 554.080 49
a. Predictors: (Constant), x2_total
b. Dependent Variable: y_total

Coefficientsa

Standardized
Unstandardized Coefficients Coefficients Collinearity Statistics
Model B Std. Error Beta t Sig. Tolerance VIF
1 (Constant) 13.724 4.326 3.173 .003
x2_total .629 .106 .650 5.929 .000 1.000 1.000
a. Dependent Variable: y_total

Collinearity Diagnosticsa

Variance Proportions
Dime
Mode nsio Condition
l n Eigenvalue Index (Constant) x2_total
1 1 1.996 1.000 .00 .00
2 .004 23.657 1.00 1.00
a. Dependent Variable: y_total

Residuals Statisticsa

Minimum Maximum Mean Std. Deviation N


Predicted Value 35.12 43.29 39.28 2.186 50
Std. Predicted Value -1.905 1.836 .000 1.000 50
a. Dependent Variable: y_total
Residuals Statisticsa

Minimum Maximum Mean Std. Deviation N


Standard Error of
Predicted Value .367 .792 .498 .138 50
Adjusted Predicted Value 35.13 43.03 39.29 2.174 50
Residual -6.407 3.481 .000 2.555 50
Std. Residual -2.482 1.349 .000 .990 50
Stud. Residual -2.532 1.362 -.002 1.009 50
Deleted Residual -6.669 3.553 -.011 2.655 50
Stud. Deleted Residual -2.692 1.375 -.011 1.028 50
Mahal. Distance .012 3.629 .980 1.151 50
Cook's Distance .000 .131 .020 .027 50
Centered Leverage Value .000 .074 .020 .023 50
a. Dependent Variable: y_total

Charts
Scatterplot

Dependent Variable: y_total

2
Regression Studentized Residual

-1

-2

-3

-2 -1 0 1 2

Regression Standardized Predicted Value

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

Regression
Variables Entered/Removedb

Mode Variables Variables


l Entered Removed Method
1 x2_total, . Enter
x1_totala
a. All requested variables entered.
b. Dependent Variable: y_total

Model Summaryb

Mode Adjusted R Std. Error of


l R R Square Square the Estimate
1 .732 a .536 .516 2.338
a. Predictors: (Constant), x2_total, x1_total
b. Dependent Variable: y_total

ANOVAb

Sum of
Model Squares df Mean Square F Sig.
1 Regression 297.077 2 148.538 27.164 .000 a
Residual 257.003 47 5.468
Total 554.080 49
a. Predictors: (Constant), x2_total, x1_total
b. Dependent Variable: y_total

Coefficientsa

Standardized
Unstandardized Coefficients Coefficients Collinearity Statistics
Model B Std. Error Beta t Sig. Tolerance VIF
1 (Constant) 7.985 4.269 1.870 .068
x1_total .785 .232 .756 3.390 .001 .199 5.035
x2_total -.025 .216 -.026 -.117 .907 .199 5.035
a. Dependent Variable: y_total

Collinearity Diagnosticsa

Variance Proportions
Dime
Mode nsio Condition
l n Eigenvalue Index (Constant) x1_total x2_total
1 1 2.995 1.000 .00 .00 .00
2 .004 26.769 .95 .03 .08
3 .001 66.365 .05 .97 .92
a. Dependent Variable: y_total
Residuals Statisticsa

Minimum Maximum Mean Std. Deviation N


Predicted Value 34.60 44.55 39.28 2.462 50
Std. Predicted Value -1.902 2.139 .000 1.000 50
Standard Error of
Predicted Value .352 1.247 .540 .192 50
Adjusted Predicted Value 34.66 46.88 39.34 2.549 50
Residual -9.548 3.871 .000 2.290 50
Std. Residual -4.083 1.655 .000 .979 50
Stud. Residual -4.555 1.674 -.012 1.035 50
Deleted Residual -11.881 3.961 -.061 2.568 50
Stud. Deleted Residual -6.029 1.708 -.044 1.184 50
Mahal. Distance .131 12.951 1.960 2.385 50
Cook's Distance .000 1.689 .044 .238 50
Centered Leverage Value .003 .264 .040 .049 50
a. Dependent Variable: y_total

Charts
Scatterplot

Dependent Variable: y_total

2
Regression Studentized Residual

-2

-4

-2 -1 0 1 2 3

Regression Standardized Predicted Value

NPAR TESTS
/K-S(NORMAL)=x1_total x2_total y_total
/MISSING ANALYSIS.

NPar Tests
One-Sample Kolmogorov-Smirnov Test

x1_total x2_total y_total


N 50 50 50
Normal Mean 41.18 40.62 39.28
Parameters a
Std. Deviation 3.237 3.475 3.363
a. Test distribution is Normal.
One-Sample Kolmogorov-Smirnov Test

x1_total x2_total y_total


Most Extreme Differences Absolute .092 .149 .135
Positive .092 .091 .091
Negative -.088 -.149 -.135
Kolmogorov-Smirnov Z .649 1.055 .958
Asymp. Sig. (2-tailed) .793 .216 .318
a. Test distribution is Normal.

MEANS TABLES=y_total BY x1_total x2_total


/STATISTICS LINEARITY.

Means
Case Processing Summary

Cases
Included Excluded Total
N Percent N Percent N Percent
y_total * x1_total 50 100.0% 0 .0% 50 100.0%
y_total * x2_total 50 100.0% 0 .0% 50 100.0%

y_total * x1_total
Report

y_total
Mean N Std. Deviation
35 34.00 2 .000
36 34.33 3 1.155
37 34.00 2 .000
38 37.00 5 1.225
39 39.00 2 2.828
40 39.86 7 .900
41 39.00 5 3.873
42 38.33 6 1.506
43 41.25 4 1.708
Report

y_total
Mean N Std. Deviation
44 42.11 9 .601
46 44.33 3 1.155
48 40.50 2 7.778
Total 39.28 50 3.363

ANOVA Table

Sum of
Squares df Mean Square
y_total * x1_total Between Groups (Combined) 386.417 11 35.129
Linearity 297.002 1 297.002
Deviation from Linearity 89.416 10 8.942
Within Groups 167.663 38 4.412
Total 554.080 49

ANOVA Table

F Sig.
y_total * x1_total Between Groups (Combined) 7.962 .000
Linearity 67.314 .000
Deviation from Linearity 2.027 .058
Within Groups
Total

Measures of Association

R R Squared Eta Eta Squared


y_total * x1_total .732 .536 .835 .697

y_total * x2_total
Report

y_total
Mean N Std. Deviation
34 34.20 5 .837
36 37.00 3 1.732
37 35.50 4 1.732
38 40.00 1 .
39 41.00 1 .
40 39.83 6 .983
41 40.00 9 3.000
Report

y_total
Mean N Std. Deviation
42 41.33 3 2.082
43 41.88 8 1.246
44 36.50 4 1.000
45 41.50 4 4.041
46 43.00 1 .
47 46.00 1 .
Total 39.28 50 3.363

ANOVA Table

Sum of
Squares df Mean Square
y_total * x2_total Between Groups (Combined) 387.905 12 32.325
Linearity 234.246 1 234.246
Deviation from Linearity 153.659 11 13.969
Within Groups 166.175 37 4.491
Total 554.080 49

ANOVA Table

F Sig.
y_total * x2_total Between Groups (Combined) 7.197 .000
Linearity 52.157 .000
Deviation from Linearity 3.110 .005
Within Groups
Total

Measures of Association

R R Squared Eta Eta Squared


y_total * x2_total .650 .423 .837 .700

You might also like