Regression mit DUMMY-Variablen WS 98/99 Umdruck 5
Seite - 1 - Worksheet size: 100000 cells
MTB > # Opening worksheet from file: C:\ARBEIT\Word\EDV- Prakt\Statistik\Dummy.dat
MTB > # File was last modified on 12/11/96
MTB > Name c1='Schuldv' c2='Nateink' c3='DUMM-Var' c4='Jahr' MTB > print c1-c4
Data Display
Row Schuldv Nateink DUMM-Var Jahr 1 2.6 2.4 0 1933 2 3.0 2.8 0 1934 3 3.6 3.1 0 1935 4 3.7 3.4 0 1936 5 3.8 3.9 0 1937 6 4.1 4.0 0 1938 7 4.4 4.2 0 1939 8 7.1 5.1 1 1940 9 8.0 6.3 1 1941 10 8.9 8.1 1 1942 11 9.7 8.8 1 1943 12 10.2 9.6 1 1944 13 10.1 9.7 1 1945 14 7.9 9.6 0 1946 15 8.7 10.4 0 1947 16 9.1 12.0 0 1948 17 10.1 12.9 0 1949 MTB > MTB > Plot 'Schuldv'*'Nateink';
SUBC> Symbol 'DUMM-Var';
SUBC> Jitter 0.025 0.025.
Regression mit DUMMY-Variablen WS 98/99 Umdruck 5
Seite - 2 - 0
1
12 7
2 11 10 9 8 7 6 5 4 3 2
Nateink
S c h u ld v
MTB > brief=3
MTB > regr c1 1 c2;
SUBC> xpxi m1.
Regression Analysis
The regression equation is Schuldv = 1.57 + 0.759 Nateink
Predictor Coef StDev T P Constant 1.5698 0.6337 2.48 0.026 Nateink 0.75936 0.08307 9.14 0.000 S = 1.156 R-Sq = 84.8% R-Sq(adj) = 83.8%
Analysis of Variance
Source DF SS MS F P Regression 1 111.71 111.71 83.56 0.000 Error 15 20.05 1.34
Total 16 131.76
Obs Nateink Schuldv Fit StDev Fit Residual St Resid 1 2.4 2.600 3.392 0.463 -0.792 -0.75 2 2.8 3.000 3.696 0.437 -0.696 -0.65 3 3.1 3.600 3.924 0.419 -0.324 -0.30 4 3.4 3.700 4.152 0.400 -0.452 -0.42 5 3.9 3.800 4.531 0.372 -0.731 -0.67 6 4.0 4.100 4.607 0.367 -0.507 -0.46 7 4.2 4.400 4.759 0.356 -0.359 -0.33 8 5.1 7.100 5.443 0.316 1.657 1.49
Regression mit DUMMY-Variablen WS 98/99 Umdruck 5
Seite - 3 - 9 6.3 8.000 6.354 0.284 1.646 1.47 10 8.1 8.900 7.721 0.299 1.179 1.06 11 8.8 9.700 8.252 0.324 1.448 1.30 12 9.6 10.200 8.860 0.362 1.340 1.22 13 9.7 10.100 8.936 0.367 1.164 1.06 14 9.6 7.900 8.860 0.362 -0.960 -0.87 15 10.4 8.700 9.467 0.407 -0.767 -0.71 16 12.0 9.100 10.682 0.512 -1.582 -1.53 17 12.9 10.100 11.366 0.576 -1.266 -1.26
MTB > print m1
Data Display
Matrix M1
0.300417 -0.035315 -0.035315 0.005162
Regression mit DUMMY-Variablen WS 98/99 Umdruck 5
Seite - 4 - MTB > brief=3
MTB > regr c1 2 c2 c3;
SUBC> xpxi m2.
Regression Analysis
The regression equation is
Schuldv = 1.29 + 0.681 Nateink + 2.30 DUMM-Var
Predictor Coef StDev T P Constant 1.2897 0.1155 11.16 0.000 Nateink 0.68141 0.01549 43.99 0.000 DUMM-Var 2.3044 0.1094 21.06 0.000 S = 0.2094 R-Sq = 99.5% R-Sq(adj) = 99.5%
Analysis of Variance
Source DF SS MS F P Regression 2 131.145 65.573 1495.92 0.000 Error 14 0.614 0.044
Total 16 131.759 Source DF Seq SS Nateink 1 111.706 DUMM-Var 1 19.439
Obs Nateink Schuldv Fit StDev Fit Residual St Resid 1 2.4 2.6000 2.9251 0.0868 -0.3251 -1.71 2 2.8 3.0000 3.1977 0.0827 -0.1977 -1.03 3 3.1 3.6000 3.4021 0.0797 0.1979 1.02 4 3.4 3.7000 3.6065 0.0770 0.0935 0.48 5 3.9 3.8000 3.9472 0.0728 -0.1472 -0.75 6 4.0 4.1000 4.0154 0.0721 0.0846 0.43 7 4.2 4.4000 4.1517 0.0706 0.2483 1.26 8 5.1 7.1000 7.0693 0.0961 0.0307 0.16 9 6.3 8.0000 7.8870 0.0891 0.1130 0.60 10 8.1 8.9000 9.1136 0.0855 -0.2136 -1.12 11 8.8 9.7000 9.5906 0.0865 0.1094 0.57 12 9.6 10.2000 10.1357 0.0893 0.0643 0.34 13 9.7 10.1000 10.2038 0.0897 -0.1038 -0.55 14 9.6 7.9000 7.8313 0.0818 0.0687 0.36 15 10.4 8.7000 8.3764 0.0901 0.3236 1.71 16 12.0 9.1000 9.4667 0.1092 -0.3667 -2.05R 17 12.9 10.1000 10.0799 0.1209 0.0201 0.12 R denotes an observation with a large standardized residual
MTB > print m2
Data Display
Matrix M2
0.304451 -0.034192 -0.033198 -0.034192 0.005475 -0.009241 -0.033198 -0.009241 0.273173
MTB >