. ******************************************* . *** Descriptive Analysen . ******************************************* . . ** Korrelation der Namens-Kodierung durch Student.Hilfskräfte bzw. durch die Onomastikbearbeitung . pwcorr non_ger_A non_ger_B | non_ge~A non_ge~B -------------+------------------ non_ger_A | 1.0000 non_ger_B | 0.7502 1.0000 . pwcorr non_ger name_non_GER | non_ger name_n~R -------------+------------------ non_ger | 1.0000 name_non_GER | 0.6465 1.0000 . . ** Anzahl der Beobachtungen mit Namens-Kodierung . tab name_non_GER if abinote~=. name_non_GE | R | Freq. Percent Cum. ------------+----------------------------------- 0 | 1,445 92.63 92.63 1 | 115 7.37 100.00 ------------+----------------------------------- Total | 1,560 100.00 . . ** Verteilung der Noten . su abinote,d Abi-Note ------------------------------------------------------------- Percentiles Smallest 1% 1 .9 5% 1.1 1 10% 1.3 1 Obs 2200 25% 1.7 1 Sum of Wgt. 2200 50% 2.1 Mean 2.133409 Largest Std. Dev. .6136 75% 2.5 3.7 90% 3 3.7 Variance .376505 95% 3.2 3.8 Skewness .232361 99% 3.5 3.8 Kurtosis 2.488865 . su note_z,d note_z ------------------------------------------------------------- Percentiles Smallest 1% 2.666667 1.333333 5% 3.333333 2 10% 3.666667 2 Obs 2217 25% 4.666667 2 Sum of Wgt. 2217 50% 6.333333 Mean 6.614644 Largest Std. Dev. 2.377842 75% 8.333333 14.66667 90% 10 14.66667 Variance 5.654132 95% 11 15 Skewness .5738472 99% 12.66667 16.66667 Kurtosis 2.964109 . su note_r,d note_r ------------------------------------------------------------- Percentiles Smallest 1% 2 1 5% 3 1 10% 3.5 1 Obs 2217 25% 4.5 1 Sum of Wgt. 2217 50% 6.5 Mean 6.779432 Largest Std. Dev. 2.695819 75% 8.5 14.5 90% 10.5 15 Variance 7.267438 95% 11.5 15 Skewness .4690445 99% 13.5 15 Kurtosis 2.61738 . su note_s,d note_s ------------------------------------------------------------- Percentiles Smallest 1% 1 0 5% 2 0 10% 3 0 Obs 2217 25% 4 0 Sum of Wgt. 2217 50% 6 Mean 6.649075 Largest Std. Dev. 3.103871 75% 8 16 90% 11 17 Variance 9.634017 95% 13 17 Skewness .5946828 99% 15 18 Kurtosis 2.917177 . su notegesprch,d Note Gespräch ------------------------------------------------------------- Percentiles Smallest 1% 3 2 5% 5 2 10% 6 2 Obs 2217 25% 7 2 Sum of Wgt. 2217 50% 9 Mean 8.9576 Largest Std. Dev. 2.644046 75% 11 17 90% 12 17 Variance 6.990981 95% 13 17 Skewness .1390087 99% 15 18 Kurtosis 2.705583 . su notekurzvortrag,d Note Kurzvortrag ------------------------------------------------------------- Percentiles Smallest 1% 2 0 5% 3 1 10% 3 1 Obs 2217 25% 5 1 Sum of Wgt. 2217 50% 7 Mean 7.784393 Largest Std. Dev. 3.458818 75% 10 17 90% 13 17 Variance 11.96342 95% 14 18 Skewness .3089149 99% 16 18 Kurtosis 2.391554 . . **Korrelation Abinote Klausurnote . pwcorr abinote gesamtnote,sig | abinote gesamt~e -------------+------------------ abinote | 1.0000 | | gesamtnote | -0.4534 1.0000 | 0.0000 | . . ** Noten unterschiede zwischen Subgruppen . su abinote if female==1 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- abinote | 1138 2.053603 .6002273 .9 3.8 . su abinote if female==0 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- abinote | 1062 2.218927 .6165252 1 3.8 . ttest abinote, by(female) Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 1062 2.218927 .0189186 .6165252 2.181804 2.256049 1 | 1138 2.053603 .0177928 .6002273 2.018692 2.088513 ---------+-------------------------------------------------------------------- combined | 2200 2.133409 .013082 .6136 2.107755 2.159063 ---------+-------------------------------------------------------------------- diff | .1653237 .025947 .1144404 .216207 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 6.3716 Ho: diff = 0 degrees of freedom = 2198 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 1.0000 Pr(|T| > |t|) = 0.0000 Pr(T > t) = 0.0000 . . su abinote if name_non_GER==1 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- abinote | 115 2.111304 .6115504 1 3.6 . su abinote if name_non_GER==0 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- abinote | 1445 2.036055 .5956976 .9 3.8 . ttest abinote, by(name_non_GER) Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 1445 2.036055 .0156708 .5956976 2.005315 2.066795 1 | 115 2.111304 .0570274 .6115504 1.998334 2.224275 ---------+-------------------------------------------------------------------- combined | 1560 2.041603 .0151152 .5970045 2.011954 2.071251 ---------+-------------------------------------------------------------------- diff | -.075249 .057831 -.1886837 .0381858 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -1.3012 Ho: diff = 0 degrees of freedom = 1558 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.0967 Pr(|T| > |t|) = 0.1934 Pr(T > t) = 0.9033 . . . ******************************************* . *** Regressions Analysen (Teil A) . ******************************************* . . ** I - Abhängige Variable: Abinote . . reg abinote name_non_GER, robust Linear regression Number of obs = 1560 F( 1, 1558) = 1.63 Prob > F = 0.2019 R-squared = 0.0011 Root MSE = .59687 ------------------------------------------------------------------------------ | Robust abinote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- name_non_GER | .075249 .0589381 1.28 0.202 -.0403574 .1908554 _cons | 2.036055 .0156755 129.89 0.000 2.005308 2.066803 ------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Abinote.xls", se br sdec(3) bdec(3) replace OUTPUT\Abinote.xls . reg abinote non_ger, robust Linear regression Number of obs = 1560 F( 1, 1558) = 0.20 Prob > F = 0.6547 R-squared = 0.0001 Root MSE = .59716 ------------------------------------------------------------------------------ | Robust abinote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- non_ger | .0305247 .0682446 0.45 0.655 -.1033362 .1643857 _cons | 2.033887 .0227778 89.29 0.000 1.989209 2.078566 ------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Abinote.xls", se br sdec(3) bdec(3) append OUTPUT\Abinote.xls . reg abinote female, robust Linear regression Number of obs = 2200 F( 1, 2198) = 40.52 Prob > F = 0.0000 R-squared = 0.0181 Root MSE = .60815 ------------------------------------------------------------------------------ | Robust abinote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- female | -.1653237 .025971 -6.37 0.000 -.2162541 -.1143934 _cons | 2.218927 .0189183 117.29 0.000 2.181827 2.256026 ------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Abinote.xls", se br sdec(3) bdec(3) append OUTPUT\Abinote.xls . reg abinote female abschicht age_Q1 age_Q2 age_Q4 Bochum Bielefeld byear, robust Linear regression Number of obs = 2200 F( 8, 2191) = 59.51 Prob > F = 0.0000 R-squared = 0.1688 Root MSE = .56043 ------------------------------------------------------------------------------ | Robust abinote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- female | -.0846515 .0249138 -3.40 0.001 -.1335086 -.0357944 abschicht | -.2229878 .0317011 -7.03 0.000 -.2851551 -.1608204 age_Q1 | -.3577841 .0387075 -9.24 0.000 -.4336913 -.281877 age_Q2 | -.1793356 .0337072 -5.32 0.000 -.2454369 -.1132343 age_Q4 | .1359498 .0426017 3.19 0.001 .0524058 .2194938 Bochum | .1858102 .0343625 5.41 0.000 .1184237 .2531966 Bielefeld | .2824613 .0377296 7.49 0.000 .2084717 .3564508 byear | .015217 .0093488 1.63 0.104 -.0031164 .0335504 _cons | -27.92347 18.53856 -1.51 0.132 -64.27846 8.431522 ------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Abinote.xls", se br sdec(3) bdec(3) append OUTPUT\Abinote.xls . reg abinote name_non_GER female abschicht age_Q1 age_Q2 age_Q4 byear, robust Linear regression Number of obs = 1560 F( 7, 1552) = 37.83 Prob > F = 0.0000 R-squared = 0.1411 Root MSE = .55452 ------------------------------------------------------------------------------ | Robust abinote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- name_non_GER | .0537665 .0561235 0.96 0.338 -.0563194 .1638523 female | -.0975539 .0292539 -3.33 0.001 -.1549352 -.0401725 abschicht | -.234994 .0320183 -7.34 0.000 -.2977978 -.1721902 age_Q1 | -.376058 .046248 -8.13 0.000 -.4667732 -.2853428 age_Q2 | -.1726215 .0402299 -4.29 0.000 -.2515322 -.0937108 age_Q4 | .1506411 .0526756 2.86 0.004 .0473182 .2539639 byear | .0196347 .0119545 1.64 0.101 -.0038139 .0430833 _cons | -36.67998 23.70512 -1.55 0.122 -83.17742 9.817459 ------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Abinote.xls", se br sdec(3) bdec(3) append OUTPUT\Abinote.xls . reg abinote non_ger female abschicht age_Q1 age_Q2 age_Q4 byear, robust Linear regression Number of obs = 1560 F( 7, 1552) = 37.45 Prob > F = 0.0000 R-squared = 0.1407 Root MSE = .55467 ------------------------------------------------------------------------------ | Robust abinote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- non_ger | .0246823 .0647868 0.38 0.703 -.1023966 .1517613 female | -.0973598 .0294324 -3.31 0.001 -.1550913 -.0396284 abschicht | -.2340323 .0319703 -7.32 0.000 -.2967419 -.1713226 age_Q1 | -.3772583 .0462866 -8.15 0.000 -.4680491 -.2864674 age_Q2 | -.1728715 .0402836 -4.29 0.000 -.2518876 -.0938555 age_Q4 | .15072 .0526861 2.86 0.004 .0473765 .2540635 byear | .0194827 .0120297 1.62 0.106 -.0041135 .0430788 _cons | -36.38066 23.85337 -1.53 0.127 -83.16889 10.40757 ------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Abinote.xls", se br sdec(3) bdec(3) append OUTPUT\Abinote.xls . reg abinote name_AltEuropa name_SuedOst name_UDSSR name_mitOst name_rest female abschicht age_Q1 age_Q2 age_Q4 byear, robust Linear regression Number of obs = 1560 F( 11, 1548) = 26.92 Prob > F = 0.0000 R-squared = 0.1511 Root MSE = .55201 -------------------------------------------------------------------------------- | Robust abinote | Coef. Std. Err. t P>|t| [95% Conf. Interval] ---------------+---------------------------------------------------------------- name_AltEuropa | .1025971 .1081993 0.95 0.343 -.1096355 .3148297 name_SuedOst | .0482429 .0976162 0.49 0.621 -.1432311 .2397169 name_UDSSR | -.458499 .1455165 -3.15 0.002 -.7439293 -.1730686 name_mitOst | .2878644 .1032431 2.79 0.005 .0853533 .4903755 name_rest | .0364903 .1218506 0.30 0.765 -.2025194 .2755 female | -.0943704 .0291092 -3.24 0.001 -.151468 -.0372729 abschicht | -.2353073 .0318949 -7.38 0.000 -.297869 -.1727455 age_Q1 | -.3776511 .0460547 -8.20 0.000 -.4679873 -.2873148 age_Q2 | -.1786995 .0402806 -4.44 0.000 -.2577097 -.0996892 age_Q4 | .145333 .0524756 2.77 0.006 .0424022 .2482638 byear | .0183068 .011955 1.53 0.126 -.0051428 .0417565 _cons | -34.04461 23.70644 -1.44 0.151 -80.54474 12.45551 -------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Abinote.xls", se br sdec(3) bdec(3) append OUTPUT\Abinote.xls . reg abinote name_WestE name_MediterBalkan name_OstE name_mitOst2 name_rest2 female abschicht age_Q1 age_Q2 age_Q4 byear, robust Linear regression Number of obs = 1560 F( 11, 1548) = 25.39 Prob > F = 0.0000 R-squared = 0.1453 Root MSE = .55388 ------------------------------------------------------------------------------------ | Robust abinote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------------+---------------------------------------------------------------- name_WestE | .1415014 .1430652 0.99 0.323 -.1391206 .4221233 name_MediterBalkan | .1178876 .1107494 1.06 0.287 -.0993472 .3351223 name_OstE | -.1384914 .0970541 -1.43 0.154 -.3288627 .05188 name_mitOst2 | .2100553 .1120355 1.87 0.061 -.009702 .4298127 name_rest2 | -.0374182 .1461975 -0.26 0.798 -.3241842 .2493478 female | -.0958164 .0291715 -3.28 0.001 -.1530361 -.0385967 abschicht | -.2328591 .0320745 -7.26 0.000 -.2957732 -.1699451 age_Q1 | -.3775652 .0460004 -8.21 0.000 -.467795 -.2873354 age_Q2 | -.174421 .0402982 -4.33 0.000 -.2534658 -.0953761 age_Q4 | .1486733 .0527337 2.82 0.005 .0452362 .2521103 byear | .019517 .0118303 1.65 0.099 -.0036881 .0427222 _cons | -36.44665 23.45902 -1.55 0.120 -82.46145 9.568159 ------------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Abinote.xls", se br sdec(3) bdec(3) append OUTPUT\Abinote.xls . ** II - Abhängige Variable: Gesamtnote . . reg gesamtnote abinote_normiert , robust Linear regression Number of obs = 2200 F( 1, 2198) = 574.47 Prob > F = 0.0000 R-squared = 0.2056 Root MSE = 1.8793 ---------------------------------------------------------------------------------- | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.557521 .0649829 23.97 0.000 1.430087 1.684956 _cons | 7.473 .040066 186.52 0.000 7.394429 7.551571 ---------------------------------------------------------------------------------- . reg gesamtnote abinote abinote_Muenster, robust Linear regression Number of obs = 2200 F( 2, 2197) = 285.67 Prob > F = 0.0000 R-squared = 0.2067 Root MSE = 1.8783 ---------------------------------------------------------------------------------- | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote | -1.57939 .0668378 -23.63 0.000 -1.710462 -1.448319 abinote_Muenster | .0687779 .036684 1.87 0.061 -.0031609 .1407168 _cons | 10.74292 .1531766 70.13 0.000 10.44253 11.0433 ---------------------------------------------------------------------------------- . reg gesamtnote abinote_normiert if uni=="Bielefeld", robust Linear regression Number of obs = 311 F( 1, 309) = 46.18 Prob > F = 0.0000 R-squared = 0.1353 Root MSE = 1.9527 ---------------------------------------------------------------------------------- | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.263706 .1859582 6.80 0.000 .8978017 1.629611 _cons | 7.465488 .1259206 59.29 0.000 7.217718 7.713258 ---------------------------------------------------------------------------------- . reg gesamtnote abinote_normiert if uni=="Bochum", robust Linear regression Number of obs = 329 F( 1, 327) = 39.11 Prob > F = 0.0000 R-squared = 0.1099 Root MSE = 1.738 ---------------------------------------------------------------------------------- | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.057392 .1690728 6.25 0.000 .7247839 1.389999 _cons | 6.982308 .1065584 65.53 0.000 6.772682 7.191935 ---------------------------------------------------------------------------------- . reg gesamtnote abinote_normiert if uni=="Münster", robust Linear regression Number of obs = 1560 F( 1, 1558) = 476.16 Prob > F = 0.0000 R-squared = 0.2205 Root MSE = 1.8767 ---------------------------------------------------------------------------------- | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.67154 .0766019 21.82 0.000 1.521287 1.821794 _cons | 7.533465 .0465341 161.89 0.000 7.442189 7.624741 ---------------------------------------------------------------------------------- . . reg gesamtnote female , robust Linear regression Number of obs = 2217 F( 1, 2215) = 10.42 Prob > F = 0.0013 R-squared = 0.0047 Root MSE = 2.1022 ------------------------------------------------------------------------------ | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- female | -.2888522 .0894626 -3.23 0.001 -.4642916 -.1134129 _cons | 7.621662 .0655046 116.35 0.000 7.493205 7.750119 ------------------------------------------------------------------------------ . reg gesamtnote abinote_normiert female abschicht age_Q1 age_Q2 age_Q4 Bochum Bielefeld y200708 y200809 m_1-m_10 if Bochum==1, robust note: Bochum omitted because of collinearity note: Bielefeld omitted because of collinearity note: m_6 omitted because of collinearity Linear regression Number of obs = 329 F( 17, 311) = 5.66 Prob > F = 0.0000 R-squared = 0.1996 Root MSE = 1.69 ---------------------------------------------------------------------------------- | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.14128 .1598954 7.14 0.000 .8266665 1.455894 female | -.6652588 .1968877 -3.38 0.001 -1.052659 -.2778584 abschicht | -.0631578 .4092559 -0.15 0.877 -.8684183 .7421026 age_Q1 | .406475 .314483 1.29 0.197 -.2123085 1.025258 age_Q2 | -.0193373 .2684295 -0.07 0.943 -.5475048 .5088303 age_Q4 | -.1401041 .2595149 -0.54 0.590 -.6507311 .3705229 Bochum | 0 (omitted) Bielefeld | 0 (omitted) y200708 | .4776544 .3320737 1.44 0.151 -.1757408 1.13105 y200809 | .139409 .19855 0.70 0.483 -.2512622 .5300803 m_1 | -1.238245 .5123914 -2.42 0.016 -2.246438 -.2300531 m_2 | .0596591 .5446839 0.11 0.913 -1.012072 1.131391 m_3 | -1.270043 .5848667 -2.17 0.031 -2.420839 -.1192472 m_4 | -1.088686 .4679633 -2.33 0.021 -2.00946 -.1679111 m_5 | -.2296501 .5024704 -0.46 0.648 -1.218322 .7590213 m_6 | 0 (omitted) m_7 | .0878643 .5097786 0.17 0.863 -.9151869 1.090915 m_8 | -.3114633 .5149423 -0.60 0.546 -1.324675 .7017481 m_9 | -.693858 .4772484 -1.45 0.147 -1.632902 .2451861 m_10 | -.664284 .4681737 -1.42 0.157 -1.585472 .2569045 _cons | 7.715457 .4408297 17.50 0.000 6.848071 8.582843 ---------------------------------------------------------------------------------- . reg gesamtnote abinote_normiert female abschicht age_Q1 age_Q2 age_Q4 Bochum Bielefeld y200708 y200809 m_1-m_10 if Bielefeld==1, robust note: Bochum omitted because of collinearity note: Bielefeld omitted because of collinearity note: m_1 omitted because of collinearity Linear regression Number of obs = 311 F( 17, 293) = 7.05 Prob > F = 0.0000 R-squared = 0.2508 Root MSE = 1.8666 ---------------------------------------------------------------------------------- | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.153112 .192579 5.99 0.000 .7740988 1.532126 female | -.7891015 .2184372 -3.61 0.000 -1.219006 -.3591967 abschicht | -.1873071 .38322 -0.49 0.625 -.9415197 .5669056 age_Q1 | .8382958 .3818856 2.20 0.029 .0867093 1.589882 age_Q2 | .3241661 .3472318 0.93 0.351 -.3592186 1.007551 age_Q4 | -.5468194 .277969 -1.97 0.050 -1.093888 .0002495 Bochum | 0 (omitted) Bielefeld | 0 (omitted) y200708 | -.2003365 .2737615 -0.73 0.465 -.7391247 .3384518 y200809 | -.0669171 .2679441 -0.25 0.803 -.5942562 .460422 m_1 | 0 (omitted) m_2 | .1935144 .7080016 0.27 0.785 -1.199899 1.586928 m_3 | .664374 .7074132 0.94 0.348 -.7278812 2.056629 m_4 | .7887429 .7452976 1.06 0.291 -.6780723 2.255558 m_5 | -.1959753 .7082914 -0.28 0.782 -1.589959 1.198008 m_6 | -.0494307 .7084221 -0.07 0.944 -1.443672 1.34481 m_7 | .9582841 .7086645 1.35 0.177 -.4364339 2.353002 m_8 | .1829143 .7196499 0.25 0.800 -1.233424 1.599253 m_9 | -.0587772 .7163098 -0.08 0.935 -1.468542 1.350987 m_10 | -.2401481 .7085211 -0.34 0.735 -1.634584 1.154288 _cons | 7.647033 .6862456 11.14 0.000 6.296437 8.997628 ---------------------------------------------------------------------------------- . reg gesamtnote abinote_normiert female abschicht age_Q1 age_Q2 age_Q4 Bochum Bielefeld y200708 y200809 m_1-m_10 if Bielefeld==0 & Bochum==0, robust note: Bochum omitted because of collinearity note: Bielefeld omitted because of collinearity note: m_1 omitted because of collinearity Linear regression Number of obs = 1560 F( 17, 1542) = 38.47 Prob > F = 0.0000 R-squared = 0.2768 Root MSE = 1.8171 ---------------------------------------------------------------------------------- | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.578276 .083881 18.82 0.000 1.413743 1.742809 female | -.7146526 .0967837 -7.38 0.000 -.9044941 -.5248111 abschicht | .5446255 .1384687 3.93 0.000 .2730187 .8162323 age_Q1 | .5867131 .141952 4.13 0.000 .3082737 .8651524 age_Q2 | .361987 .1242695 2.91 0.004 .118232 .605742 age_Q4 | -.3323965 .1407454 -2.36 0.018 -.6084692 -.0563238 Bochum | 0 (omitted) Bielefeld | 0 (omitted) y200708 | .1050365 .1217444 0.86 0.388 -.1337656 .3438387 y200809 | .1271527 .1097886 1.16 0.247 -.088198 .3425034 m_1 | 0 (omitted) m_2 | -.1532894 .2218353 -0.69 0.490 -.5884201 .2818413 m_3 | .3543422 .2154099 1.64 0.100 -.0681851 .7768695 m_4 | -.3023943 .2320559 -1.30 0.193 -.7575728 .1527843 m_5 | .2030963 .2321204 0.87 0.382 -.2522088 .6584013 m_6 | .3974248 .2683559 1.48 0.139 -.1289561 .9238058 m_7 | .4547171 .2168702 2.10 0.036 .0293255 .8801087 m_8 | .0734044 .2063477 0.36 0.722 -.3313473 .478156 m_9 | -.0268649 .2095318 -0.13 0.898 -.4378623 .3841325 m_10 | -.2187793 .2136792 -1.02 0.306 -.6379118 .2003532 _cons | 7.496175 .1970161 38.05 0.000 7.109727 7.882623 ---------------------------------------------------------------------------------- . . reg gesamtnote abinote_normiert , robust Linear regression Number of obs = 2200 F( 1, 2198) = 574.47 Prob > F = 0.0000 R-squared = 0.2056 Root MSE = 1.8793 ---------------------------------------------------------------------------------- | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.557521 .0649829 23.97 0.000 1.430087 1.684956 _cons | 7.473 .040066 186.52 0.000 7.394429 7.551571 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Gesamtnote.xls", se br sdec(3) bdec(3) replace OUTPUT\Gesamtnote.xls . reg gesamtnote abinote_normiert female abschicht age_Q1 age_Q2 age_Q4 , robust Linear regression Number of obs = 2200 F( 6, 2193) = 124.93 Prob > F = 0.0000 R-squared = 0.2473 Root MSE = 1.8313 ---------------------------------------------------------------------------------- | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.418766 .0699861 20.27 0.000 1.28152 1.556012 female | -.6553509 .0802651 -8.16 0.000 -.8127544 -.4979474 abschicht | .4432272 .1113462 3.98 0.000 .2248722 .6615822 age_Q1 | .4428366 .1173726 3.77 0.000 .2126636 .6730096 age_Q2 | .2464083 .1074837 2.29 0.022 .0356277 .4571889 age_Q4 | -.3460729 .1125683 -3.07 0.002 -.5668245 -.1253213 _cons | 7.634565 .0894368 85.36 0.000 7.459176 7.809955 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Gesamtnote.xls", se br sdec(3) bdec(3) append OUTPUT\Gesamtnote.xls . reg gesamtnote abinote_normiert female abschicht age_Q1 age_Q2 age_Q4 Bochum Bielefeld , robust Linear regression Number of obs = 2200 F( 8, 2191) = 97.77 Prob > F = 0.0000 R-squared = 0.2542 Root MSE = 1.8237 ---------------------------------------------------------------------------------- | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.407938 .0697521 20.18 0.000 1.271151 1.544725 female | -.6731926 .0800048 -8.41 0.000 -.8300859 -.5162993 abschicht | .4075817 .1114543 3.66 0.000 .1890144 .6261489 age_Q1 | .4550491 .1165787 3.90 0.000 .2264327 .6836656 age_Q2 | .255821 .1067621 2.40 0.017 .0464555 .4651865 age_Q4 | -.3509225 .1129491 -3.11 0.002 -.572421 -.129424 Bochum | -.4509683 .1077755 -4.18 0.000 -.6623212 -.2396153 Bielefeld | .139801 .118388 1.18 0.238 -.0923635 .3719655 _cons | 7.6929 .0925182 83.15 0.000 7.511468 7.874333 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Gesamtnote.xls", se br sdec(3) bdec(3) append OUTPUT\Gesamtnote.xls . reg gesamtnote abinote_normiert female abschicht age_Q1 age_Q2 age_Q4 Bochum Bielefeld y200708 y200809 m_1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 2200 F( 19, 2180) = 45.63 Prob > F = 0.0000 R-squared = 0.2655 Root MSE = 1.8145 ---------------------------------------------------------------------------------- | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.439722 .0697586 20.64 0.000 1.302922 1.576522 female | -.717108 .0800473 -8.96 0.000 -.874085 -.5601309 abschicht | .4537326 .1218625 3.72 0.000 .2147538 .6927113 age_Q1 | .6053928 .1215964 4.98 0.000 .3669358 .8438497 age_Q2 | .3218257 .1073661 3.00 0.003 .1112751 .5323764 age_Q4 | -.3756895 .1127481 -3.33 0.001 -.5967944 -.1545845 Bochum | -.3865646 .1092616 -3.54 0.000 -.6008324 -.1722969 Bielefeld | .1297947 .1180705 1.10 0.272 -.1017478 .3613371 y200708 | .0731526 .1046344 0.70 0.485 -.132041 .2783461 y200809 | .0756576 .0910039 0.83 0.406 -.1028059 .2541211 m_1 | 0 (omitted) m_2 | .0824508 .1924763 0.43 0.668 -.2950054 .4599069 m_3 | .3798902 .189451 2.01 0.045 .0083668 .7514135 m_4 | -.0769978 .196241 -0.39 0.695 -.4618367 .3078411 m_5 | .2040059 .1955668 1.04 0.297 -.179511 .5875228 m_6 | .4078988 .2220839 1.84 0.066 -.0276194 .843417 m_7 | .6253719 .1898075 3.29 0.001 .2531494 .9975944 m_8 | .1939075 .1801075 1.08 0.282 -.1592928 .5471077 m_9 | .0110579 .1796518 0.06 0.951 -.3412487 .3633644 m_10 | -.1533536 .1821192 -0.84 0.400 -.510499 .2037919 _cons | 7.475757 .1717116 43.54 0.000 7.139021 7.812493 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Gesamtnote.xls", se br sdec(3) bdec(3) append OUTPUT\Gesamtnote.xls . . reg gesamtnote name_non_GER , robust Linear regression Number of obs = 1570 F( 1, 1568) = 14.93 Prob > F = 0.0001 R-squared = 0.0083 Root MSE = 2.1177 ------------------------------------------------------------------------------ | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- name_non_GER | -.7384362 .1910814 -3.86 0.000 -1.113238 -.3636343 _cons | 7.741884 .0558389 138.65 0.000 7.632358 7.851411 ------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Gesamtnote.xls", se br sdec(3) bdec(3) append OUTPUT\Gesamtnote.xls . reg gesamtnote abinote_normiert name_non_GER female abschicht age_Q1 age_Q2 age_Q4 , robust Linear regression Number of obs = 1560 F( 7, 1552) = 90.35 Prob > F = 0.0000 R-squared = 0.2677 Root MSE = 1.8225 ---------------------------------------------------------------------------------- | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.531024 .0831766 18.41 0.000 1.367874 1.694174 name_non_GER | -.5221021 .1730367 -3.02 0.003 -.8615124 -.1826918 female | -.6567882 .0964804 -6.81 0.000 -.8460339 -.4675425 abschicht | .4704061 .1227921 3.83 0.000 .2295502 .7112619 age_Q1 | .4272811 .1368875 3.12 0.002 .1587771 .6957852 age_Q2 | .2944703 .1240083 2.37 0.018 .0512288 .5377117 age_Q4 | -.3075325 .1402774 -2.19 0.029 -.5826858 -.0323793 _cons | 7.686847 .1060428 72.49 0.000 7.478844 7.894849 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Gesamtnote.xls", se br sdec(3) bdec(3) append OUTPUT\Gesamtnote.xls . reg gesamtnote abinote_normiert name_non_GER female abschicht age_Q1 age_Q2 age_Q4 y200708 y200809 m_1-m_10, robust note: m_6 omitted because of collinearity Linear regression Number of obs = 1560 F( 18, 1541) = 37.95 Prob > F = 0.0000 R-squared = 0.2803 Root MSE = 1.8132 ---------------------------------------------------------------------------------- | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.572092 .0835861 18.81 0.000 1.408137 1.736046 name_non_GER | -.4870489 .1719146 -2.83 0.005 -.8242602 -.1498375 female | -.6981426 .0970631 -7.19 0.000 -.8885324 -.5077528 abschicht | .5499216 .1378073 3.99 0.000 .279612 .8202311 age_Q1 | .561845 .1423417 3.95 0.000 .282641 .8410489 age_Q2 | .3508062 .1242832 2.82 0.005 .1070241 .5945884 age_Q4 | -.3269456 .1401425 -2.33 0.020 -.6018357 -.0520554 y200708 | .0976789 .1214613 0.80 0.421 -.1405679 .3359258 y200809 | .1259191 .1095426 1.15 0.251 -.0889493 .3407875 m_1 | -.4043271 .2662865 -1.52 0.129 -.9266493 .1179952 m_2 | -.5748721 .2616264 -2.20 0.028 -1.088053 -.0616907 m_3 | -.0508231 .2557835 -0.20 0.843 -.5525437 .4508974 m_4 | -.6893572 .2686836 -2.57 0.010 -1.216381 -.1623332 m_5 | -.2188488 .2684868 -0.82 0.415 -.745487 .3077894 m_6 | 0 (omitted) m_7 | .0381278 .2587195 0.15 0.883 -.4693516 .5456072 m_8 | -.3430555 .2465552 -1.39 0.164 -.8266748 .1405638 m_9 | -.4248807 .2493557 -1.70 0.089 -.9139931 .0642316 m_10 | -.6129124 .2533514 -2.42 0.016 -1.109862 -.1159625 _cons | 7.939033 .231654 34.27 0.000 7.484642 8.393423 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Gesamtnote.xls", se br sdec(3) bdec(3) append OUTPUT\Gesamtnote.xls . reg gesamtnote abinote_normiert non_ger female abschicht age_Q1 age_Q2 age_Q4 y200708 y200809 m_1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 1560 F( 18, 1541) = 38.02 Prob > F = 0.0000 R-squared = 0.2806 Root MSE = 1.8128 ---------------------------------------------------------------------------------- | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.57533 .0836276 18.84 0.000 1.411294 1.739366 non_ger | -.5845494 .2071415 -2.82 0.005 -.9908583 -.1782405 female | -.6824153 .0978406 -6.97 0.000 -.8743301 -.4905006 abschicht | .5512257 .1381127 3.99 0.000 .2803169 .8221344 age_Q1 | .5628896 .1427673 3.94 0.000 .2828509 .8429283 age_Q2 | .3425523 .1244306 2.75 0.006 .0984812 .5866235 age_Q4 | -.3288901 .1400933 -2.35 0.019 -.6036837 -.0540965 y200708 | .1045316 .1213817 0.86 0.389 -.1335591 .3426223 y200809 | .1254244 .1095444 1.14 0.252 -.0894474 .3402963 m_1 | 0 (omitted) m_2 | -.16455 .2213073 -0.74 0.457 -.5986454 .2695453 m_3 | .3484021 .2146344 1.62 0.105 -.0726042 .7694084 m_4 | -.2972519 .2307923 -1.29 0.198 -.7499521 .1554483 m_5 | .1782781 .2313588 0.77 0.441 -.2755332 .6320893 m_6 | .4049047 .2658448 1.52 0.128 -.1165512 .9263605 m_7 | .4412529 .2166743 2.04 0.042 .0162452 .8662606 m_8 | .0585662 .2049164 0.29 0.775 -.3433783 .4605107 m_9 | -.0321957 .2091029 -0.15 0.878 -.4423519 .3779606 m_10 | -.2096693 .2124858 -0.99 0.324 -.6264613 .2071226 _cons | 7.642772 .2046426 37.35 0.000 7.241365 8.04418 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Gesamtnote.xls", se br sdec(3) bdec(3) append OUTPUT\Gesamtnote.xls . reg gesamtnote abinote_normiert name_AltEuropa name_SuedOst name_UDSSR name_mitOst name_rest female abschicht age_Q1 age_Q2 age_Q4 y200708 y200809 m_ > 1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 1560 F( 22, 1537) = 31.46 Prob > F = 0.0000 R-squared = 0.2824 Root MSE = 1.813 ---------------------------------------------------------------------------------- | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.576771 .0836791 18.84 0.000 1.412634 1.740908 name_AltEuropa | -.0536005 .317321 -0.17 0.866 -.6760283 .5688273 name_SuedOst | -.2247545 .3939454 -0.57 0.568 -.9974817 .5479727 name_UDSSR | -.9466557 .4772535 -1.98 0.047 -1.882792 -.0105189 name_mitOst | -.7675248 .3024331 -2.54 0.011 -1.36075 -.1742996 name_rest | -.8521446 .3074114 -2.77 0.006 -1.455135 -.2491546 female | -.6914267 .097057 -7.12 0.000 -.8818049 -.5010485 abschicht | .5413108 .1375995 3.93 0.000 .2714082 .8112133 age_Q1 | .5523546 .1418019 3.90 0.000 .2742089 .8305003 age_Q2 | .3385725 .1243697 2.72 0.007 .0946203 .5825248 age_Q4 | -.3258083 .1398786 -2.33 0.020 -.6001813 -.0514353 y200708 | .0939176 .1214295 0.77 0.439 -.1442674 .3321025 y200809 | .1228238 .1098065 1.12 0.264 -.0925625 .3382101 m_1 | 0 (omitted) m_2 | -.1661062 .2213737 -0.75 0.453 -.6003327 .2681203 m_3 | .3440109 .215703 1.59 0.111 -.0790924 .7671142 m_4 | -.2686745 .2312787 -1.16 0.246 -.7223297 .1849807 m_5 | .1967535 .2310927 0.85 0.395 -.2565369 .6500438 m_6 | .393626 .2667012 1.48 0.140 -.1295106 .9167627 m_7 | .4358178 .2171514 2.01 0.045 .0098736 .8617621 m_8 | .0463936 .2066693 0.22 0.822 -.35899 .4517771 m_9 | -.0179526 .209765 -0.09 0.932 -.4294085 .3935033 m_10 | -.2119183 .2132101 -0.99 0.320 -.6301318 .2062951 _cons | 7.540763 .1971643 38.25 0.000 7.154024 7.927503 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Gesamtnote.xls", se br sdec(3) bdec(3) append OUTPUT\Gesamtnote.xls . reg gesamtnote abinote_normiert name_WestE name_MediterBalkan name_OstE name_mitOst2 name_rest2 female abschicht age_Q1 age_Q2 age_Q4 y200708 y200809 m_ > 1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 1560 F( 22, 1537) = 31.40 Prob > F = 0.0000 R-squared = 0.2821 Root MSE = 1.8134 ------------------------------------------------------------------------------------ | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------------+---------------------------------------------------------------- abinote_normiert | 1.570482 .0833885 18.83 0.000 1.406915 1.73405 name_WestE | -.1743812 .3988351 -0.44 0.662 -.9566997 .6079373 name_MediterBalkan | -.0741797 .3380096 -0.22 0.826 -.7371885 .5888291 name_OstE | -.4478075 .3443669 -1.30 0.194 -1.123286 .2276711 name_mitOst2 | -.8999414 .3002537 -3.00 0.003 -1.488892 -.3109913 name_rest2 | -.8949014 .4289351 -2.09 0.037 -1.736261 -.0535415 female | -.6983923 .0972874 -7.18 0.000 -.8892224 -.5075623 abschicht | .5503079 .1376331 4.00 0.000 .2803394 .8202764 age_Q1 | .5590663 .1422411 3.93 0.000 .2800592 .8380734 age_Q2 | .3464432 .1247783 2.78 0.006 .1016895 .5911969 age_Q4 | -.3264277 .1401196 -2.33 0.020 -.6012735 -.051582 y200708 | .093301 .1215819 0.77 0.443 -.1451829 .331785 y200809 | .1217267 .1095662 1.11 0.267 -.0931883 .3366418 m_1 | 0 (omitted) m_2 | -.1664218 .2223319 -0.75 0.454 -.6025278 .2696842 m_3 | .3510935 .2163605 1.62 0.105 -.0732995 .7754866 m_4 | -.266163 .2316921 -1.15 0.251 -.720629 .188303 m_5 | .2014884 .2318819 0.87 0.385 -.25335 .6563268 m_6 | .4109491 .2668497 1.54 0.124 -.1124789 .934377 m_7 | .448984 .2178203 2.06 0.039 .0217277 .8762404 m_8 | .0626999 .2060974 0.30 0.761 -.341562 .4669617 m_9 | -.0228517 .2105328 -0.11 0.914 -.4358136 .3901103 m_10 | -.2075795 .2137463 -0.97 0.332 -.6268446 .2116857 _cons | 7.534682 .1974705 38.16 0.000 7.147342 7.922022 ------------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Gesamtnote.xls", se br sdec(3) bdec(3) append OUTPUT\Gesamtnote.xls . . . reg gesamtnote abinote abinote_Muenster female abschicht age_Q1 age_Q2 age_Q4 Muenster y200708 y200809 m_1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 2200 F( 19, 2180) = 45.40 Prob > F = 0.0000 R-squared = 0.2658 Root MSE = 1.8141 ---------------------------------------------------------------------------------- | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote | -1.060216 .1245371 -8.51 0.000 -1.30444 -.8159924 abinote_Muenster | -.5309544 .1452339 -3.66 0.000 -.8157657 -.2461431 female | -.7111042 .0801908 -8.87 0.000 -.8683626 -.5538458 abschicht | .4231353 .1220355 3.47 0.001 .1838173 .6624532 age_Q1 | .5884351 .1222196 4.81 0.000 .348756 .8281142 age_Q2 | .3176255 .1075747 2.95 0.003 .1066659 .5285851 age_Q4 | -.3685429 .1119312 -3.29 0.001 -.5880458 -.14904 Muenster | 1.346175 .3564276 3.78 0.000 .6472015 2.045148 y200708 | .0854793 .1040636 0.82 0.412 -.118595 .2895535 y200809 | .0765919 .090976 0.84 0.400 -.1018169 .2550007 m_1 | 0 (omitted) m_2 | .0865139 .1922318 0.45 0.653 -.2904629 .4634907 m_3 | .4102875 .1894291 2.17 0.030 .0388071 .7817678 m_4 | -.061771 .1975502 -0.31 0.755 -.4491773 .3256353 m_5 | .2181724 .1954078 1.12 0.264 -.1650327 .6013775 m_6 | .4464423 .2213617 2.02 0.044 .0123404 .8805443 m_7 | .6777325 .1894888 3.58 0.000 .306135 1.04933 m_8 | .2113919 .1805794 1.17 0.242 -.1427338 .5655177 m_9 | .0220033 .1801893 0.12 0.903 -.3313575 .3753641 m_10 | -.1583313 .1825513 -0.87 0.386 -.5163241 .1996614 _cons | 9.498979 .35421 26.82 0.000 8.804355 10.1936 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Gesamtnote_interaktion.xls", se br sdec(3) bdec(3) replace OUTPUT\Gesamtnote_interaktion.xls . reg gesamtnote abinote female fem_Boch fem_Biel abschicht age_Q1 age_Q2 age_Q4 Bochum Bielefeld y200708 y200809 m_1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 2200 F( 21, 2178) = 41.72 Prob > F = 0.0000 R-squared = 0.2655 Root MSE = 1.8152 ------------------------------------------------------------------------------ | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- abinote | -1.440115 .070029 -20.56 0.000 -1.577446 -1.302785 female | -.6995073 .095678 -7.31 0.000 -.8871371 -.5118776 fem_Boch | -.0877767 .212959 -0.41 0.680 -.5054007 .3298473 fem_Biel | -.0307461 .2364106 -0.13 0.897 -.4943601 .4328678 abschicht | .4526399 .1218856 3.71 0.000 .2136158 .6916641 age_Q1 | .6040758 .121645 4.97 0.000 .3655234 .8426282 age_Q2 | .3208978 .1074158 2.99 0.003 .1102497 .531546 age_Q4 | -.3759093 .1126902 -3.34 0.001 -.5969009 -.1549177 Bochum | -.3456613 .15032 -2.30 0.022 -.6404468 -.0508758 Bielefeld | .1458916 .175293 0.83 0.405 -.1978673 .4896505 y200708 | .073212 .1047466 0.70 0.485 -.1322017 .2786256 y200809 | .0762018 .0910881 0.84 0.403 -.1024268 .2548305 m_1 | 0 (omitted) m_2 | .0793196 .192736 0.41 0.681 -.2986461 .4572852 m_3 | .3776399 .1899989 1.99 0.047 .0050417 .750238 m_4 | -.0786065 .196628 -0.40 0.689 -.4642046 .3069915 m_5 | .2009081 .1963321 1.02 0.306 -.1841097 .5859259 m_6 | .4055498 .2223153 1.82 0.068 -.0304225 .8415221 m_7 | .6253532 .1901203 3.29 0.001 .2525171 .9981893 m_8 | .1904224 .180576 1.05 0.292 -.1636968 .5445416 m_9 | .009689 .1801497 0.05 0.957 -.3435942 .3629723 m_10 | -.1544786 .1825078 -0.85 0.397 -.5123862 .203429 _cons | 10.54129 .2456309 42.92 0.000 10.0596 11.02299 ------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Gesamtnote_interaktion.xls", se br sdec(3) bdec(3) append OUTPUT\Gesamtnote_interaktion.xls . reg gesamtnote abinote female fem_Muen abschicht age_Q1 age_Q2 age_Q4 Muenster y200708 y200809 m_1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 2200 F( 19, 2180) = 44.59 Prob > F = 0.0000 R-squared = 0.2612 Root MSE = 1.8197 ------------------------------------------------------------------------------ | Robust gesamtnote | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- abinote | -1.429407 .0704631 -20.29 0.000 -1.567589 -1.291225 female | -.7181315 .1440755 -4.98 0.000 -1.000671 -.4355918 fem_Muen | .0211338 .1719432 0.12 0.902 -.3160558 .3583234 abschicht | .4582225 .1219537 3.76 0.000 .219065 .6973801 age_Q1 | .6007805 .1221718 4.92 0.000 .3611952 .8403658 age_Q2 | .3140215 .1078489 2.91 0.004 .1025241 .5255189 age_Q4 | -.3618039 .1126421 -3.21 0.001 -.5827011 -.1409067 Muenster | .1287722 .1249131 1.03 0.303 -.116189 .3737335 y200708 | .0927884 .1043534 0.89 0.374 -.1118542 .297431 y200809 | .0770598 .0913611 0.84 0.399 -.1021041 .2562238 m_1 | 0 (omitted) m_2 | .1027384 .1923588 0.53 0.593 -.2744873 .4799642 m_3 | .4129015 .1903797 2.17 0.030 .0395568 .7862462 m_4 | -.0525663 .1980104 -0.27 0.791 -.4408752 .3357426 m_5 | .2314865 .1955976 1.18 0.237 -.1520906 .6150636 m_6 | .4253794 .2213911 1.92 0.055 -.0087803 .8595391 m_7 | .669528 .190923 3.51 0.000 .2951179 1.043938 m_8 | .219064 .1806486 1.21 0.225 -.1351975 .5733255 m_9 | .0307766 .180206 0.17 0.864 -.3226169 .3841701 m_10 | -.1576651 .1827566 -0.86 0.388 -.5160604 .2007302 _cons | 10.36128 .2643959 39.19 0.000 9.842785 10.87977 ------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Gesamtnote_interaktion.xls", se br sdec(3) bdec(3) append OUTPUT\Gesamtnote_interaktion.xls . . . ** III.1 - Abhängige Variable: Teilnoten . * schriftliche note: . reg note_schr abinote_normiert female abschicht age_Q1 age_Q2 age_Q4 Bochum Bielefeld y200708 y200809 m_1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 2200 F( 19, 2180) = 42.95 Prob > F = 0.0000 R-squared = 0.2561 Root MSE = 1.8066 ---------------------------------------------------------------------------------- | Robust note_schriftl | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.33553 .0687415 19.43 0.000 1.200724 1.470336 female | -.6862517 .0798489 -8.59 0.000 -.8428396 -.5296637 abschicht | .4685164 .1247304 3.76 0.000 .2239135 .7131193 age_Q1 | .6530666 .120323 5.43 0.000 .4171068 .8890263 age_Q2 | .3047624 .1083946 2.81 0.005 .0921948 .51733 age_Q4 | -.2977 .1098564 -2.71 0.007 -.5131342 -.0822658 Bochum | -.5378607 .1089488 -4.94 0.000 -.7515151 -.3242064 Bielefeld | -.012158 .1127022 -0.11 0.914 -.2331729 .2088569 y200708 | .018674 .1031527 0.18 0.856 -.1836139 .2209619 y200809 | -.0231837 .0912179 -0.25 0.799 -.2020668 .1556994 m_1 | 0 (omitted) m_2 | .0405551 .1884567 0.22 0.830 -.3290184 .4101286 m_3 | .4660752 .1860022 2.51 0.012 .101315 .8308354 m_4 | -.0509386 .1906211 -0.27 0.789 -.4247566 .3228794 m_5 | .1338951 .1919294 0.70 0.485 -.2424886 .5102787 m_6 | .3456218 .213877 1.62 0.106 -.0738023 .7650459 m_7 | .8258886 .1899427 4.35 0.000 .453401 1.198376 m_8 | .049485 .1775606 0.28 0.781 -.2987206 .3976907 m_9 | -.0405361 .1748321 -0.23 0.817 -.383391 .3023189 m_10 | -.2884362 .1736433 -1.66 0.097 -.6289599 .0520875 _cons | 6.746675 .16727 40.33 0.000 6.41865 7.0747 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten.xls", se br sdec(3) bdec(3) replace OUTPUT\Teilnoten.xls . reg note_z Bochum Bielefeld y200708 y200809 , robust Linear regression Number of obs = 2217 F( 4, 2212) = 23.98 Prob > F = 0.0000 R-squared = 0.0356 Root MSE = 2.3372 ------------------------------------------------------------------------------ | Robust note_z | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- Bochum | -1.138871 .1290213 -8.83 0.000 -1.391887 -.8858557 Bielefeld | -.6633001 .1360324 -4.88 0.000 -.9300647 -.3965355 y200708 | .2416615 .1255454 1.92 0.054 -.0045377 .4878608 y200809 | .1115238 .1166107 0.96 0.339 -.117154 .3402016 _cons | 6.788547 .0829577 81.83 0.000 6.625864 6.95123 ------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Teilnoten.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten.xls . reg note_z abinote_normiert female abschicht age_Q1 age_Q2 age_Q4 Bochum Bielefeld y200708 y200809 m_1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 2200 F( 19, 2180) = 32.39 Prob > F = 0.0000 R-squared = 0.2108 Root MSE = 2.1214 ---------------------------------------------------------------------------------- | Robust note_z | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.34177 .078342 17.13 0.000 1.188137 1.495403 female | -.7556703 .0945322 -7.99 0.000 -.9410528 -.5702877 abschicht | .3472666 .1461638 2.38 0.018 .0606316 .6339016 age_Q1 | .6740137 .1397374 4.82 0.000 .3999812 .9480462 age_Q2 | .2956596 .1279008 2.31 0.021 .0448394 .5464798 age_Q4 | -.3611987 .1301432 -2.78 0.006 -.6164164 -.105981 Bochum | -.6928711 .1250135 -5.54 0.000 -.9380292 -.447713 Bielefeld | -.0115821 .1293411 -0.09 0.929 -.2652268 .2420627 y200708 | .1382263 .1185528 1.17 0.244 -.094262 .3707147 y200809 | .1632179 .1089091 1.50 0.134 -.0503586 .3767944 m_1 | 0 (omitted) m_2 | .0301152 .2285662 0.13 0.895 -.4181151 .4783455 m_3 | .4221076 .2189776 1.93 0.054 -.007319 .8515342 m_4 | -.1710651 .2237531 -0.76 0.445 -.6098567 .2677264 m_5 | .1393538 .2315048 0.60 0.547 -.3146393 .593347 m_6 | .418412 .2536076 1.65 0.099 -.0789259 .91575 m_7 | .945047 .2291789 4.12 0.000 .4956151 1.394479 m_8 | .0458502 .2173349 0.21 0.833 -.3803549 .4720554 m_9 | .1538638 .2093343 0.74 0.462 -.2566518 .5643794 m_10 | -.4151465 .2046539 -2.03 0.043 -.8164837 -.0138093 _cons | 6.680986 .200831 33.27 0.000 6.287146 7.074826 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten.xls . reg note_r Bochum Bielefeld y200708 y200809 , robust Linear regression Number of obs = 2217 F( 4, 2212) = 11.01 Prob > F = 0.0000 R-squared = 0.0183 Root MSE = 2.6735 ------------------------------------------------------------------------------ | Robust note_r | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- Bochum | -.9134701 .1591843 -5.74 0.000 -1.225636 -.6013038 Bielefeld | -.6023992 .1573983 -3.83 0.000 -.9110631 -.2937352 y200708 | -.0491447 .1467605 -0.33 0.738 -.3369475 .238658 y200809 | -.1634271 .1312946 -1.24 0.213 -.4209007 .0940464 _cons | 7.06215 .0935635 75.48 0.000 6.878669 7.245632 ------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Teilnoten.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten.xls . reg note_r abinote_normiert female abschicht age_Q1 age_Q2 age_Q4 Bochum Bielefeld y200708 y200809 m_1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 2200 F( 19, 2180) = 20.34 Prob > F = 0.0000 R-squared = 0.1452 Root MSE = 2.5042 ---------------------------------------------------------------------------------- | Robust note_r | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.386441 .0960549 14.43 0.000 1.198072 1.57481 female | -.6623523 .1106077 -5.99 0.000 -.8792599 -.4454446 abschicht | .4182106 .1727053 2.42 0.016 .0795265 .7568947 age_Q1 | .5191937 .1641407 3.16 0.002 .1973051 .8410824 age_Q2 | .1681468 .1511262 1.11 0.266 -.1282198 .4645133 age_Q4 | -.2529957 .1511293 -1.67 0.094 -.5493683 .0433769 Bochum | -.4396262 .1592799 -2.76 0.006 -.7519824 -.1272699 Bielefeld | .0860353 .1555449 0.55 0.580 -.2189964 .391067 y200708 | -.147092 .1432738 -1.03 0.305 -.4280595 .1338754 y200809 | -.1539196 .1252307 -1.23 0.219 -.3995036 .0916644 m_1 | 0 (omitted) m_2 | -.1765353 .2566844 -0.69 0.492 -.6799069 .3268363 m_3 | .2848194 .2460083 1.16 0.247 -.1976158 .7672546 m_4 | -.1215377 .2541058 -0.48 0.632 -.6198526 .3767771 m_5 | -.2370458 .2572095 -0.92 0.357 -.7414473 .2673557 m_6 | -.0953781 .2933612 -0.33 0.745 -.6706749 .4799186 m_7 | .4466502 .2491007 1.79 0.073 -.0418495 .9351499 m_8 | -.1570765 .2418595 -0.65 0.516 -.6313757 .3172228 m_9 | -.5235572 .2339269 -2.24 0.025 -.9823003 -.0648141 m_10 | -.4654839 .2314151 -2.01 0.044 -.9193011 -.0116668 _cons | 7.219854 .2193281 32.92 0.000 6.78974 7.649968 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten.xls . reg note_s Bochum Bielefeld y200708 y200809 , robust Linear regression Number of obs = 2217 F( 4, 2212) = 11.60 Prob > F = 0.0000 R-squared = 0.0197 Root MSE = 3.076 ------------------------------------------------------------------------------ | Robust note_s | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- Bochum | -.7828022 .1771532 -4.42 0.000 -1.130206 -.4353982 Bielefeld | -.8802181 .1864459 -4.72 0.000 -1.245846 -.5145907 y200708 | .0063036 .1629271 0.04 0.969 -.3132024 .3258097 y200809 | -.4344559 .1529707 -2.84 0.005 -.7344372 -.1344746 _cons | 7.020284 .1094208 64.16 0.000 6.805706 7.234862 ------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Teilnoten.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten.xls . reg note_s abinote_normiert female abschicht age_Q1 age_Q2 age_Q4 Bochum Bielefeld y200708 y200809 m_1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 2200 F( 19, 2180) = 18.15 Prob > F = 0.0000 R-squared = 0.1307 Root MSE = 2.905 ---------------------------------------------------------------------------------- | Robust note_s | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.214988 .1128035 10.77 0.000 .9937748 1.436202 female | -.5257948 .1281883 -4.10 0.000 -.7771787 -.2744108 abschicht | .9328775 .1987768 4.69 0.000 .5430656 1.322689 age_Q1 | .8579709 .191626 4.48 0.000 .4821821 1.23376 age_Q2 | .605302 .1716797 3.53 0.000 .268629 .9419749 age_Q4 | -.1966126 .1771847 -1.11 0.267 -.5440811 .1508559 Bochum | -.2692987 .1745893 -1.54 0.123 -.6116776 .0730802 Bielefeld | -.2102722 .1855658 -1.13 0.257 -.5741766 .1536323 y200708 | -.0084509 .161525 -0.05 0.958 -.32521 .3083083 y200809 | -.3209164 .1476909 -2.17 0.030 -.6105461 -.0312867 m_1 | 0 (omitted) m_2 | .5060558 .2959022 1.71 0.087 -.0742241 1.086336 m_3 | .9604895 .3002625 3.20 0.001 .3716589 1.54932 m_4 | .4506391 .3220478 1.40 0.162 -.1809136 1.082192 m_5 | .8594004 .3083222 2.79 0.005 .2547644 1.464036 m_6 | 1.009251 .3377404 2.99 0.003 .3469241 1.671577 m_7 | 1.22689 .3082186 3.98 0.000 .6224574 1.831323 m_8 | .4735122 .3031192 1.56 0.118 -.1209207 1.067945 m_9 | .3423065 .2809706 1.22 0.223 -.2086917 .8933046 m_10 | .4457901 .2912699 1.53 0.126 -.1254055 1.016986 _cons | 5.997383 .2662139 22.53 0.000 5.475324 6.519443 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten.xls . * mündl.note: . reg note_muendl Bochum Bielefeld y200708 y200809 , robust Linear regression Number of obs = 2217 F( 4, 2212) = 5.98 Prob > F = 0.0001 R-squared = 0.0100 Root MSE = 2.6177 ------------------------------------------------------------------------------ | Robust note_muendl | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- Bochum | -.6308737 .1486292 -4.24 0.000 -.9223411 -.3394063 Bielefeld | -.4646044 .1665483 -2.79 0.005 -.7912117 -.1379971 y200708 | .1319423 .1409023 0.94 0.349 -.1443723 .4082569 y200809 | .0776505 .1299121 0.60 0.550 -.177112 .3324129 _cons | 8.770219 .0910671 96.30 0.000 8.591633 8.948805 ------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Teilnoten.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten.xls . reg note_muendl abinote_normiert female abschicht age_Q1 age_Q2 age_Q4 Bochum Bielefeld y200708 y200809 m_1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 2200 F( 19, 2180) = 30.09 Prob > F = 0.0000 R-squared = 0.1947 Root MSE = 2.371 ---------------------------------------------------------------------------------- | Robust note_muendl | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.59463 .0913291 17.46 0.000 1.415529 1.773731 female | -.7632443 .1051252 -7.26 0.000 -.9694005 -.5570882 abschicht | .4288325 .1544278 2.78 0.006 .1259915 .7316734 age_Q1 | .5310018 .1583521 3.35 0.001 .2204649 .8415387 age_Q2 | .3438946 .139514 2.46 0.014 .0703004 .6174889 age_Q4 | -.4982799 .1494125 -3.33 0.001 -.7912857 -.2052741 Bochum | -.1580638 .142672 -1.11 0.268 -.4378512 .1217235 Bielefeld | .3468192 .1585496 2.19 0.029 .0358952 .6577433 y200708 | .1466812 .1346126 1.09 0.276 -.1173012 .4106636 y200809 | .2248586 .1208715 1.86 0.063 -.0121768 .4618939 m_1 | 0 (omitted) m_2 | .1484116 .258514 0.57 0.566 -.358548 .6553711 m_3 | .2535172 .2478195 1.02 0.306 -.23247 .7395044 m_4 | -.1253479 .2571933 -0.49 0.626 -.6297175 .3790217 m_5 | .2962303 .2535681 1.17 0.243 -.2010302 .7934907 m_6 | .5039346 .2975027 1.69 0.090 -.0794838 1.087353 m_7 | .3281532 .2486457 1.32 0.187 -.1594541 .8157605 m_8 | .4104642 .2384588 1.72 0.085 -.0571662 .8780946 m_9 | .0896713 .2382091 0.38 0.707 -.3774692 .5568119 m_10 | .0512688 .2424047 0.21 0.833 -.4240995 .5266371 _cons | 8.5706 .2245558 38.17 0.000 8.130234 9.010966 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten.xls . reg note_muendl abinote_normiert note_schr female abschicht age_Q1 age_Q2 age_Q4 Bochum Bielefeld y200708 y200809 m_1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 2200 F( 20, 2179) = 107.29 Prob > F = 0.0000 R-squared = 0.4753 Root MSE = 1.9144 ---------------------------------------------------------------------------------- | Robust note_muendl | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | .5600748 .0802878 6.98 0.000 .4026261 .7175234 note_schriftl | .7746403 .0233341 33.20 0.000 .7288809 .8203997 female | -.2316461 .0876594 -2.64 0.008 -.4035508 -.0597414 abschicht | .0659008 .1260353 0.52 0.601 -.1812612 .3130627 age_Q1 | .0251101 .1267306 0.20 0.843 -.2234153 .2736356 age_Q2 | .1078134 .114647 0.94 0.347 -.1170155 .3326424 age_Q4 | -.2676695 .1194135 -2.24 0.025 -.5018457 -.0334932 Bochum | .2585848 .1161928 2.23 0.026 .0307246 .4864449 Bielefeld | .3562373 .1246267 2.86 0.004 .1118376 .600637 y200708 | .1322156 .1047986 1.26 0.207 -.0733002 .3377313 y200809 | .2428176 .100459 2.42 0.016 .045812 .4398231 m_1 | 0 (omitted) m_2 | .1169959 .2108303 0.55 0.579 -.2964535 .5304453 m_3 | -.1075234 .1962365 -0.55 0.584 -.4923537 .2773069 m_4 | -.0858888 .2007642 -0.43 0.669 -.4795981 .3078205 m_5 | .1925097 .1989788 0.97 0.333 -.1976984 .5827179 m_6 | .236202 .2361046 1.00 0.317 -.2268117 .6992158 m_7 | -.3116134 .2028607 -1.54 0.125 -.709434 .0862072 m_8 | .3721311 .1929502 1.93 0.054 -.0062545 .7505167 m_9 | .1210722 .1893425 0.64 0.523 -.2502386 .492383 m_10 | .2747031 .1877325 1.46 0.144 -.0934504 .6428566 _cons | 3.344353 .2356214 14.19 0.000 2.882287 3.80642 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten.xls . . . ** III.2 - Abhängige Variable: Teilnoten unter Berücksichtung der Namens-Kodierung . * (=> damit einschränkung auf Münster Sample) . . reg note_schr abinote_normiert name_non_GER female abschicht age_Q1 age_Q2 age_Q4 y200708 y200809 m_1-m_10, robust note: m_6 omitted because of collinearity Linear regression Number of obs = 1560 F( 18, 1541) = 34.07 Prob > F = 0.0000 R-squared = 0.2611 Root MSE = 1.8284 ---------------------------------------------------------------------------------- | Robust note_schriftl | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.48362 .0829313 17.89 0.000 1.32095 1.64629 name_non_GER | -.4262669 .1605613 -2.65 0.008 -.7412087 -.1113252 female | -.6990478 .0976403 -7.16 0.000 -.8905697 -.5075259 abschicht | .5655769 .1422016 3.98 0.000 .2866477 .844506 age_Q1 | .625525 .1417528 4.41 0.000 .3474761 .9035738 age_Q2 | .3436903 .1272488 2.70 0.007 .0940913 .5932894 age_Q4 | -.2086004 .1380512 -1.51 0.131 -.4793884 .0621876 y200708 | .0068414 .1205582 0.06 0.955 -.229634 .2433169 y200809 | .0525334 .1111323 0.47 0.636 -.1654531 .27052 m_1 | -.3402466 .2516674 -1.35 0.177 -.8338932 .1534001 m_2 | -.4558685 .2522597 -1.81 0.071 -.950677 .03894 m_3 | .1361511 .246956 0.55 0.581 -.3482542 .6205564 m_4 | -.4766861 .2551921 -1.87 0.062 -.9772466 .0238744 m_5 | -.1501096 .2589985 -0.58 0.562 -.6581364 .3579172 m_6 | 0 (omitted) m_7 | .3936532 .2545579 1.55 0.122 -.1056634 .8929698 m_8 | -.3518498 .2379627 -1.48 0.139 -.8186148 .1149152 m_9 | -.3294553 .2374985 -1.39 0.166 -.7953096 .1363991 m_10 | -.6637803 .237202 -2.80 0.005 -1.129053 -.1985076 _cons | 7.080634 .220415 32.12 0.000 6.648289 7.512979 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten_Muenster.xls", se br sdec(3) bdec(3) replace OUTPUT\Teilnoten_Muenster.xls . reg note_schr abinote_normiert non_ger female abschicht age_Q1 age_Q2 age_Q4 y200708 y200809 m_1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 1560 F( 18, 1541) = 34.06 Prob > F = 0.0000 R-squared = 0.2606 Root MSE = 1.8289 ---------------------------------------------------------------------------------- | Robust note_schriftl | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.486769 .0829717 17.92 0.000 1.32402 1.649519 non_ger | -.4490947 .1994999 -2.25 0.025 -.8404147 -.0577747 female | -.6887303 .0986265 -6.98 0.000 -.8821866 -.4952741 abschicht | .5660125 .1424213 3.97 0.000 .2866524 .8453725 age_Q1 | .6289866 .1421468 4.42 0.000 .3501651 .9078082 age_Q2 | .3385446 .1273398 2.66 0.008 .0887669 .5883223 age_Q4 | -.2106772 .1380852 -1.53 0.127 -.4815321 .0601776 y200708 | .0128929 .120643 0.11 0.915 -.2237488 .2495347 y200809 | .0522853 .111136 0.47 0.638 -.1657085 .2702791 m_1 | 0 (omitted) m_2 | -.109171 .2199939 -0.50 0.620 -.5406901 .3223481 m_3 | .4725677 .2138565 2.21 0.027 .0530873 .8920482 m_4 | -.1476859 .2241693 -0.66 0.510 -.587395 .2920232 m_5 | .1864891 .2303095 0.81 0.418 -.265264 .6382421 m_6 | .3399523 .2508234 1.36 0.176 -.152039 .8319436 m_7 | .7342876 .2212758 3.32 0.001 .3002541 1.168321 m_8 | -.0123843 .2053398 -0.06 0.952 -.4151592 .3903906 m_9 | .0011722 .205105 0.01 0.995 -.4011423 .4034867 m_10 | -.3254566 .2036092 -1.60 0.110 -.7248371 .0739239 _cons | 6.819292 .200983 33.93 0.000 6.425063 7.213521 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten_Muenster.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten_Muenster.xls . reg note_schr abinote_normiert name_AltEuropa name_SuedOst name_UDSSR name_mitOst name_rest female abschicht age_Q1 age_Q2 age_Q4 y200708 y200809 m_ > 1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 1560 F( 22, 1537) = 27.88 Prob > F = 0.0000 R-squared = 0.2616 Root MSE = 1.8301 ---------------------------------------------------------------------------------- | Robust note_schriftl | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.489717 .0833434 17.87 0.000 1.326238 1.653196 name_AltEuropa | -.2169549 .2972944 -0.73 0.466 -.8001005 .3661906 name_SuedOst | -.3527835 .3505294 -1.01 0.314 -1.04035 .3347829 name_UDSSR | -.7791418 .4209335 -1.85 0.064 -1.604806 .0465229 name_mitOst | -.4364022 .3061035 -1.43 0.154 -1.036827 .1640225 name_rest | -.6082448 .3506327 -1.73 0.083 -1.296014 .0795243 female | -.6954925 .0977754 -7.11 0.000 -.8872798 -.5037053 abschicht | .5607819 .142348 3.94 0.000 .2815651 .8399987 age_Q1 | .6183853 .1418719 4.36 0.000 .3401024 .8966682 age_Q2 | .3356609 .1277706 2.63 0.009 .0850378 .586284 age_Q4 | -.2081116 .1380749 -1.51 0.132 -.4789467 .0627235 y200708 | .0044519 .1206841 0.04 0.971 -.2322709 .2411747 y200809 | .0505809 .111541 0.45 0.650 -.1682078 .2693696 m_1 | 0 (omitted) m_2 | -.1160238 .2204622 -0.53 0.599 -.5484622 .3164147 m_3 | .4689066 .2152647 2.18 0.030 .046663 .8911501 m_4 | -.1340249 .2253745 -0.59 0.552 -.5760989 .3080492 m_5 | .1926411 .2303776 0.84 0.403 -.2592466 .6445288 m_6 | .3277162 .2525321 1.30 0.195 -.1676277 .8230602 m_7 | .7270565 .2220392 3.27 0.001 .2915246 1.162588 m_8 | -.0224622 .2065716 -0.11 0.913 -.4276541 .3827297 m_9 | .0113733 .2061293 0.06 0.956 -.3929512 .4156977 m_10 | -.3283845 .2044918 -1.61 0.109 -.729497 .072728 _cons | 6.747551 .1943239 34.72 0.000 6.366383 7.128719 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten_Muenster.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten_Muenster.xls . reg note_schr abinote_normiert name_WestE name_MediterBalkan name_OstE name_mitOst2 name_rest2 female abschicht age_Q1 age_Q2 age_Q4 y200708 y200809 m_1 > -m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 1560 F( 22, 1537) = 28.03 Prob > F = 0.0000 R-squared = 0.2616 Root MSE = 1.83 ------------------------------------------------------------------------------------ | Robust note_schriftl | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------------+---------------------------------------------------------------- abinote_normiert | 1.484539 .0830418 17.88 0.000 1.321652 1.647427 name_WestE | -.3385902 .3183546 -1.06 0.288 -.9630454 .2858651 name_MediterBalkan | -.1444412 .3372909 -0.43 0.669 -.8060402 .5171578 name_OstE | -.452085 .3047911 -1.48 0.138 -1.049935 .1457654 name_mitOst2 | -.5539403 .3023466 -1.83 0.067 -1.146996 .0391152 name_rest2 | -.7925618 .4604443 -1.72 0.085 -1.695727 .1106037 female | -.6976852 .0978675 -7.13 0.000 -.8896532 -.5057172 abschicht | .5664875 .1424257 3.98 0.000 .2871182 .8458567 age_Q1 | .6216642 .1420279 4.38 0.000 .3430753 .9002531 age_Q2 | .3409493 .1276956 2.67 0.008 .0904732 .5914254 age_Q4 | -.2084202 .138145 -1.51 0.132 -.4793928 .0625524 y200708 | .0042018 .1206767 0.03 0.972 -.2325066 .2409101 y200809 | .0492165 .1113733 0.44 0.659 -.1692432 .2676762 m_1 | 0 (omitted) m_2 | -.1174652 .2212933 -0.53 0.596 -.5515339 .3166035 m_3 | .4744443 .2157931 2.20 0.028 .0511643 .8977243 m_4 | -.1314153 .2258244 -0.58 0.561 -.5743719 .3115413 m_5 | .1992962 .2309299 0.86 0.388 -.2536748 .6522672 m_6 | .3360966 .2527113 1.33 0.184 -.1595987 .8317919 m_7 | .7331324 .222429 3.30 0.001 .2968361 1.169429 m_8 | -.0131746 .2064032 -0.06 0.949 -.4180362 .3916871 m_9 | .0079952 .2068283 0.04 0.969 -.3977004 .4136908 m_10 | -.3251186 .2049246 -1.59 0.113 -.7270799 .0768428 _cons | 6.742967 .1947482 34.62 0.000 6.360967 7.124968 ------------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Teilnoten_Muenster.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten_Muenster.xls . reg note_z abinote_normiert name_non_GER female abschicht age_Q1 age_Q2 age_Q4 y200708 y200809 m_1-m_10, robust note: m_6 omitted because of collinearity Linear regression Number of obs = 1560 F( 18, 1541) = 24.32 Prob > F = 0.0000 R-squared = 0.2081 Root MSE = 2.1691 ---------------------------------------------------------------------------------- | Robust note_z | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.510415 .0962103 15.70 0.000 1.321698 1.699132 name_non_GER | -.3950059 .2109045 -1.87 0.061 -.808696 .0186842 female | -.772094 .1158202 -6.67 0.000 -.9992759 -.5449121 abschicht | .4752783 .1675435 2.84 0.005 .146641 .8039157 age_Q1 | .6135424 .1659268 3.70 0.000 .2880763 .9390086 age_Q2 | .3575398 .1509026 2.37 0.018 .0615437 .653536 age_Q4 | -.2324341 .1657655 -1.40 0.161 -.5575839 .0927156 y200708 | .1329611 .1416973 0.94 0.348 -.1449787 .410901 y200809 | .235341 .1339631 1.76 0.079 -.0274283 .4981103 m_1 | -.4932715 .3032605 -1.63 0.104 -1.088118 .1015755 m_2 | -.6680675 .3003918 -2.22 0.026 -1.257287 -.0788475 m_3 | -.0972799 .2894284 -0.34 0.737 -.664995 .4704353 m_4 | -.7546334 .3029622 -2.49 0.013 -1.348895 -.1603718 m_5 | -.2534669 .3096794 -0.82 0.413 -.8609044 .3539706 m_6 | 0 (omitted) m_7 | .4102587 .3037013 1.35 0.177 -.1854529 1.00597 m_8 | -.520889 .2896933 -1.80 0.072 -1.089124 .0473457 m_9 | -.2346909 .2858935 -0.82 0.412 -.7954724 .3260906 m_10 | -.9086315 .2807976 -3.24 0.001 -1.459417 -.3578457 _cons | 7.13817 .2668044 26.75 0.000 6.614832 7.661508 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten_Muenster.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten_Muenster.xls . reg note_r abinote_normiert name_non_GER female abschicht age_Q1 age_Q2 age_Q4 y200708 y200809 m_1-m_10, robust note: m_6 omitted because of collinearity Linear regression Number of obs = 1560 F( 18, 1541) = 17.24 Prob > F = 0.0000 R-squared = 0.1578 Root MSE = 2.5122 ---------------------------------------------------------------------------------- | Robust note_r | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.54152 .1135024 13.58 0.000 1.318884 1.764155 name_non_GER | -.4354764 .2236616 -1.95 0.052 -.8741897 .0032368 female | -.6695662 .133927 -5.00 0.000 -.9322646 -.4068679 abschicht | .4819045 .1967313 2.45 0.014 .0960153 .8677938 age_Q1 | .5279561 .1918391 2.75 0.006 .1516628 .9042493 age_Q2 | .2319908 .1773545 1.31 0.191 -.1158908 .5798725 age_Q4 | -.1943535 .18849 -1.03 0.303 -.5640775 .1753706 y200708 | -.2145755 .1635127 -1.31 0.190 -.5353063 .1061554 y200809 | -.0832898 .1521635 -0.55 0.584 -.3817593 .2151797 m_1 | .2269432 .3444753 0.66 0.510 -.4487467 .9026332 m_2 | -.0127584 .3661691 -0.03 0.972 -.7310007 .7054839 m_3 | .5866563 .3471197 1.69 0.091 -.0942205 1.267533 m_4 | .0281191 .3576176 0.08 0.937 -.6733494 .7295875 m_5 | -.0158354 .3720005 -0.04 0.966 -.745516 .7138452 m_6 | 0 (omitted) m_7 | .5405476 .3551669 1.52 0.128 -.1561139 1.237209 m_8 | -.0432796 .3428306 -0.13 0.900 -.7157435 .6291843 m_9 | -.2903017 .3378723 -0.86 0.390 -.9530398 .3724364 m_10 | -.3730065 .3398431 -1.10 0.273 -1.03961 .2935974 _cons | 7.020205 .3113033 22.55 0.000 6.409583 7.630828 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten_Muenster.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten_Muenster.xls . reg note_s abinote_normiert name_non_GER female abschicht age_Q1 age_Q2 age_Q4 y200708 y200809 m_1-m_10, robust note: m_6 omitted because of collinearity Linear regression Number of obs = 1560 F( 18, 1541) = 13.98 Prob > F = 0.0000 R-squared = 0.1304 Root MSE = 2.9361 ---------------------------------------------------------------------------------- | Robust note_s | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.287436 .1391363 9.25 0.000 1.01452 1.560353 name_non_GER | -.5016309 .2546087 -1.97 0.049 -1.001047 -.0022147 female | -.5388725 .1562112 -3.45 0.001 -.8452815 -.2324634 abschicht | 1.003817 .2257132 4.45 0.000 .5610796 1.446555 age_Q1 | .8566104 .2270274 3.77 0.000 .4112951 1.301926 age_Q2 | .5255409 .2032977 2.59 0.010 .1267715 .9243103 age_Q4 | -.1655931 .2224593 -0.74 0.457 -.6019481 .2707619 y200708 | .0713162 .1921523 0.37 0.711 -.3055914 .4482237 y200809 | -.2242429 .1803389 -1.24 0.214 -.5779784 .1294927 m_1 | -1.015551 .3851911 -2.64 0.008 -1.771105 -.2599968 m_2 | -.7054915 .3656105 -1.93 0.054 -1.422638 .0116552 m_3 | -.064566 .37325 -0.17 0.863 -.7966976 .6675656 m_4 | -.6524543 .3975224 -1.64 0.101 -1.432196 .1272878 m_5 | -.1085862 .3803145 -0.29 0.775 -.8545748 .6374025 m_6 | 0 (omitted) m_7 | .0500483 .3831557 0.13 0.896 -.7015133 .8016099 m_8 | -.4618725 .376303 -1.23 0.220 -1.199993 .2762475 m_9 | -.6920553 .3489519 -1.98 0.048 -1.376526 -.0075846 m_10 | -.5107743 .3652534 -1.40 0.162 -1.227221 .2056718 _cons | 7.028882 .3148965 22.32 0.000 6.411211 7.646553 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten_Muenster.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten_Muenster.xls . * mündl.note: . reg note_muendl abinote_normiert name_non_GER female abschicht age_Q1 age_Q2 age_Q4 y200708 y200809 > m_1-m_10, robust note: m_6 omitted because of collinearity Linear regression Number of obs = 1560 F( 18, 1541) = 25.09 Prob > F = 0.0000 R-squared = 0.2122 Root MSE = 2.3588 ---------------------------------------------------------------------------------- | Robust note_muendl | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.703034 .1104881 15.41 0.000 1.486311 1.919757 name_non_GER | -.5738947 .235024 -2.44 0.015 -1.034895 -.1128941 female | -.6957689 .1268656 -5.48 0.000 -.9446164 -.4469214 abschicht | .5224343 .1740043 3.00 0.003 .181124 .8637445 age_Q1 | .4628652 .184802 2.50 0.012 .1003752 .8253552 age_Q2 | .3576193 .1624837 2.20 0.028 .0389068 .6763318 age_Q4 | -.5124985 .1848637 -2.77 0.006 -.8751094 -.1498875 y200708 | .2228942 .1567081 1.42 0.155 -.0844895 .530278 y200809 | .2376185 .1450126 1.64 0.101 -.0468245 .5220615 m_1 | -.5039936 .3621257 -1.39 0.164 -1.214305 .2063176 m_2 | -.752359 .3570216 -2.11 0.035 -1.452658 -.0520596 m_3 | -.3305097 .3445757 -0.96 0.338 -1.006396 .345377 m_4 | -1.02137 .366114 -2.79 0.005 -1.739505 -.3032359 m_5 | -.3439344 .3572085 -0.96 0.336 -1.0446 .3567317 m_6 | 0 (omitted) m_7 | -.4933105 .350162 -1.41 0.159 -1.180155 .1935338 m_8 | -.3332344 .3401865 -0.98 0.327 -1.000512 .3340429 m_9 | -.5703281 .3433417 -1.66 0.097 -1.243794 .1031381 m_10 | -.5375539 .3474323 -1.55 0.122 -1.219044 .1439361 _cons | 9.232076 .3155464 29.26 0.000 8.61313 9.851022 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten_Muenster.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten_Muenster.xls . reg note_muendl abinote_normiert non_ger female abschicht age_Q1 age_Q2 age_Q4 y200708 y200809 > m_1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 1560 F( 18, 1541) = 25.25 Prob > F = 0.0000 R-squared = 0.2136 Root MSE = 2.3568 ---------------------------------------------------------------------------------- | Robust note_muendl | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.706357 .1105628 15.43 0.000 1.489488 1.923227 non_ger | -.7866648 .2747784 -2.86 0.004 -1.325644 -.2476858 female | -.6718391 .1273191 -5.28 0.000 -.921576 -.4221021 abschicht | .5250761 .174281 3.01 0.003 .1832231 .8669292 age_Q1 | .4601068 .1850504 2.49 0.013 .0971297 .823084 age_Q2 | .3446392 .1627943 2.12 0.034 .0253173 .663961 age_Q4 | -.5142027 .1846513 -2.78 0.005 -.876397 -.1520083 y200708 | .2308843 .1563251 1.48 0.140 -.075748 .5375166 y200809 | .2367462 .1449844 1.63 0.103 -.0476414 .5211339 m_1 | 0 (omitted) m_2 | -.2431871 .2900285 -0.84 0.402 -.8120794 .3257052 m_3 | .1664777 .2763977 0.60 0.547 -.3756777 .7086331 m_4 | -.5309165 .3016019 -1.76 0.079 -1.12251 .0606771 m_5 | .1474193 .2907991 0.51 0.612 -.4229845 .7178231 m_6 | .5059267 .3626583 1.40 0.163 -.2054292 1.217283 m_7 | .0070123 .2823451 0.02 0.980 -.546809 .5608335 m_8 | .1650867 .2693868 0.61 0.540 -.3633166 .6934901 m_9 | -.080945 .275388 -0.29 0.769 -.6211198 .4592297 m_10 | -.0333121 .2788664 -0.12 0.905 -.5803098 .5136856 _cons | 8.879967 .2639023 33.65 0.000 8.362321 9.397612 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten_Muenster.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten_Muenster.xls . reg note_muendl abinote_normiert name_AltEuropa name_SuedOst name_UDSSR name_mitOst name_rest female abschicht age_Q1 age_Q2 age_Q4 y200708 y200809 m > _1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 1560 F( 22, 1537) = 21.51 Prob > F = 0.0000 R-squared = 0.2168 Root MSE = 2.3549 ---------------------------------------------------------------------------------- | Robust note_muendl | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | 1.705567 .1102576 15.47 0.000 1.489296 1.921839 name_AltEuropa | .1948518 .4352742 0.45 0.654 -.6589423 1.048646 name_SuedOst | -.0304791 .556579 -0.05 0.956 -1.122213 1.061255 name_UDSSR | -1.192169 .6165541 -1.93 0.053 -2.401545 .0172076 name_mitOst | -1.259617 .3855112 -3.27 0.001 -2.015801 -.5034336 name_rest | -1.209953 .3888398 -3.11 0.002 -1.972665 -.4472402 female | -.6843726 .1268073 -5.40 0.000 -.9331062 -.435639 abschicht | .5081428 .1734925 2.93 0.003 .1678357 .8484499 age_Q1 | .4499047 .1834528 2.45 0.014 .0900604 .809749 age_Q2 | .3391319 .1618365 2.10 0.036 .0216881 .6565757 age_Q4 | -.5103958 .1843954 -2.77 0.006 -.872089 -.1487026 y200708 | .2170723 .1566242 1.39 0.166 -.0901474 .524292 y200809 | .232842 .1450868 1.60 0.109 -.051747 .517431 m_1 | 0 (omitted) m_2 | -.2366608 .2894161 -0.82 0.414 -.804353 .3310314 m_3 | .1609596 .2775 0.58 0.562 -.383359 .7052782 m_4 | -.4801579 .3010706 -1.59 0.111 -1.07071 .1103947 m_5 | .1844098 .2905126 0.63 0.526 -.3854331 .7542527 m_6 | .4961171 .3626401 1.37 0.171 -.2152045 1.207439 m_7 | .004436 .2827012 0.02 0.987 -.5500848 .5589569 m_8 | .1499426 .2715071 0.55 0.581 -.382621 .6825062 m_9 | -.0607297 .2751234 -0.22 0.825 -.6003868 .4789273 m_10 | -.034607 .278871 -0.12 0.901 -.5816148 .5124008 _cons | 8.732464 .2539889 34.38 0.000 8.234263 9.230665 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten_Muenster.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten_Muenster.xls . reg note_muendl abinote_normiert name_WestE name_MediterBalkan name_OstE name_mitOst2 name_rest2 female abschicht age_Q1 age_Q2 age_Q4 y200708 y200809 m > _1-m_10, robust note: m_1 omitted because of collinearity Linear regression Number of obs = 1560 F( 22, 1537) = 21.10 Prob > F = 0.0000 R-squared = 0.2158 Root MSE = 2.3564 ------------------------------------------------------------------------------------ | Robust note_muendl | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------------+---------------------------------------------------------------- abinote_normiert | 1.697637 .1099678 15.44 0.000 1.481934 1.91334 name_WestE | .0750696 .6641676 0.11 0.910 -1.227701 1.37784 name_MediterBalkan | .034488 .4316941 0.08 0.936 -.8122837 .8812598 name_OstE | -.4383579 .4745511 -0.92 0.356 -1.369194 .4924782 name_mitOst2 | -1.414124 .3771239 -3.75 0.000 -2.153856 -.6743926 name_rest2 | -1.036608 .5239674 -1.98 0.048 -2.064375 -.0088417 female | -.6984807 .1270353 -5.50 0.000 -.9476615 -.4492998 abschicht | .5220064 .1731687 3.01 0.003 .1823346 .8616782 age_Q1 | .4617311 .184146 2.51 0.012 .1005271 .8229351 age_Q2 | .3508478 .1629704 2.15 0.031 .03118 .6705156 age_Q4 | -.5115037 .1848953 -2.77 0.006 -.8741774 -.14883 y200708 | .2158846 .1569538 1.38 0.169 -.0919818 .5237509 y200809 | .2321818 .1448748 1.60 0.109 -.0519913 .5163548 m_1 | 0 (omitted) m_2 | -.2353356 .2908598 -0.81 0.419 -.8058596 .3351884 m_3 | .1702382 .2787329 0.61 0.541 -.3764987 .7169752 m_4 | -.4778191 .3014348 -1.59 0.113 -1.069086 .1134477 m_5 | .1861197 .2918037 0.64 0.524 -.3862557 .7584952 m_6 | .5267567 .3629012 1.45 0.147 -.185077 1.23859 m_7 | .0281322 .283779 0.10 0.921 -.5285028 .5847671 m_8 | .1766766 .2702912 0.65 0.513 -.353502 .7068552 m_9 | -.0679501 .2761615 -0.25 0.806 -.6096432 .4737431 m_10 | -.0287269 .2801135 -0.10 0.918 -.5781719 .5207181 _cons | 8.724229 .2543626 34.30 0.000 8.225295 9.223164 ------------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Teilnoten_Muenster.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten_Muenster.xls . reg note_muendl abinote_normiert note_schr name_non_GER female abschicht age_Q1 age_Q2 age_Q4 y200708 y200809 m_1-m_10, robust note: m_6 omitted because of collinearity Linear regression Number of obs = 1560 F( 19, 1540) = 81.08 Prob > F = 0.0000 R-squared = 0.4718 Root MSE = 1.9321 ---------------------------------------------------------------------------------- | Robust note_muendl | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | .6043288 .1006722 6.00 0.000 .4068597 .8017979 note_schriftl | .7405571 .0274969 26.93 0.000 .6866219 .7944924 name_non_GER | -.2582197 .1854142 -1.39 0.164 -.6219107 .1054713 female | -.178084 .1066358 -1.67 0.095 -.3872507 .0310827 abschicht | .1035923 .1437443 0.72 0.471 -.1783629 .3855475 age_Q1 | -.0003718 .1493914 -0.00 0.998 -.2934038 .2926603 age_Q2 | .1030969 .1377293 0.75 0.454 -.1670599 .3732537 age_Q4 | -.358018 .1492815 -2.40 0.017 -.6508344 -.0652015 y200708 | .2178278 .124243 1.75 0.080 -.0258755 .461531 y200809 | .1987145 .1220347 1.63 0.104 -.0406574 .4380863 m_1 | -.2520216 .2868119 -0.88 0.380 -.8146047 .3105616 m_2 | -.4147624 .2912552 -1.42 0.155 -.986061 .1565363 m_3 | -.4313374 .2773115 -1.56 0.120 -.9752854 .1126106 m_4 | -.6683569 .2933706 -2.28 0.023 -1.243805 -.0929089 m_5 | -.2327696 .2835275 -0.82 0.412 -.7889103 .3233711 m_6 | 0 (omitted) m_7 | -.7848332 .2904161 -2.70 0.007 -1.354486 -.2151805 m_8 | -.0726696 .2813092 -0.26 0.796 -.6244592 .47912 m_9 | -.3263477 .2793153 -1.17 0.243 -.8742261 .2215308 m_10 | -.0459866 .2744056 -0.17 0.867 -.5842348 .4922615 _cons | 3.988462 .3116189 12.80 0.000 3.37722 4.599704 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten_Muenster.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten_Muenster.xls . reg note_muendl abinote_normiert note_schr non_ger female abschicht age_Q1 age_Q2 age_Q4 y200708 y200809 m_1-m_10, robust note: m_6 omitted because of collinearity Linear regression Number of obs = 1560 F( 19, 1540) = 81.05 Prob > F = 0.0000 R-squared = 0.4727 Root MSE = 1.9305 ---------------------------------------------------------------------------------- | Robust note_muendl | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | .606664 .1006973 6.02 0.000 .4091457 .8041823 note_schriftl | .7396528 .0273292 27.06 0.000 .6860465 .7932591 non_ger | -.4544907 .2156499 -2.11 0.035 -.8774891 -.0314922 female | -.1624177 .1068955 -1.52 0.129 -.3720937 .0472583 abschicht | .1064234 .1436852 0.74 0.459 -.1754159 .3882627 age_Q1 | -.0051249 .1492656 -0.03 0.973 -.2979102 .2876603 age_Q2 | .0942337 .1380198 0.68 0.495 -.1764928 .3649602 age_Q4 | -.3583746 .1491167 -2.40 0.016 -.6508679 -.0658814 y200708 | .221348 .1239259 1.79 0.074 -.0217333 .4644293 y200809 | .1980733 .1219807 1.62 0.105 -.0411925 .437339 m_1 | -.25448 .287829 -0.88 0.377 -.8190582 .3100981 m_2 | -.4169185 .2910031 -1.43 0.152 -.9877226 .1538856 m_3 | -.4375384 .2776649 -1.58 0.115 -.9821796 .1071028 m_4 | -.6761602 .2935238 -2.30 0.021 -1.251909 -.1004116 m_5 | -.2449979 .2833148 -0.86 0.387 -.8007215 .3107257 m_6 | 0 (omitted) m_7 | -.7905857 .290142 -2.72 0.007 -1.359701 -.2214704 m_8 | -.0802332 .2811087 -0.29 0.775 -.6316295 .4711632 m_9 | -.3362921 .2798125 -1.20 0.230 -.885146 .2125618 m_10 | -.0470672 .2747661 -0.17 0.864 -.5860224 .491888 _cons | 4.090538 .3138694 13.03 0.000 3.474881 4.706195 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten_Muenster.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten_Muenster.xls . reg note_muendl abinote_normiert note_schr name_AltEuropa name_SuedOst name_UDSSR name_mitOst name_rest female abschicht age_Q1 age_Q2 age_Q4 y200708 > y200809 m_1-m_10, robust note: m_6 omitted because of collinearity Linear regression Number of obs = 1560 F( 23, 1536) = 68.03 Prob > F = 0.0000 R-squared = 0.4751 Root MSE = 1.9285 ---------------------------------------------------------------------------------- | Robust note_muendl | Coef. Std. Err. t P>|t| [95% Conf. Interval] -----------------+---------------------------------------------------------------- abinote_normiert | .6047133 .1011165 5.98 0.000 .4063723 .8030542 note_schriftl | .7389686 .0275473 26.83 0.000 .6849344 .7930029 name_AltEuropa | .3551747 .3449932 1.03 0.303 -.3215328 1.031882 name_SuedOst | .2302169 .4339324 0.53 0.596 -.6209457 1.081379 name_UDSSR | -.6164072 .4022041 -1.53 0.126 -1.405334 .1725199 name_mitOst | -.9371296 .3086462 -3.04 0.002 -1.542542 -.3317171 name_rest | -.7604789 .3730585 -2.04 0.042 -1.492237 -.0287211 female | -.1704254 .1068185 -1.60 0.111 -.3799509 .0391001 abschicht | .0937426 .1436294 0.65 0.514 -.1879878 .3754729 age_Q1 | -.0070627 .148624 -0.05 0.962 -.2985901 .2844647 age_Q2 | .091089 .1371004 0.66 0.507 -.1778346 .3600127 age_Q4 | -.3566078 .1492031 -2.39 0.017 -.6492712 -.0639444 y200708 | .2137825 .1243904 1.72 0.086 -.0302105 .4577754 y200809 | .1954643 .1220498 1.60 0.109 -.0439375 .4348662 m_1 | -.2539451 .2878298 -0.88 0.378 -.818526 .3106359 m_2 | -.404868 .2909402 -1.39 0.164 -.97555 .1658141 m_3 | -.4394927 .2785042 -1.58 0.115 -.9857815 .106796 m_4 | -.6350628 .2925662 -2.17 0.030 -1.208934 -.0611914 m_5 | -.211891 .2844821 -0.74 0.456 -.7699054 .3461233 m_6 | 0 (omitted) m_7 | -.786781 .2902462 -2.71 0.007 -1.356102 -.2174603 m_8 | -.0874036 .2810414 -0.31 0.756 -.638669 .4638618 m_9 | -.3230793 .2800385 -1.15 0.249 -.8723775 .2262188 m_10 | -.0458862 .2740572 -0.17 0.867 -.583452 .4916795 _cons | 4.000181 .3104902 12.88 0.000 3.391151 4.60921 ---------------------------------------------------------------------------------- . outreg2 using "OUTPUT\Teilnoten_Muenster.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten_Muenster.xls . reg note_muendl abinote_normiert note_schr name_WestE name_MediterBalkan name_OstE name_mitOst2 name_rest2 female abschicht age_Q1 age_Q2 age_Q4 y200708 > y200809 m_1-m_10, robust note: m_6 omitted because of collinearity Linear regression Number of obs = 1560 F( 23, 1536) = 67.31 Prob > F = 0.0000 R-squared = 0.4743 Root MSE = 1.9301 ------------------------------------------------------------------------------------ | Robust note_muendl | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------------+---------------------------------------------------------------- abinote_normiert | .6002578 .100727 5.96 0.000 .4026808 .7978349 note_schriftl | .7392052 .0274768 26.90 0.000 .6853091 .7931012 name_WestE | .3253572 .5803352 0.56 0.575 -.8129758 1.46369 name_MediterBalkan | .1412597 .3381567 0.42 0.676 -.5220379 .8045574 name_OstE | -.1041743 .3544939 -0.29 0.769 -.7995175 .5911688 name_mitOst2 | -1.004649 .2933196 -3.43 0.001 -1.579998 -.4292995 name_rest2 | -.4507424 .4431075 -1.02 0.309 -1.319902 .4184171 female | -.1827482 .1066982 -1.71 0.087 -.3920377 .0265413 abschicht | .1032559 .1430977 0.72 0.471 -.1774317 .3839435 age_Q1 | .0021937 .1488207 0.01 0.988 -.2897196 .294107 age_Q2 | .0988163 .1378544 0.72 0.474 -.1715865 .369219 age_Q4 | -.3574384 .1495684 -2.39 0.017 -.6508183 -.0640586 y200708 | .2127786 .1245406 1.71 0.088 -.0315089 .4570661 y200809 | .1958006 .1220812 1.60 0.109 -.0436627 .435264 m_1 | -.2783124 .2881789 -0.97 0.334 -.843578 .2869533 m_2 | -.4268171 .2906694 -1.47 0.142 -.9969679 .1433337 m_3 | -.4587858 .2775684 -1.65 0.099 -1.003239 .0856674 m_4 | -.6589886 .2917905 -2.26 0.024 -1.231338 -.0866387 m_5 | -.2395134 .2843858 -0.84 0.400 -.7973388 .318312 m_6 | 0 (omitted) m_7 | -.7921155 .2905074 -2.73 0.006 -1.361948 -.2222824 m_8 | -.0918971 .2813846 -0.33 0.744 -.6438357 .4600416 m_9 | -.3521725 .2793828 -1.26 0.208 -.9001846 .1958396 m_10 | -.0667099 .274566 -0.24 0.808 -.6052737 .4718539 _cons | 4.018105 .3107628 12.93 0.000 3.408541 4.627669 ------------------------------------------------------------------------------------ . outreg2 using "OUTPUT\Teilnoten_Muenster.xls", se br sdec(3) bdec(3) append OUTPUT\Teilnoten_Muenster.xls . . ******************************************* . *** Regressions Analysen (Teil B) . ******************************************* . . * Es erfolgte eine Transformation der Daten in ein Panel Format . . xtset rank_id counter panel variable: rank_id (strongly balanced) time variable: counter, 1 to 6 delta: 1 unit . . xtreg note_sch2 D_Bre - D_Thr teil_2 teil_3, fe cluster(rank_id) Fixed-effects (within) regression Number of obs = 21920 Group variable: rank_id Number of groups = 3654 R-sq: within = 0.0023 Obs per group: min = 4 between = 0.0006 avg = 6.0 overall = 0.0014 max = 6 F(12,3653) = 3.22 corr(u_i, Xb) = -0.0007 Prob > F = 0.0001 (Std. Err. adjusted for 3654 clusters in rank_id) ------------------------------------------------------------------------------ | Robust note_sch2 | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- D_Bre | .792434 .2558348 3.10 0.002 .2908409 1.294027 D_Ham | .196449 .1054659 1.86 0.063 -.0103288 .4032268 D_Hes | -.1013405 .1633552 -0.62 0.535 -.421617 .2189359 D_Mck | -.0497658 .1458266 -0.34 0.733 -.3356755 .2361439 D_Nds | -.0949712 .107593 -0.88 0.377 -.3059194 .115977 D_Nrw | -.0933904 .1351456 -0.69 0.490 -.3583587 .1715778 D_Rlp | -.0269727 .2078918 -0.13 0.897 -.4345681 .3806227 D_Sar | .0548857 .1930762 0.28 0.776 -.3236621 .4334336 D_Sac | -.2841122 .1507904 -1.88 0.060 -.579754 .0115296 D_Thr | .5136134 .2423078 2.12 0.034 .0385414 .9886854 teil_2 | .0676298 .0403291 1.68 0.094 -.01144 .1466997 teil_3 | .064426 .0463441 1.39 0.165 -.0264369 .1552889 _cons | 5.461698 .1158166 47.16 0.000 5.234626 5.68877 -------------+---------------------------------------------------------------- sigma_u | 2.4938757 sigma_e | 2.4689513 rho | .5050221 (fraction of variance due to u_i) ------------------------------------------------------------------------------ . outreg2 using "OUTPUT\klausursteller.xls", se br sdec(3) bdec(3) replace OUTPUT\klausursteller.xls . xtreg note_sch2 D_Bre - D_Thr if rechtsgeb==1, fe cluster(rank_id) note: D_Thr omitted because of collinearity Fixed-effects (within) regression Number of obs = 10962 Group variable: rank_id Number of groups = 3654 R-sq: within = 0.0065 Obs per group: min = 3 between = 0.0001 avg = 3.0 overall = 0.0011 max = 3 F(9,3653) = 5.24 corr(u_i, Xb) = -0.0322 Prob > F = 0.0000 (Std. Err. adjusted for 3654 clusters in rank_id) ------------------------------------------------------------------------------ | Robust note_sch2 | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- D_Bre | .7198446 .4504543 1.60 0.110 -.1633223 1.603012 D_Ham | .3756233 .1712992 2.19 0.028 .0397718 .7114749 D_Hes | .4266667 .3424359 1.25 0.213 -.2447177 1.098051 D_Mck | -.0077221 .1625683 -0.05 0.962 -.3264558 .3110115 D_Nds | -.41113 .1428885 -2.88 0.004 -.6912791 -.1309809 D_Nrw | .0957063 .3062687 0.31 0.755 -.5047682 .6961808 D_Rlp | .3198446 .4317211 0.74 0.459 -.5265936 1.166283 D_Sar | .5027859 .3698704 1.36 0.174 -.222387 1.227959 D_Sac | -.2896792 .3278364 -0.88 0.377 -.9324398 .3530814 D_Thr | 0 (omitted) _cons | 5.295705 .2569838 20.61 0.000 4.791859 5.799551 -------------+---------------------------------------------------------------- sigma_u | 2.7066348 sigma_e | 2.4156779 rho | .55661918 (fraction of variance due to u_i) ------------------------------------------------------------------------------ . outreg2 using "OUTPUT\klausursteller.xls", se br sdec(3) bdec(3) append OUTPUT\klausursteller.xls . xtreg note_sch2 D_Bre - D_Thr if rechtsgeb==2, fe cluster(rank_id) note: D_Bre omitted because of collinearity note: D_Mck omitted because of collinearity Fixed-effects (within) regression Number of obs = 7304 Group variable: rank_id Number of groups = 3652 R-sq: within = 0.0130 Obs per group: min = 2 between = 0.0033 avg = 2.0 overall = 0.0003 max = 2 F(8,3651) = 6.74 corr(u_i, Xb) = -0.1744 Prob > F = 0.0000 (Std. Err. adjusted for 3652 clusters in rank_id) ------------------------------------------------------------------------------ | Robust note_sch2 | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- D_Bre | 0 (omitted) D_Ham | -.0608696 .1622141 -0.38 0.708 -.3789088 .2571696 D_Hes | .3178753 .3938905 0.81 0.420 -.4543918 1.090142 D_Mck | 0 (omitted) D_Nds | 1.865571 .4751646 3.93 0.000 .9339563 2.797185 D_Nrw | .6382979 .3304768 1.93 0.054 -.0096396 1.286235 D_Rlp | .8884663 .5325534 1.67 0.095 -.1556653 1.932598 D_Sar | 1.173782 .4612723 2.54 0.011 .2694049 2.078159 D_Sac | 1.218655 .458672 2.66 0.008 .3193764 2.117934 D_Thr | 2.450883 .5157246 4.75 0.000 1.439746 3.462019 _cons | 4.801901 .2884547 16.65 0.000 4.236353 5.367449 -------------+---------------------------------------------------------------- sigma_u | 3.0013467 sigma_e | 2.5559232 rho | .57963987 (fraction of variance due to u_i) ------------------------------------------------------------------------------ . outreg2 using "OUTPUT\klausursteller.xls", se br sdec(3) bdec(3) append OUTPUT\klausursteller.xls