DATA for regression analysis | ||
bankaccount | income | famnum |
6 | 220 | 5 |
5 | 190 | 6 |
7 | 260 | 3 |
7 | 200 | 4 |
8 | 330 | 2 |
10 | 490 | 4 |
8 | 210 | 3 |
11 | 380 | 2 |
9 | 320 | 1 |
9 | 270 | 3 |
account income fammember Min. : 5 Min. :190.0 Min. :1.00 1st Qu.: 7 1st Qu.:212.5 1st Qu.:2.25 Median : 8 Median :265.0 Median :3.00 Mean : 8 Mean :287.0 Mean :3.30 3rd Qu.: 9 3rd Qu.:327.5 3rd Qu.:4.00 Max. :11 Max. :490.0 Max. :6.00
prediction for y values with | ||
bankaccount | error | error^2 |
6 | -2 | 4 |
5 | -3 | 9 |
7 | -1 | 1 |
7 | -1 | 1 |
8 | 0 | 0 |
10 | 2 | 4 |
8 | 0 | 0 |
11 | 3 | 9 |
9 | 1 | 1 |
9 | 1 | 1 |
Residuals: Min 1Q Median 3Q Max -1.2173 -0.5779 -0.1515 0.6642 1.1906 Coefficients: Estimate Std. Error t value Pr(>|t|) (Intercept) 6.399103 1.516539 4.220 0.00394 ** fammember -0.544727 0.226364 -2.406 0.04702 * income 0.011841 0.003561 3.325 0.01268 * --- Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1 Residual standard error: 0.9301 on 7 degrees of freedom Multiple R-squared: 0.7981, Adjusted R-squared: 0.7404 F-statistic: 13.84 on 2 and 7 DF, p-value: 0.003696
Another X, X2 | |||
bankaccount | pred2 | error2 | error2 |
= error | error2 | ||
6.000 | 6.281 | 0.281 | 0.079 |
5.000 | 5.381 | 0.381 | 0.145 |
7.000 | 7.844 | 0.844 | 0.712 |
7.000 | 6.588 | -0.412 | 0.169 |
8.000 | 9.217 | 1.217 | 1.482 |
10.000 | 10.023 | 0.023 | 0.001 |
8.000 | 7.252 | -0.748 | 0.560 |
11.000 | 9.809 | -1.191 | 1.418 |
9.000 | 9.644 | 0.644 | 0.414 |
9.000 | 7.962 | -1.038 | 1.077 |
SSres | 6.056 | ||
SSreg | 23.944 |
Model Summary(b) | ||||
Model | R | R Square | Adjusted R Square | Std. Error of the Estimate |
1.000 | 0.893 | 0.798 | 0.740 | 0.930 |
a | Predictors: (Constant), bankfam, bankIncome income | |||
b | Dependent Variable: bankbook number of bank |
ANOVA(b) | ||||||
Model | Sum of Squares | df | Mean Square | F | Sig. | |
1.000 | Regression | 23.944 | 2.000 | 11.972 | 13.838 | 0.004 |
Residual | 6.056 | 7.000 | 0.865 | |||
Total | 30.000 | 9.000 | ||||
a | Predictors: (Constant), bankfam, bankIncome income | |||||
b | Dependent Variable: bankbook number of bank of bank |
Coefficients(a) | ||||||
Model | Unstandardized Coefficients | Standardized Coefficients | t | Sig. | ||
B | Std. Error | Beta | ||||
1.000 | (Constant) | 6.399 | 1.517 | 4.220 | 0.004 | |
bankIncome income | 0.012 | 0.004 | 0.616 | 3.325 | 0.013 | |
bankfam | -0.545 | 0.226 | -0.446 | -2.406 | 0.047 | |
a | Dependent Variable: bankbook number of bank |
Variable Labels Variable Position Label snum 1 school number dnum 2 district number api00 3 api 2000 api99 4 api 1999 growth 5 growth 1999 to 2000 meals 6 pct free meals ell 7 english language learners yr_rnd 8 year round school mobility 9 pct 1st year in school acs_k3 10 avg class size k-3 acs_46 11 avg class size 4-6 not_hsg 12 parent not hsg hsg 13 parent hsg some_col 14 parent some college col_grad 15 parent college grad grad_sch 16 parent grad school avg_ed 17 avg parent ed full 18 pct full credential emer 19 pct emer credential enroll 20 number of students mealcat 21 Percentage free meals in 3 categories collcat 22 <none> Variables in the working file
regression /dependent api00 /method=enter ell meals yr_rnd mobility acs_k3 acs_46 full emer enroll .
Variables Entered/Removed Model Variables Entered Variables Removed Method 1 number of students, Enter avg class size 4-6, pct 1st year in school, avg class size k-3, pct emer credential, english language learners, year round school, pct free meals, pct full credentiala . a. All requested variables entered.
Model Summary | ||||
Model | R | R Square | Adjusted R Square | Std. Error of the Estimate |
1 | .919a | .845 | .841 | 56.768 |
a. Predictors: (Constant), number of students, avg class size 4-6, pct 1st year in school, avg class size k-3, pct emer credential, english language learners, year round school, pct free meals, pct full credential |
ANOVA..b.. | ||||||
Model | Sum of Squares | df | Mean Square | F | Sig. | |
1 | Regression | 6740702.006 | 9 | 748966.890 | 232.409 | .000a |
Residual | 1240707.781 | 385 | 3222.618 | |||
Total | 7981409.787 | 394 | ||||
b. Dependent Variable: api 2000 | ||||||
a. Predictors: (Constant), number of students, avg class size 4-6, pct 1st year in school, avg class size k-3, pct emer credential, english language learners, year round school, pct free meals, pct full credential |
Coefficientsa | ||||||
Model | Unstandardized Coefficients | Standardized Coefficients | t | Sig. | ||
B | Std. Error | Beta | ||||
1 | (Constant) | 758.942 | 62.286 | 12.185 | .000 | |
english language learners | -.860 | .211 | -.150 | -4.083 | .000 | |
pct free meals | -2.948 | .170 | -.661 | -17.307 | .000 | |
year round school | -19.889 | 9.258 | -.059 | -2.148 | .032 | |
pct 1st year in school | -1.301 | .436 | -.069 | -2.983 | .003 | |
avg class size k-3 | 1.319 | 2.253 | .013 | .585 | .559 | |
avg class size 4-6 | 2.032 | .798 | .055 | 2.546 | .011 | |
pct full credential | .610 | .476 | .064 | 1.281 | .201 | |
pct emer credential | -.707 | .605 | -.058 | -1.167 | .244 | |
number of students | -.012 | .017 | -.019 | -.724 | .469 | |
a. Dependent Variable: api 2000 |
REGRESSION /DEPENDENT api00 /METHOD=ENTER ell acs_k3 avg_ed meals
Variable Labels | ||
Variable | Position | Label |
snum | 1 | school number |
dnum | 2 | district number |
api00 | 3 | api 2000 |
api99 | 4 | api 1999 |
growth | 5 | growth 1999 to 2000 |
meals | 6 | pct free meals |
ell | 7 | english language learners |
yr_rnd | 8 | year round school |
mobility | 9 | pct 1st year in school |
acs_k3 | 10 | avg class size k-3 |
acs_46 | 11 | avg class size 4-6 |
not_hsg | 12 | parent not hsg |
hsg | 13 | parent hsg |
some_col | 14 | parent some college |
col_grad | 15 | parent college grad |
grad_sch | 16 | parent grad school |
avg_ed | 17 | avg parent ed |
full | 18 | pct full credential |
emer | 19 | pct emer credential |
enroll | 20 | number of students |
mealcat | 21 | Percentage free meals in 3 categories |
collcat | 22 | <none> |
Variables in the working file |
Model Summary | |||||
Model | R | R Square | Adjusted R Square | Std. Error of the Estimate | |
1 | .912a | .833 | .831 | 58.633 | |
a. Predictors: (Constant), pct free meals, avg class size k-3, english language learners, avg parent ed |
ANOVA(b) | ||||||
Model | Sum of Squares | df | Mean Square | F | Sig. | |
1 | Regression | 6393719.254 | 4 | 1598429.813 | 464.956 | .000a |
Residual | 1285740.498 | 374 | 3437.809 | |||
Total | 7679459.752 | 378 | ||||
a. Predictors: (Constant), pct free meals, avg class size k-3, english language learners, avg parent ed | ||||||
b. Dependent Variable: api 2000 |
Coefficients(a) | ||||||
Unstandardized Coefficients | Standardized Coefficients | |||||
Model | B | Std. Error | Beta | t | Sig. | |
1 | (Constant) | 709.639 | 56.240 | 12.618 | .000 | |
english language learners | -.843 | .196 | -.147 | -4.307 | .000 | |
avg class size k-3 | 3.388 | 2.333 | .032 | 1.452 | .147 | |
avg parent ed | 29.072 | 6.924 | .156 | 4.199 | .000 | |
pct free meals | -2.937 | .195 | -.655 | -15.081 | .000 | |
a. Dependent Variable: api 2000 |
Standard Multiple | Sequential | comments | ||
ri2 squared correlation | IV1 : (a+b) / (a+b+c+d) | IV2 : (a+b) / (a+b+c+d) | overlapped effects | |
IV2 : (c+b) / (a+b+c+d) | IV,,2: (c+b) / (a+b+c+d) | |||
sri2 squared semipartial correlation part in spss | IV1 : (a) / (a+b+c+d) | IV2 : (a+b) / (a+b+c+d) | Usual setting Unique contribution to Y | |
IV2 : (c) / (a+b+c+d) | IV2 : (c) / (a+b+c+d) | |||
pri2 squared partial correlation partial in spss | IV1 : (a) / (a+d) | IV2 : (a+b) / (a+b+d) | Like adjusted r2 Unique contribution to Y | |
IV2 : (c) / (c+d) | IV2 : (c) / (c+d) | |||
IV1 이 IV2 보다 먼저 투입되었을 때를 가정 |
/STATISTICS COEFF OUTS R ANOVA CHANGE ZPP 위에서 ZPP
command line: display labels . Variable Labels Variable Position Label snum 1 school number dnum 2 district number api00 3 api 2000 api99 4 api 1999 growth 5 growth 1999 to 2000 meals 6 pct free meals ell 7 english language learners yr_rnd 8 year round school mobility 9 pct 1st year in school acs_k3 10 avg class size k-3 acs_46 11 avg class size 4-6 not_hsg 12 parent not hsg hsg 13 parent hsg some_col 14 parent some college col_grad 15 parent college grad grad_sch 16 parent grad school avg_ed 17 avg parent ed full 18 pct full credential emer 19 pct emer credential enroll 20 number of students mealcat 21 Percentage free meals in 3 categories collcat 22 <none> Variables in the working file
regression /dependent api00 /method=enter ell meals yr_rnd mobility acs_k3 acs_46 full emer enroll .
regression /dependent api00 /method=enter ell yr_rnd mobility acs_k3 acs_46 emer enroll /method=test(meals) .CategoryStatistics
REGRESSION /DEPENDENT api00 /METHOD=ENTER ell acs_k3 avg_ed meals .
Coefficientsa | |||||||||
Model | Unstandardized Coefficients | Standardized Coefficients | t | Sig. | Correlations | ||||
B | Std. Error | Beta | Zero-order | Partial | Part | ||||
1 | (Constant) | 709.639 | 56.240 | 12.618 | .000 | ||||
ell | -.843 | .196 | -.147 | -4.307 | .000 | -.766 | -.217 | -.091 | |
acs_k3 | 3.388 | 2.333 | .032 | 1.452 | .147 | .185 | .075 | .031 | |
avg_ed | 29.072 | 6.924 | .156 | 4.199 | .000 | .793 | .212 | .089 | |
meals | -2.937 | .195 | -.655 | -15.081 | .000 | -.902 | -.615 | -.319 |
REGRESSION /DEPENDENT api00 /METHOD=FORWARD ell acs_k3 avg_ed meals .
Coefficientsa | |||||||||
Model | Unstandardized Coefficients | Standardized Coefficients | t | Sig. | Correlations | ||||
B | Std. Error | Beta | Zero-order | Partial | Part | ||||
1 | (Constant) | 892.894 | 6.830 | 130.731 | .000 | ||||
meals | -4.046 | .100 | -.902 | -40.531 | .000 | -.902 | -.902 | -.902 | |
2 | (Constant) | 887.826 | 6.718 | 132.163 | .000 | ||||
meals | -3.469 | .154 | -.773 | -22.565 | .000 | -.902 | -.758 | -.488 | |
ell | -.951 | .197 | -.166 | -4.840 | .000 | -.766 | -.242 | -.105 | |
3 | (Constant) | 781.172 | 27.182 | 28.738 | .000 | ||||
meals | -3.004 | .189 | -.670 | -15.855 | .000 | -.902 | -.633 | -.336 | |
ell | -.819 | .195 | -.143 | -4.191 | .000 | -.766 | -.212 | -.089 | |
avg_ed | 27.828 | 6.881 | .149 | 4.044 | .000 | .793 | .204 | .086 |
Excluded Variablesd | ||||||
Model | Beta In | t | Sig. | Partial Correlation | Collinearity Statistics | |
Tolerance | ||||||
1 | ell | -.166a | -4.840 | .000 | -.242 | .398 |
acs_k3 | .009a | .383 | .702 | .020 | .962 | |
avg_ed | .175a | 4.711 | .000 | .236 | .339 | |
2 | acs_k3 | .020b | .920 | .358 | .047 | .951 |
avg_ed | .149b | 4.044 | .000 | .204 | .329 | |
3 | acs_k3 | .032c | 1.452 | .147 | .075 | .936 |
REGRESSION /DEPENDENT api00 /METHOD=BACKWARD ell acs_k3 avg_ed meals .
Coefficientsa | |||||||||
Model | Unstandardized Coefficients | Standardized Coefficients | t | Sig. | Correlations | ||||
B | Std. Error | Beta | Zero-order | Partial | Part | ||||
1 | (Constant) | 709.639 | 56.240 | 12.618 | .000 | ||||
ell | -.843 | .196 | -.147 | -4.307 | .000 | -.766 | -.217 | -.091 | |
acs_k3 | 3.388 | 2.333 | .032 | 1.452 | .147 | .185 | .075 | .031 | |
avg_ed | 29.072 | 6.924 | .156 | 4.199 | .000 | .793 | .212 | .089 | |
meals | -2.937 | .195 | -.655 | -15.081 | .000 | -.902 | -.615 | -.319 | |
2 | (Constant) | 781.172 | 27.182 | 28.738 | .000 | ||||
ell | -.819 | .195 | -.143 | -4.191 | .000 | -.766 | -.212 | -.089 | |
avg_ed | 27.828 | 6.881 | .149 | 4.044 | .000 | .793 | .204 | .086 | |
meals | -3.004 | .189 | -.670 | -15.855 | .000 | -.902 | -.633 | -.336 |
Excluded Variablesb | ||||||
Model | Beta In | t | Sig. | Partial Correlation | Collinearity Statistics | |
Tolerance | ||||||
2 | acs_k3 | .032a | 1.452 | .147 | .075 | .936 |
REGRESSION /DEPENDENT api00 /METHOD=STEPWISE ell acs_k3 avg_ed meals
Coefficientsa | |||||||||
Model | Unstandardized Coefficients | Standardized Coefficients | t | Sig. | Correlations | ||||
B | Std. Error | Beta | Zero-order | Partial | Part | ||||
1 | (Constant) | 892.894 | 6.830 | 130.731 | .000 | ||||
meals | -4.046 | .100 | -.902 | -40.531 | .000 | -.902 | -.902 | -.902 | |
2 | (Constant) | 887.826 | 6.718 | 132.163 | .000 | ||||
meals | -3.469 | .154 | -.773 | -22.565 | .000 | -.902 | -.758 | -.488 | |
ell | -.951 | .197 | -.166 | -4.840 | .000 | -.766 | -.242 | -.105 | |
3 | (Constant) | 781.172 | 27.182 | 28.738 | .000 | ||||
meals | -3.004 | .189 | -.670 | -15.855 | .000 | -.902 | -.633 | -.336 | |
ell | -.819 | .195 | -.143 | -4.191 | .000 | -.766 | -.212 | -.089 | |
avg_ed | 27.828 | 6.881 | .149 | 4.044 | .000 | .793 | .204 | .086 |
Excluded Variablesd | ||||||
Model | Beta In | t | Sig. | Partial Correlation | Collinearity Statistics | |
Tolerance | ||||||
1 | ell | -.166a | -4.840 | .000 | -.242 | .398 |
acs_k3 | .009a | .383 | .702 | .020 | .962 | |
avg_ed | .175a | 4.711 | .000 | .236 | .339 | |
2 | acs_k3 | .020b | .920 | .358 | .047 | .951 |
avg_ed | .149b | 4.044 | .000 | .204 | .329 | |
3 | acs_k3 | .032c | 1.452 | .147 | .075 | .936 |