----------------------------------------------------------------------------------------------------------- name: log: D:\DATA.IDB\Courses\Chile\FINAL FINAL\myownthing Chile\solution_log FINAL VERSION.txt log type: text opened on: 7 Feb 2012, 11:57:17 . *============================* > Macros > *============================*; . global variables1 ophe age_hh educ_hh age_sp educ_sp ethnicity_hh female_hh hhsize_basal dirtfloor_basa > l bathroom_basal landhectars_basal min_dist; . global controls1 age_hh educ_hh age_sp educ_sp ethnicity_hh female_hh; . global controls2 hhsize_basal dirtfloor_basal bathroom_basal landhectars_basal min_dist; . *============================* > SOLUCION PROGRAMA > *============================*; . use "$data\evaluation.dta"; (Household Roster (households with completed interview)) . *============================* > CASE 0: ANTES Y DESPUES > *============================*; . *1; . keep if treatcom==1; (10122 observations deleted) . sum if round==0; Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- local | 7775 45.43781 44.30728 1 431 hhid | 7775 7322.91 4522.162 1 15778 round | 7775 0 0 0 0 ophe | 7775 66.66282 21.20989 25.00862 138.5054 age_hh | 7775 45.93044 15.13089 14 88 -------------+-------------------------------------------------------- age_sp | 7775 40.07791 12.67485 13 88 educ_hh | 7775 2.856208 2.800954 0 18 educ_sp | 7775 2.749721 2.549848 0 18 ethnicity_hh | 7775 .3569132 .4791197 0 1 female_hh | 7775 .0967203 .2955955 0 1 -------------+-------------------------------------------------------- hhsize_basal | 7775 5.187524 2.186406 1 13 dirtfloor_~l | 7775 .6079743 .4882338 0 1 bathroom_b~l | 7775 .6172347 .486093 0 1 landhectar~l | 7775 2.03254 3.112519 0 23 min_dist | 7775 106.9009 41.57764 13.31589 170.4576 -------------+-------------------------------------------------------- eligible | 7775 .6006431 .4897977 0 1 takeup | 7775 .58791 .4922428 0 1 treatcom | 7775 1 0 1 1 score | 7775 725.0036 135.0233 276 1294 . *2; . *Hay tres maneras de estimar la diferencia en medias: (a) calculando las medias y comparandolas, (b) hac > iendo un ttest, (c) mediante una regresion lineal; . sum ophe if takeup==1 & round==0; Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- ophe | 4571 58.3121 17.4351 25.00862 116.7895 . sum ophe if takeup==1 & round==1; Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- ophe | 4571 52.29373 32.60476 10.06769 370.7207 . *. display 58.3121- 52.29373=6.01837; . ttest ophe if takeup==1, by (round); Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 4571 58.3121 .2578807 17.4351 57.80653 58.81767 1 | 4571 52.29373 .4822535 32.60476 51.34828 53.23918 ---------+-------------------------------------------------------------------- combined | 9142 55.30291 .2752275 26.31555 54.76341 55.84242 ---------+-------------------------------------------------------------------- diff | 6.018374 .5468737 4.946379 7.090369 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 11.0051 Ho: diff = 0 degrees of freedom = 9140 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 1.0000 Pr(|T| > |t|) = 0.0000 Pr(T > t) = 0.0000 . *3; . reg ophe round if takeup==1; Source | SS df MS Number of obs = 9142 -------------+------------------------------ F( 1, 9140) = 121.11 Model | 82782.6914 1 82782.6914 Prob > F = 0.0000 Residual | 6247432.52 9140 683.526533 R-squared = 0.0131 -------------+------------------------------ Adj R-squared = 0.0130 Total | 6330215.21 9141 692.507954 Root MSE = 26.144 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- round | -6.018374 .5468737 -11.01 0.000 -7.090369 -4.946379 _cons | 58.3121 .3866981 150.79 0.000 57.55408 59.07011 ------------------------------------------------------------------------------ . reg ophe round if takeup==1, cl (local); Linear regression Number of obs = 9142 F( 1, 115) = 39.80 Prob > F = 0.0000 R-squared = 0.0131 Root MSE = 26.144 (Std. Err. adjusted for 116 clusters in local) ------------------------------------------------------------------------------ | Robust ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- round | -6.018374 .9540199 -6.31 0.000 -7.908104 -4.128644 _cons | 58.3121 .5044108 115.60 0.000 57.31296 59.31124 ------------------------------------------------------------------------------ . *================================* > CASO 1: AUTOSELECCIONADOS > *================================*; . *1; . ttest ophe if round==0, by(takeup); Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 78.5764 .3606067 20.41174 77.86936 79.28345 1 | 4571 58.3121 .2578807 17.4351 57.80653 58.81767 ---------+-------------------------------------------------------------------- combined | 7775 66.66282 .2405405 21.20989 66.19129 67.13434 ---------+-------------------------------------------------------------------- diff | 20.26431 .4313038 19.41883 21.10978 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 46.9838 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 1.0000 Pr(|T| > |t|) = 0.0000 Pr(T > t) = 0.0000 . ttest age_hh if round==0, by(takeup); Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 51.70821 .2684084 15.19296 51.18194 52.23448 1 | 4571 41.88057 .20273 13.70641 41.48312 42.27802 ---------+-------------------------------------------------------------------- combined | 7775 45.93044 .1715989 15.13089 45.59406 46.26682 ---------+-------------------------------------------------------------------- diff | 9.827635 .3303515 9.180058 10.47521 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 29.7490 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 1.0000 Pr(|T| > |t|) = 0.0000 Pr(T > t) = 0.0000 . ttest educ_hh if round==0, by(takeup); Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 2.710649 .0526254 2.978803 2.607466 2.813832 1 | 4571 2.958236 .0394153 2.664836 2.880963 3.035509 ---------+-------------------------------------------------------------------- combined | 7775 2.856208 .0317655 2.800954 2.793939 2.918477 ---------+-------------------------------------------------------------------- diff | -.2475876 .0644794 -.3739845 -.1211907 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -3.8398 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.0001 Pr(|T| > |t|) = 0.0001 Pr(T > t) = 0.9999 . *o... comparandolos todos de una vez; . foreach x of global variables1 > {; 2. describe `x'; 3. ttest `x' if round==0, by(takeup); 4. reg `x' takeup if round==0; 5. }; storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- ophe float %9.0g Out of pocket health expenditures (per capita per month) Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 78.5764 .3606067 20.41174 77.86936 79.28345 1 | 4571 58.3121 .2578807 17.4351 57.80653 58.81767 ---------+-------------------------------------------------------------------- combined | 7775 66.66282 .2405405 21.20989 66.19129 67.13434 ---------+-------------------------------------------------------------------- diff | 20.26431 .4313038 19.41883 21.10978 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 46.9838 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 1.0000 Pr(|T| > |t|) = 0.0000 Pr(T > t) = 0.0000 Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 1, 7773) = 2207.48 Model | 773511.51 1 773511.51 Prob > F = 0.0000 Residual | 2723696.19 7773 350.404759 R-squared = 0.2212 -------------+------------------------------ Adj R-squared = 0.2211 Total | 3497207.7 7774 449.859493 Root MSE = 18.719 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | -20.26431 .4313038 -46.98 0.000 -21.10978 -19.41883 _cons | 78.5764 .3307035 237.60 0.000 77.92814 79.22467 ------------------------------------------------------------------------------ storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- age_hh float %9.0g Head's age Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 51.70821 .2684084 15.19296 51.18194 52.23448 1 | 4571 41.88057 .20273 13.70641 41.48312 42.27802 ---------+-------------------------------------------------------------------- combined | 7775 45.93044 .1715989 15.13089 45.59406 46.26682 ---------+-------------------------------------------------------------------- diff | 9.827635 .3303515 9.180058 10.47521 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 29.7490 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 1.0000 Pr(|T| > |t|) = 0.0000 Pr(T > t) = 0.0000 Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 1, 7773) = 885.00 Model | 181928.781 1 181928.781 Prob > F = 0.0000 Residual | 1597881.44 7773 205.568177 R-squared = 0.1022 -------------+------------------------------ Adj R-squared = 0.1021 Total | 1779810.22 7774 228.943944 Root MSE = 14.338 ------------------------------------------------------------------------------ age_hh | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | -9.827635 .3303515 -29.75 0.000 -10.47521 -9.180058 _cons | 51.70821 .253298 204.14 0.000 51.21168 52.20474 ------------------------------------------------------------------------------ storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- educ_hh float %9.0g Head's education - years Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 2.710649 .0526254 2.978803 2.607466 2.813832 1 | 4571 2.958236 .0394153 2.664836 2.880963 3.035509 ---------+-------------------------------------------------------------------- combined | 7775 2.856208 .0317655 2.800954 2.793939 2.918477 ---------+-------------------------------------------------------------------- diff | -.2475876 .0644794 -.3739845 -.1211907 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -3.8398 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.0001 Pr(|T| > |t|) = 0.0001 Pr(T > t) = 0.9999 Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 1, 7773) = 14.74 Model | 115.467876 1 115.467876 Prob > F = 0.0001 Residual | 60874.2429 7773 7.83149915 R-squared = 0.0019 -------------+------------------------------ Adj R-squared = 0.0018 Total | 60989.7107 7774 7.84534483 Root MSE = 2.7985 ------------------------------------------------------------------------------ educ_hh | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | .2475876 .0644794 3.84 0.000 .1211907 .3739845 _cons | 2.710649 .0494397 54.83 0.000 2.613733 2.807564 ------------------------------------------------------------------------------ storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- age_sp float %9.0g Spouse's age Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 44.43862 .2264495 12.81792 43.99462 44.88262 1 | 4571 37.02131 .1721434 11.63847 36.68383 37.3588 ---------+-------------------------------------------------------------------- combined | 7775 40.07791 .143745 12.67485 39.79613 40.35969 ---------+-------------------------------------------------------------------- diff | 7.417306 .2796784 6.869061 7.965551 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 26.5208 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 1.0000 Pr(|T| > |t|) = 0.0000 Pr(T > t) = 0.0000 Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 1, 7773) = 703.36 Model | 103632.431 1 103632.431 Prob > F = 0.0000 Residual | 1145274.93 7773 147.340142 R-squared = 0.0830 -------------+------------------------------ Adj R-squared = 0.0829 Total | 1248907.36 7774 160.651834 Root MSE = 12.138 ------------------------------------------------------------------------------ age_sp | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | -7.417306 .2796784 -26.52 0.000 -7.965551 -6.869061 _cons | 44.43862 .2144442 207.23 0.000 44.01825 44.85899 ------------------------------------------------------------------------------ storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- educ_sp float %9.0g Spouse's education - years Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 2.710899 .0474241 2.684389 2.617914 2.803884 1 | 4571 2.776933 .0362536 2.451078 2.705858 2.848007 ---------+-------------------------------------------------------------------- combined | 7775 2.749721 .0289177 2.549848 2.693034 2.806408 ---------+-------------------------------------------------------------------- diff | -.0660337 .0587496 -.1811988 .0491315 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -1.1240 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.1305 Pr(|T| > |t|) = 0.2611 Pr(T > t) = 0.8695 Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 1, 7773) = 1.26 Model | 8.2136134 1 8.2136134 Prob > F = 0.2611 Residual | 50536.198 7773 6.50150495 R-squared = 0.0002 -------------+------------------------------ Adj R-squared = 0.0000 Total | 50544.4116 7774 6.50172518 Root MSE = 2.5498 ------------------------------------------------------------------------------ educ_sp | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | .0660337 .0587496 1.12 0.261 -.0491315 .1811988 _cons | 2.710899 .0450465 60.18 0.000 2.622596 2.799202 ------------------------------------------------------------------------------ storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- ethnicity_hh float %9.0g (ind) =1 if indiv. speaks an indigenous language Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 .2693508 .0078385 .4436918 .2539817 .2847199 1 | 4571 .4182892 .0072968 .4933321 .4039839 .4325945 ---------+-------------------------------------------------------------------- combined | 7775 .3569132 .0054337 .4791197 .3462617 .3675647 ---------+-------------------------------------------------------------------- diff | -.1489384 .01091 -.170325 -.1275518 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -13.6515 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.0000 Pr(|T| > |t|) = 0.0000 Pr(T > t) = 1.0000 Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 1, 7773) = 186.36 Model | 41.7846451 1 41.7846451 Prob > F = 0.0000 Residual | 1742.78127 7773 .224209607 R-squared = 0.0234 -------------+------------------------------ Adj R-squared = 0.0233 Total | 1784.56592 7774 .229555688 Root MSE = .47351 ------------------------------------------------------------------------------ ethnicity_hh | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | .1489384 .01091 13.65 0.000 .1275518 .170325 _cons | .2693508 .0083653 32.20 0.000 .2529526 .285749 ------------------------------------------------------------------------------ storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- female_hh float %9.0g Head is Female =1 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 .1301498 .0059452 .3365207 .1184931 .1418066 1 | 4571 .0732881 .0038551 .2606374 .0657303 .0808459 ---------+-------------------------------------------------------------------- combined | 7775 .0967203 .0033523 .2955955 .0901488 .1032917 ---------+-------------------------------------------------------------------- diff | .0568617 .0067806 .0435699 .0701535 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 8.3859 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 1.0000 Pr(|T| > |t|) = 0.0000 Pr(T > t) = 0.0000 Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 1, 7773) = 70.32 Model | 6.09035892 1 6.09035892 Prob > F = 0.0000 Residual | 673.176008 7773 .086604401 R-squared = 0.0090 -------------+------------------------------ Adj R-squared = 0.0088 Total | 679.266367 7774 .087376687 Root MSE = .29429 ------------------------------------------------------------------------------ female_hh | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | -.0568617 .0067806 -8.39 0.000 -.0701535 -.0435699 _cons | .1301498 .005199 25.03 0.000 .1199583 .1403413 ------------------------------------------------------------------------------ storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- hhsize_basal float %9.0g household size at baseline Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 4.365169 .0386985 2.190488 4.289292 4.441045 1 | 4571 5.763947 .0294425 1.990585 5.706225 5.821668 ---------+-------------------------------------------------------------------- combined | 7775 5.187524 .0247959 2.186406 5.138917 5.236131 ---------+-------------------------------------------------------------------- diff | -1.398778 .0478165 -1.492511 -1.305045 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -29.2531 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.0000 Pr(|T| > |t|) = 0.0000 Pr(T > t) = 1.0000 Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 1, 7773) = 855.74 Model | 3685.53863 1 3685.53863 Prob > F = 0.0000 Residual | 33477.0512 7773 4.30683793 R-squared = 0.0992 -------------+------------------------------ Adj R-squared = 0.0991 Total | 37162.5898 7774 4.78036916 Root MSE = 2.0753 ------------------------------------------------------------------------------ hhsize_basal | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | 1.398778 .0478165 29.25 0.000 1.305045 1.492511 _cons | 4.365169 .0366634 119.06 0.000 4.293298 4.437039 ------------------------------------------------------------------------------ storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- dirtfloor_basal byte %8.0g dirt floor at baseline =1 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 .4594257 .0088056 .4984288 .4421606 .4766908 1 | 4571 .712098 .0066978 .4528347 .698967 .725229 ---------+-------------------------------------------------------------------- combined | 7775 .6079743 .005537 .4882338 .5971202 .6188284 ---------+-------------------------------------------------------------------- diff | -.2526723 .0108789 -.2739978 -.2313468 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -23.2260 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.0000 Pr(|T| > |t|) = 0.0000 Pr(T > t) = 1.0000 Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 1, 7773) = 539.45 Model | 120.259271 1 120.259271 Prob > F = 0.0000 Residual | 1732.84632 7773 .222931471 R-squared = 0.0649 -------------+------------------------------ Adj R-squared = 0.0648 Total | 1853.10559 7774 .238372214 Root MSE = .47216 ------------------------------------------------------------------------------ dirtfloor_~l | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | .2526723 .0108789 23.23 0.000 .2313468 .2739978 _cons | .4594257 .0083414 55.08 0.000 .4430743 .4757771 ------------------------------------------------------------------------------ storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- bathroom_basal byte %8.0g bathroom at baseline = 1 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 .6766542 .0082649 .4678265 .6604491 .6928592 1 | 4571 .5755852 .0073113 .4943079 .5612516 .5899188 ---------+-------------------------------------------------------------------- combined | 7775 .6172347 .0055128 .486093 .6064282 .6280412 ---------+-------------------------------------------------------------------- diff | .101069 .0111419 .0792279 .1229101 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 9.0711 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 1.0000 Pr(|T| > |t|) = 0.0000 Pr(T > t) = 0.0000 Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 1, 7773) = 82.28 Model | 19.2415042 1 19.2415042 Prob > F = 0.0000 Residual | 1817.64904 7773 .233841379 R-squared = 0.0105 -------------+------------------------------ Adj R-squared = 0.0103 Total | 1836.89055 7774 .236286409 Root MSE = .48357 ------------------------------------------------------------------------------ bathroom_b~l | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | -.101069 .0111419 -9.07 0.000 -.1229101 -.0792279 _cons | .6766542 .0085431 79.20 0.000 .6599074 .6934009 ------------------------------------------------------------------------------ storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- landhectars_b~l byte %9.0g (hh) total hectars of land Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 2.600499 .0657393 3.721101 2.471604 2.729395 1 | 4571 1.634434 .0373903 2.527925 1.561131 1.707737 ---------+-------------------------------------------------------------------- combined | 7775 2.03254 .035299 3.112519 1.963345 2.101736 ---------+-------------------------------------------------------------------- diff | .9660649 .0708777 .8271256 1.105004 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 13.6300 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 1.0000 Pr(|T| > |t|) = 0.0000 Pr(T > t) = 0.0000 Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 1, 7773) = 185.78 Model | 1757.98812 1 1757.98812 Prob > F = 0.0000 Residual | 73554.7792 7773 9.46285594 R-squared = 0.0233 -------------+------------------------------ Adj R-squared = 0.0232 Total | 75312.7673 7774 9.68777558 Root MSE = 3.0762 ------------------------------------------------------------------------------ landhectar~l | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | -.9660649 .0708777 -13.63 0.000 -1.105004 -.8271256 _cons | 2.600499 .0543457 47.85 0.000 2.493967 2.707031 ------------------------------------------------------------------------------ storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- min_dist double %11.0g distance from community to closest Hospital(km) Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 103.8344 .7244327 41.00571 102.414 105.2548 1 | 4571 109.0502 .6189188 41.84459 107.8369 110.2636 ---------+-------------------------------------------------------------------- combined | 7775 106.9009 .4715304 41.57764 105.9765 107.8252 ---------+-------------------------------------------------------------------- diff | -5.215832 .9562171 -7.090275 -3.341389 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -5.4547 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.0000 Pr(|T| > |t|) = 0.0000 Pr(T > t) = 1.0000 Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 1, 7773) = 29.75 Model | 51244.8764 1 51244.8764 Prob > F = 0.0000 Residual | 13387671.6 7773 1722.33007 R-squared = 0.0038 -------------+------------------------------ Adj R-squared = 0.0037 Total | 13438916.5 7774 1728.70034 Root MSE = 41.501 ------------------------------------------------------------------------------ min_dist | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | 5.215832 .9562171 5.45 0.000 3.341389 7.090275 _cons | 103.8344 .7331822 141.62 0.000 102.3972 105.2717 ------------------------------------------------------------------------------ . *2; . *i; . reg ophe takeup if round==1; Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 1, 7773) = 1152.90 Model | 1951560.26 1 1951560.26 Prob > F = 0.0000 Residual | 13157647.8 7773 1692.7374 R-squared = 0.1292 -------------+------------------------------ Adj R-squared = 0.1291 Total | 15109208.1 7774 1943.55648 Root MSE = 41.143 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | -32.18765 .9479668 -33.95 0.000 -34.04592 -30.32938 _cons | 84.48138 .7268563 116.23 0.000 83.05655 85.90621 ------------------------------------------------------------------------------ . *ii; . reg ophe takeup $controls1 if round==1; Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 7, 7767) = 209.40 Model | 2398738.13 7 342676.876 Prob > F = 0.0000 Residual | 12710470 7767 1636.47096 R-squared = 0.1588 -------------+------------------------------ Adj R-squared = 0.1580 Total | 15109208.1 7774 1943.55648 Root MSE = 40.453 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | -27.22636 1.013765 -26.86 0.000 -29.21361 -25.2391 age_hh | .5057593 .0569247 8.88 0.000 .3941715 .6173471 educ_hh | -.018016 .2079501 -0.09 0.931 -.4256542 .3896222 age_sp | -.2289351 .0657048 -3.48 0.000 -.3577342 -.1001361 educ_sp | .361107 .2276869 1.59 0.113 -.0852207 .8074347 ethnicity_hh | -7.146663 .976498 -7.32 0.000 -9.060862 -5.232464 female_hh | 10.9636 1.664605 6.59 0.000 7.700524 14.22667 _cons | 67.74836 2.751807 24.62 0.000 62.35408 73.14265 ------------------------------------------------------------------------------ . *3; . *4; . *==================================* > CASO 2: DIFERENCIAS EN DIFERENCIAS > *==================================*; . *1; . sort hhid round; . gen delta_ophe= ophe-ophe[_n-1] if hhid==hhid[_n-1]; (7775 missing values generated) . *2; . ttest delta_ophe if round==1, by (takeup); Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 5.904974 .7970426 45.11571 4.342209 7.46774 1 | 4571 -6.018374 .4404304 29.77714 -6.88183 -5.154917 ---------+-------------------------------------------------------------------- combined | 7775 -1.104881 .423477 37.34049 -1.93501 -.274752 ---------+-------------------------------------------------------------------- diff | 11.92335 .8497168 10.25767 13.58902 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 14.0321 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 1.0000 Pr(|T| > |t|) = 0.0000 Pr(T > t) = 0.0000 . *3; . gen takeup_round = takeup*round; . *i; . reg delta_ophe takeup if round==1, cl(local); Linear regression Number of obs = 7775 F( 1, 115) = 100.96 Prob > F = 0.0000 R-squared = 0.0247 Root MSE = 36.879 (Std. Err. adjusted for 116 clusters in local) ------------------------------------------------------------------------------ | Robust delta_ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | -11.92335 1.186674 -10.05 0.000 -14.27392 -9.572776 _cons | 5.904974 1.226908 4.81 0.000 3.474706 8.335243 ------------------------------------------------------------------------------ . reg ophe takeup round takeup_round, cl (local); Linear regression Number of obs = 15550 F( 3, 115) = 440.22 Prob > F = 0.0000 R-squared = 0.1467 Root MSE = 31.962 (Std. Err. adjusted for 116 clusters in local) ------------------------------------------------------------------------------ | Robust ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | -20.26431 .6218838 -32.59 0.000 -21.49614 -19.03247 round | 5.904974 1.226947 4.81 0.000 3.474627 8.335321 takeup_round | -11.92335 1.186712 -10.05 0.000 -14.274 -9.5727 _cons | 78.5764 .5950546 132.05 0.000 77.39772 79.75509 ------------------------------------------------------------------------------ . *ii; . reg ophe takeup round takeup_round $controls1, cl (local); Linear regression Number of obs = 15550 F( 9, 115) = 199.31 Prob > F = 0.0000 R-squared = 0.1997 Root MSE = 30.959 (Std. Err. adjusted for 116 clusters in local) ------------------------------------------------------------------------------ | Robust ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | -14.66776 .6494125 -22.59 0.000 -15.95412 -13.3814 round | 5.538556 1.229085 4.51 0.000 3.103976 7.973137 takeup_round | -11.91148 1.188171 -10.03 0.000 -14.26502 -9.557945 age_hh | .4682973 .0454702 10.30 0.000 .3782296 .5583649 educ_hh | .3220143 .1512112 2.13 0.035 .0224941 .6215346 age_sp | -.1203227 .0502394 -2.39 0.018 -.2198374 -.0208081 educ_sp | .5098805 .1481235 3.44 0.001 .2164763 .8032847 ethnicity_hh | -8.687168 1.151572 -7.54 0.000 -10.96821 -6.406126 female_hh | 12.42145 1.196725 10.38 0.000 10.05096 14.79193 _cons | 58.17671 2.125094 27.38 0.000 53.96731 62.38611 ------------------------------------------------------------------------------ . reg ophe takeup round takeup_round $controls1 $controls2, cl (local); Linear regression Number of obs = 15550 F( 14, 115) = 2389.51 Prob > F = 0.0000 R-squared = 0.4240 Root MSE = 26.268 (Std. Err. adjusted for 116 clusters in local) ----------------------------------------------------------------------------------- | Robust ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] ------------------+---------------------------------------------------------------- takeup | -1.353903 .416171 -3.25 0.001 -2.178257 -.5295479 round | 5.624183 1.227022 4.58 0.000 3.193688 8.054677 takeup_round | -11.91903 1.187366 -10.04 0.000 -14.27097 -9.567088 age_hh | .3131045 .0367574 8.52 0.000 .2402952 .3859139 educ_hh | .2981888 .1017201 2.93 0.004 .0967008 .4996767 age_sp | -.0307934 .0392074 -0.79 0.434 -.1084557 .0468688 educ_sp | -.1186428 .1226469 -0.97 0.335 -.3615827 .1242971 ethnicity_hh | -8.833324 .9196225 -9.61 0.000 -10.65492 -7.011728 female_hh | 4.686448 .9606575 4.88 0.000 2.783571 6.589326 hhsize_basal | -8.145537 .1259908 -64.65 0.000 -8.3951 -7.895973 dirtfloor_basal | -9.543458 .6603346 -14.45 0.000 -10.85145 -8.235463 bathroom_basal | 1.644254 .5297827 3.10 0.002 .5948564 2.693652 landhectars_basal | .4999895 .0920156 5.43 0.000 .3177244 .6822547 min_dist | -.0174952 .0111814 -1.56 0.120 -.0396433 .004653 _cons | 104.3823 2.205304 47.33 0.000 100.0141 108.7506 ----------------------------------------------------------------------------------- . *4; . *5; . *6 Chequeos de consistencia; . preserve; . use "$data\evaluation_extended.dta", clear; (Household Roster (households with completed interview)) . keep if treatcom==1; (0 observations deleted) . *twoway scatter ophe_med_t ophe_med_c round if round>=0; . *twoway scatter ophe_med_t ophe_med_c round if round>=-1; . twoway scatter ophe_med_t ophe_med_c round; . *i; . sort hhid round; . gen delta_ophe= ophe-ophe[_n-1] if hhid==hhid[_n-1]; (7775 missing values generated) . reg delta_ophe takeup if round==1, cl(local); Linear regression Number of obs = 7775 F( 1, 115) = 100.96 Prob > F = 0.0000 R-squared = 0.0247 Root MSE = 36.879 (Std. Err. adjusted for 116 clusters in local) ------------------------------------------------------------------------------ | Robust delta_ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | -11.92335 1.186674 -10.05 0.000 -14.27392 -9.572776 _cons | 5.904974 1.226908 4.81 0.000 3.474706 8.335243 ------------------------------------------------------------------------------ . reg delta_ophe takeup if round==1; Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 1, 7773) = 196.90 Model | 267793.338 1 267793.338 Prob > F = 0.0000 Residual | 10571592 7773 1360.04013 R-squared = 0.0247 -------------+------------------------------ Adj R-squared = 0.0246 Total | 10839385.3 7774 1394.31249 Root MSE = 36.879 ------------------------------------------------------------------------------ delta_ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | -11.92335 .8497168 -14.03 0.000 -13.58902 -10.25767 _cons | 5.904974 .6515228 9.06 0.000 4.627814 7.182134 ------------------------------------------------------------------------------ . ttest delta_ophe if round==1, by (takeup); Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 5.904974 .7970426 45.11571 4.342209 7.46774 1 | 4571 -6.018374 .4404304 29.77714 -6.88183 -5.154917 ---------+-------------------------------------------------------------------- combined | 7775 -1.104881 .423477 37.34049 -1.93501 -.274752 ---------+-------------------------------------------------------------------- diff | 11.92335 .8497168 10.25767 13.58902 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 14.0321 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 1.0000 Pr(|T| > |t|) = 0.0000 Pr(T > t) = 0.0000 . ttest delta_ophe if round==0, by (takeup); Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 .97749 .0180377 1.021004 .9421234 1.012857 1 | 4571 1.005514 .0146401 .9898029 .9768127 1.034216 ---------+-------------------------------------------------------------------- combined | 7775 .9939658 .0113728 1.002808 .971672 1.01626 ---------+-------------------------------------------------------------------- diff | -.0280243 .0231048 -.073316 .0172674 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -1.2129 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.1126 Pr(|T| > |t|) = 0.2252 Pr(T > t) = 0.8874 . ttest delta_ophe if round==-1, by (takeup); Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 3204 1.044706 .025306 1.432419 .9950886 1.094324 1 | 4571 .9875535 .0205785 1.391296 .9472097 1.027897 ---------+-------------------------------------------------------------------- combined | 7775 1.011106 .0159746 1.408577 .9797911 1.04242 ---------+-------------------------------------------------------------------- diff | .0571527 .0324504 -.0064589 .1207643 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 1.7612 Ho: diff = 0 degrees of freedom = 7773 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.9609 Pr(|T| > |t|) = 0.0782 Pr(T > t) = 0.0391 . restore; . *================================* > CASE 3: REGRESION DISCONTINUA > *================================*; . *use "$data\evaluation.dta", clear; . *keep if treatcom ==1; . *br score eligible; . *1; . reg ophe eligible score if round==1; Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 2, 7772) = 720.52 Model | 2363280.78 2 1181640.39 Prob > F = 0.0000 Residual | 12745927.3 7772 1639.98036 R-squared = 0.1564 -------------+------------------------------ Adj R-squared = 0.1562 Total | 15109208.1 7774 1943.55648 Root MSE = 40.497 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- eligible | -18.63028 1.48424 -12.55 0.000 -21.53979 -15.72077 score | .0694817 .0053841 12.91 0.000 .0589274 .080036 _cons | 26.37361 4.651641 5.67 0.000 17.25514 35.49208 ------------------------------------------------------------------------------ . *2; . *Plotting the predicted ophe against the score at baseline; . reg ophe score if round==0; Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 1, 7773) = 2932.42 Model | 957953.378 1 957953.378 Prob > F = 0.0000 Residual | 2539254.32 7773 326.676229 R-squared = 0.2739 -------------+------------------------------ Adj R-squared = 0.2738 Total | 3497207.7 7774 449.859493 Root MSE = 18.074 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- score | .0822131 .0015182 54.15 0.000 .0792371 .0851892 _cons | 7.057992 1.119621 6.30 0.000 4.863233 9.252751 ------------------------------------------------------------------------------ . predict ophe_pred1; (option xb assumed; fitted values) . graph7 ophe_pred1 score if round==0; . *Plotting the predicted values of ophe after the program; . reg ophe eligible score if round==1; Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 2, 7772) = 720.52 Model | 2363280.78 2 1181640.39 Prob > F = 0.0000 Residual | 12745927.3 7772 1639.98036 R-squared = 0.1564 -------------+------------------------------ Adj R-squared = 0.1562 Total | 15109208.1 7774 1943.55648 Root MSE = 40.497 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- eligible | -18.63028 1.48424 -12.55 0.000 -21.53979 -15.72077 score | .0694817 .0053841 12.91 0.000 .0589274 .080036 _cons | 26.37361 4.651641 5.67 0.000 17.25514 35.49208 ------------------------------------------------------------------------------ . predict ophe_pred2; (option xb assumed; fitted values) . graph7 ophe_pred2 score if round==1; . *3; . reg ophe eligible if round==1; Source | SS df MS Number of obs = 7775 -------------+------------------------------ F( 1, 7773) = 1247.93 Model | 2090160 1 2090160 Prob > F = 0.0000 Residual | 13019048.1 7773 1674.90648 R-squared = 0.1383 -------------+------------------------------ Adj R-squared = 0.1382 Total | 15109208.1 7774 1943.55648 Root MSE = 40.926 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- eligible | -33.47732 .947668 -35.33 0.000 -35.33501 -31.61964 _cons | 85.66586 .7344538 116.64 0.000 84.22613 87.10559 ------------------------------------------------------------------------------ . reg ophe eligible if round==1 & score>=500 & score <=1000; Source | SS df MS Number of obs = 7222 -------------+------------------------------ F( 1, 7220) = 1030.17 Model | 1694091.99 1 1694091.99 Prob > F = 0.0000 Residual | 11873144.7 7220 1644.47987 R-squared = 0.1249 -------------+------------------------------ Adj R-squared = 0.1247 Total | 13567236.7 7221 1878.85842 Root MSE = 40.552 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- eligible | -31.37421 .9775042 -32.10 0.000 -33.29041 -29.45802 _cons | 84.27888 .7622915 110.56 0.000 82.78456 85.77319 ------------------------------------------------------------------------------ . *4; . reg ophe eligible if round==1 & score>=600 & score <=900; Source | SS df MS Number of obs = 5767 -------------+------------------------------ F( 1, 5765) = 666.29 Model | 1096494.46 1 1096494.46 Prob > F = 0.0000 Residual | 9487328.91 5765 1645.67717 R-squared = 0.1036 -------------+------------------------------ Adj R-squared = 0.1034 Total | 10583823.4 5766 1835.5573 Root MSE = 40.567 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- eligible | -28.01327 1.085258 -25.81 0.000 -30.14078 -25.88575 _cons | 82.79124 .8320659 99.50 0.000 81.16007 84.4224 ------------------------------------------------------------------------------ . reg ophe eligible if round==1 & score>=700 & score <=800; Source | SS df MS Number of obs = 2358 -------------+------------------------------ F( 1, 2356) = 172.27 Model | 296780.193 1 296780.193 Prob > F = 0.0000 Residual | 4058790.92 2356 1722.74657 R-squared = 0.0681 -------------+------------------------------ Adj R-squared = 0.0677 Total | 4355571.12 2357 1847.93004 Root MSE = 41.506 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- eligible | -22.46864 1.711867 -13.13 0.000 -25.82557 -19.11172 _cons | 79.08421 1.241893 63.68 0.000 76.64889 81.51953 ------------------------------------------------------------------------------ . reg ophe eligible if round==1 & score>=725 & score <=775; Source | SS df MS Number of obs = 1239 -------------+------------------------------ F( 1, 1237) = 56.72 Model | 104111.305 1 104111.305 Prob > F = 0.0000 Residual | 2270561.49 1237 1835.53879 R-squared = 0.0438 -------------+------------------------------ Adj R-squared = 0.0431 Total | 2374672.79 1238 1918.1525 Root MSE = 42.843 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- eligible | -18.36532 2.438548 -7.53 0.000 -23.14946 -13.58117 _cons | 78.31737 1.774384 44.14 0.000 74.83623 81.7985 ------------------------------------------------------------------------------ . reg ophe eligible $controls1 $controls2 if round==1 & score>=725 & score <=775; Source | SS df MS Number of obs = 1239 -------------+------------------------------ F( 12, 1226) = 33.03 Model | 580184.272 12 48348.6894 Prob > F = 0.0000 Residual | 1794488.52 1226 1463.69373 R-squared = 0.2443 -------------+------------------------------ Adj R-squared = 0.2369 Total | 2374672.79 1238 1918.1525 Root MSE = 38.258 ----------------------------------------------------------------------------------- ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] ------------------+---------------------------------------------------------------- eligible | -10.25467 2.249953 -4.56 0.000 -14.66886 -5.840489 age_hh | .4702397 .1335751 3.52 0.000 .2081787 .7323008 educ_hh | -.0389413 .5208905 -0.07 0.940 -1.060877 .9829943 age_sp | -.3534496 .1566023 -2.26 0.024 -.6606879 -.0462114 educ_sp | -.3915476 .5728278 -0.68 0.494 -1.515379 .7322836 ethnicity_hh | -7.085017 2.432663 -2.91 0.004 -11.85766 -2.312374 female_hh | 10.68609 3.917849 2.73 0.006 2.999656 18.37252 hhsize_basal | -8.060578 .5286122 -15.25 0.000 -9.097663 -7.023493 dirtfloor_basal | -7.720266 2.416387 -3.19 0.001 -12.46098 -2.979554 bathroom_basal | -1.190503 2.310665 -0.52 0.606 -5.723799 3.342792 landhectars_basal | .7927674 .4197527 1.89 0.059 -.0307458 1.616281 min_dist | -.0617978 .0281812 -2.19 0.029 -.1170866 -.006509 _cons | 118.8434 7.286675 16.31 0.000 104.5476 133.1391 ----------------------------------------------------------------------------------- . *======================================* > CASE 4: VARIABLES INSTRUMENTALES > *======================================*; . use "$data\evaluation.dta", clear; (Household Roster (households with completed interview)) . *1; . *i; . ivreg ophe (takeup = treatcom) if round ==1 & eligible ==1; Instrumental variables (2SLS) regression Source | SS df MS Number of obs = 7397 -------------+------------------------------ F( 1, 7395) = 102.55 Model | 88195.1683 1 88195.1683 Prob > F = 0.0000 Residual | 7335270.51 7395 991.92299 R-squared = 0.0119 -------------+------------------------------ Adj R-squared = 0.0117 Total | 7423465.68 7396 1003.71359 Root MSE = 31.495 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | -7.85312 .7754815 -10.13 0.000 -9.373284 -6.332955 _cons | 59.87518 .6031098 99.28 0.000 58.69291 61.05744 ------------------------------------------------------------------------------ Instrumented: takeup Instruments: treatcom ------------------------------------------------------------------------------ . *ii; . ivreg ophe (takeup = treatcom) $controls1 if round ==1 & eligible ==1; Instrumental variables (2SLS) regression Source | SS df MS Number of obs = 7397 -------------+------------------------------ F( 7, 7389) = 38.71 Model | 248396.762 7 35485.2516 Prob > F = 0.0000 Residual | 7175068.92 7389 971.047356 R-squared = 0.0335 -------------+------------------------------ Adj R-squared = 0.0325 Total | 7423465.68 7396 1003.71359 Root MSE = 31.162 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | -7.715143 .7678823 -10.05 0.000 -9.220411 -6.209874 age_hh | .2123125 .0479664 4.43 0.000 .1182847 .3063402 educ_hh | -.1796059 .1688245 -1.06 0.287 -.51055 .1513383 age_sp | -.072448 .0561312 -1.29 0.197 -.1824811 .037585 educ_sp | .3806649 .1774804 2.14 0.032 .0327528 .728577 ethnicity_hh | -5.938338 .7406781 -8.02 0.000 -7.390278 -4.486398 female_hh | 8.277106 1.428419 5.79 0.000 5.476998 11.07721 _cons | 54.71358 1.910237 28.64 0.000 50.96897 58.45819 ------------------------------------------------------------------------------ Instrumented: takeup Instruments: age_hh educ_hh age_sp educ_sp ethnicity_hh female_hh treatcom ------------------------------------------------------------------------------ . *iii; . ivreg ophe (takeup = treatcom) $controls1 $controls2 if round ==1 & eligible ==1; Instrumental variables (2SLS) regression Source | SS df MS Number of obs = 7397 -------------+------------------------------ F( 12, 7384) = 149.48 Model | 1438794.53 12 119899.544 Prob > F = 0.0000 Residual | 5984671.15 7384 810.491759 R-squared = 0.1938 -------------+------------------------------ Adj R-squared = 0.1925 Total | 7423465.68 7396 1003.71359 Root MSE = 28.469 ----------------------------------------------------------------------------------- ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] ------------------+---------------------------------------------------------------- takeup | -7.498845 .7022148 -10.68 0.000 -8.875387 -6.122304 age_hh | .1588295 .044026 3.61 0.000 .0725259 .2451331 educ_hh | -.1888684 .1549997 -1.22 0.223 -.4927119 .1149752 age_sp | .017751 .0514007 0.35 0.730 -.083009 .118511 educ_sp | -.0947542 .1632209 -0.58 0.562 -.4147138 .2252054 ethnicity_hh | -6.777287 .7271341 -9.32 0.000 -8.202677 -5.351897 female_hh | 2.399435 1.318535 1.82 0.069 -.1852701 4.98414 hhsize_basal | -6.591382 .173979 -37.89 0.000 -6.93243 -6.250333 dirtfloor_basal | -7.068452 .7751825 -9.12 0.000 -8.588031 -5.548873 bathroom_basal | 1.257215 .6856146 1.83 0.067 -.0867854 2.601215 landhectars_basal | .3587988 .1328836 2.70 0.007 .098309 .6192886 min_dist | -.0208838 .0083142 -2.51 0.012 -.037182 -.0045855 _cons | 99.4915 2.235444 44.51 0.000 95.10939 103.8736 ----------------------------------------------------------------------------------- Instrumented: takeup Instruments: age_hh educ_hh age_sp educ_sp ethnicity_hh female_hh hhsize_basal dirtfloor_basal bathroom_basal landhectars_basal min_dist treatcom ----------------------------------------------------------------------------------- . *================================* > CASE 5: MATCHING > *================================*; . use "$data\evaluation.dta", clear; (Household Roster (households with completed interview)) . keep if round ==1 & treatcom ==1; (17897 observations deleted) . *1. Probability of participating; . logit takeup $controls1; Iteration 0: log likelihood = -5268.4195 Iteration 1: log likelihood = -4626.7186 Iteration 2: log likelihood = -4623.1893 Iteration 3: log likelihood = -4623.1876 Iteration 4: log likelihood = -4623.1876 Logistic regression Number of obs = 7775 LR chi2(6) = 1290.46 Prob > chi2 = 0.0000 Log likelihood = -4623.1876 Pseudo R2 = 0.1225 ------------------------------------------------------------------------------ takeup | Coef. Std. Err. z P>|z| [95% Conf. Interval] -------------+---------------------------------------------------------------- age_hh | -.0434995 .0030795 -14.13 0.000 -.0495353 -.0374637 educ_hh | -.1043772 .0115266 -9.06 0.000 -.1269689 -.0817854 age_sp | -.0308608 .003638 -8.48 0.000 -.0379911 -.0237304 educ_sp | -.1119489 .0127807 -8.76 0.000 -.1369985 -.0868992 ethnicity_hh | .6685602 .0539226 12.40 0.000 .5628739 .7742464 female_hh | -.3711366 .086824 -4.27 0.000 -.5413085 -.2009646 _cons | 4.118029 .1470054 28.01 0.000 3.829904 4.406154 ------------------------------------------------------------------------------ . predict pscore; (option pr assumed; Pr(takeup)) . kdensity pscore if takeup ==1, gen(take1 den1); . kdensity pscore if takeup ==0, gen(take0 den0); . twoway (line den0 take0) (line den1 take1); . *2. Generate quintiles; . xtile prob_tile = pscore, nq(5); . *3. Average comparison; . foreach x of varlist age_hh educ_hh age_sp educ_sp ethnicity_hh female_hh > {; 2. foreach y of numlist 1/5 > {; 3. ttest `x' if prob_tile ==`y', by(takeup); 4. }; 5. }; Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 1086 66.07366 .3153128 10.39098 65.45497 66.69236 1 | 469 67.27292 .4750488 10.28785 66.33943 68.20641 ---------+-------------------------------------------------------------------- combined | 1555 66.43537 .2630074 10.3713 65.91948 66.95126 ---------+-------------------------------------------------------------------- diff | -1.199256 .5724321 -2.322078 -.0764348 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -2.0950 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.0182 Pr(|T| > |t|) = 0.0363 Pr(T > t) = 0.9818 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 882 53.28798 .3539001 10.5103 52.5934 53.98257 1 | 673 52.66731 .4032689 10.4617 51.87549 53.45913 ---------+-------------------------------------------------------------------- combined | 1555 53.01936 .2660285 10.49043 52.49755 53.54117 ---------+-------------------------------------------------------------------- diff | .6206686 .5368707 -.4323995 1.673737 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 1.1561 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.8761 Pr(|T| > |t|) = 0.2478 Pr(T > t) = 0.1239 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 574 45.1622 .4194937 10.05035 44.33827 45.98613 1 | 981 43.66565 .2982685 9.342045 43.08033 44.25097 ---------+-------------------------------------------------------------------- combined | 1555 44.21807 .2442974 9.633499 43.73888 44.69726 ---------+-------------------------------------------------------------------- diff | 1.496551 .5049798 .5060369 2.487065 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 2.9636 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.9985 Pr(|T| > |t|) = 0.0031 Pr(T > t) = 0.0015 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 411 38.85645 .4940122 10.01518 37.88533 39.82756 1 | 1144 37.75175 .2445208 8.270445 37.27199 38.23151 ---------+-------------------------------------------------------------------- combined | 1555 38.04373 .2225415 8.775589 37.60722 38.48024 ---------+-------------------------------------------------------------------- diff | 1.104699 .5040536 .1160019 2.093397 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 2.1916 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.9857 Pr(|T| > |t|) = 0.0286 Pr(T > t) = 0.0143 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 251 32.39442 .5230915 8.287328 31.36419 33.42465 1 | 1304 32.83819 .1976711 7.138089 32.4504 33.22598 ---------+-------------------------------------------------------------------- combined | 1555 32.76656 .1860023 7.334719 32.40172 33.1314 ---------+-------------------------------------------------------------------- diff | -.4437679 .5055978 -1.435494 .5479584 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -0.8777 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.1901 Pr(|T| > |t|) = 0.3802 Pr(T > t) = 0.8099 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 1086 2.334585 .0984073 3.242964 2.141495 2.527675 1 | 469 1.785415 .122676 2.656722 1.544351 2.026479 ---------+-------------------------------------------------------------------- combined | 1555 2.168951 .0782938 3.087397 2.015379 2.322524 ---------+-------------------------------------------------------------------- diff | .5491705 .170076 .2155676 .8827734 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 3.2290 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.9994 Pr(|T| > |t|) = 0.0013 Pr(T > t) = 0.0006 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 882 2.507392 .0957169 2.842648 2.319532 2.695252 1 | 673 2.580505 .1107495 2.873089 2.363048 2.797961 ---------+-------------------------------------------------------------------- combined | 1555 2.539035 .0724047 2.855171 2.397014 2.681056 ---------+-------------------------------------------------------------------- diff | -.073113 .1461707 -.3598257 .2135998 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -0.5002 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.3085 Pr(|T| > |t|) = 0.6170 Pr(T > t) = 0.6915 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 574 3.155644 .120911 2.896821 2.918162 3.393127 1 | 981 3.375147 .0877179 2.747404 3.203011 3.547284 ---------+-------------------------------------------------------------------- combined | 1555 3.294122 .0711213 2.804561 3.154618 3.433626 ---------+-------------------------------------------------------------------- diff | -.219503 .1473225 -.5084751 .0694691 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -1.4899 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.0682 Pr(|T| > |t|) = 0.1364 Pr(T > t) = 0.9318 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 411 3.317956 .1337281 2.711089 3.055077 3.580834 1 | 1144 3.454545 .0747034 2.526697 3.307974 3.601117 ---------+-------------------------------------------------------------------- combined | 1555 3.418444 .0653388 2.576535 3.290282 3.546605 ---------+-------------------------------------------------------------------- diff | -.1365899 .1481796 -.427243 .1540633 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -0.9218 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.1784 Pr(|T| > |t|) = 0.3568 Pr(T > t) = 0.8216 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 251 3.039919 .1590273 2.519466 2.726715 3.353123 1 | 1304 2.82595 .0672842 2.429695 2.693953 2.957948 ---------+-------------------------------------------------------------------- combined | 1555 2.860488 .0619993 2.444851 2.738877 2.982099 ---------+-------------------------------------------------------------------- diff | .2139685 .1684831 -.1165098 .5444468 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 1.2700 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.8979 Pr(|T| > |t|) = 0.2043 Pr(T > t) = 0.1021 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 1086 54.22247 .3657551 12.05328 53.5048 54.94014 1 | 469 55.65406 .5895617 12.76779 54.49554 56.81258 ---------+-------------------------------------------------------------------- combined | 1555 54.65425 .3115783 12.28662 54.04309 55.26541 ---------+-------------------------------------------------------------------- diff | -1.431588 .6781314 -2.761738 -.1014381 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -2.1111 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.0175 Pr(|T| > |t|) = 0.0349 Pr(T > t) = 0.9825 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 882 46.12944 .3016954 8.959896 45.53731 46.72156 1 | 673 45.58614 .3504086 9.090385 44.89811 46.27417 ---------+-------------------------------------------------------------------- combined | 1555 45.8943 .2286815 9.017711 45.44574 46.34286 ---------+-------------------------------------------------------------------- diff | .5432947 .4614937 -.3619218 1.448511 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 1.1773 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.8804 Pr(|T| > |t|) = 0.2393 Pr(T > t) = 0.1196 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 574 40.47725 .3789307 9.078535 39.73298 41.22151 1 | 981 38.76604 .2626102 8.225191 38.2507 39.28139 ---------+-------------------------------------------------------------------- combined | 1555 39.3977 .21776 8.587037 38.97057 39.82484 ---------+-------------------------------------------------------------------- diff | 1.711204 .4493027 .8299004 2.592508 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 3.8086 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.9999 Pr(|T| > |t|) = 0.0001 Pr(T > t) = 0.0001 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 411 35.18408 .4809795 9.750963 34.23859 36.12957 1 | 1144 34.32265 .2318209 7.840893 33.86781 34.77749 ---------+-------------------------------------------------------------------- combined | 1555 34.55033 .2128504 8.393434 34.13283 34.96784 ---------+-------------------------------------------------------------------- diff | .8614315 .4823533 -.084701 1.807564 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 1.7859 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.9628 Pr(|T| > |t|) = 0.0743 Pr(T > t) = 0.0372 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 251 29.767 .5485231 8.690241 28.68668 30.84731 1 | 1304 29.80262 .191036 6.898488 29.42784 30.17739 ---------+-------------------------------------------------------------------- combined | 1555 29.79687 .1829591 7.214715 29.43799 30.15574 ---------+-------------------------------------------------------------------- diff | -.035619 .4974481 -1.01136 .9401219 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -0.0716 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.4715 Pr(|T| > |t|) = 0.9429 Pr(T > t) = 0.5285 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 1086 2.414407 .0825178 2.719334 2.252494 2.576319 1 | 469 2.006665 .1108871 2.401416 1.788767 2.224563 ---------+-------------------------------------------------------------------- combined | 1555 2.291429 .0667807 2.633397 2.160439 2.422418 ---------+-------------------------------------------------------------------- diff | .4077416 .1451844 .1229635 .6925198 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 2.8084 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.9975 Pr(|T| > |t|) = 0.0050 Pr(T > t) = 0.0025 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 882 2.684028 .0888352 2.638271 2.509674 2.858381 1 | 673 2.775286 .0953632 2.473935 2.588041 2.962532 ---------+-------------------------------------------------------------------- combined | 1555 2.723524 .0651229 2.568024 2.595786 2.851262 ---------+-------------------------------------------------------------------- diff | -.0912586 .1314604 -.3491172 .1666 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -0.6942 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.2438 Pr(|T| > |t|) = 0.4877 Pr(T > t) = 0.7562 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 574 3.003312 .1137088 2.72427 2.779975 3.226649 1 | 981 3.257094 .0786493 2.46337 3.102753 3.411434 ---------+-------------------------------------------------------------------- combined | 1555 3.163415 .0650419 2.564829 3.035836 3.290994 ---------+-------------------------------------------------------------------- diff | -.2537817 .1346719 -.5179396 .0103762 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -1.8844 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.0298 Pr(|T| > |t|) = 0.0597 Pr(T > t) = 0.9702 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 411 3.259149 .1340476 2.717564 2.995643 3.522655 1 | 1144 3.293662 .0719367 2.433118 3.15252 3.434805 ---------+-------------------------------------------------------------------- combined | 1555 3.28454 .0636663 2.510584 3.159659 3.409421 ---------+-------------------------------------------------------------------- diff | -.0345132 .1444235 -.3177988 .2487724 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -0.2390 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.4056 Pr(|T| > |t|) = 0.8112 Pr(T > t) = 0.5944 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 251 2.541639 .1481135 2.34656 2.24993 2.833349 1 | 1304 2.247324 .063112 2.279033 2.123512 2.371136 ---------+-------------------------------------------------------------------- combined | 1555 2.294831 .0581197 2.291862 2.180829 2.408832 ---------+-------------------------------------------------------------------- diff | .2943156 .1578455 -.0152972 .6039284 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 1.8646 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.9688 Pr(|T| > |t|) = 0.0624 Pr(T > t) = 0.0312 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 1086 .1040516 .0092694 .3054681 .0858636 .1222395 1 | 469 .1641791 .0171235 .3708336 .1305306 .1978276 ---------+-------------------------------------------------------------------- combined | 1555 .1221865 .0083078 .3276064 .1058908 .1384822 ---------+-------------------------------------------------------------------- diff | -.0601275 .018043 -.0955188 -.0247363 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -3.3325 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.0004 Pr(|T| > |t|) = 0.0009 Pr(T > t) = 0.9996 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 882 .2335601 .0142544 .4233355 .2055835 .2615367 1 | 673 .268945 .017105 .4437411 .2353594 .3025306 ---------+-------------------------------------------------------------------- combined | 1555 .2488746 .0109678 .4325001 .2273613 .2703879 ---------+-------------------------------------------------------------------- diff | -.0353849 .0221254 -.0787838 .008014 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -1.5993 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.0550 Pr(|T| > |t|) = 0.1100 Pr(T > t) = 0.9450 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 574 .3710801 .0201815 .4835152 .3314413 .4107189 1 | 981 .2925586 .0145324 .4551695 .2640403 .3210769 ---------+-------------------------------------------------------------------- combined | 1555 .3215434 .0118483 .467219 .2983031 .3447837 ---------+-------------------------------------------------------------------- diff | .0785215 .0244794 .0305053 .1265377 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 3.2077 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.9993 Pr(|T| > |t|) = 0.0014 Pr(T > t) = 0.0007 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 411 .4452555 .0245448 .4975997 .3970062 .4935048 1 | 1144 .3951049 .0144602 .489087 .3667335 .4234763 ---------+-------------------------------------------------------------------- combined | 1555 .4083601 .0124688 .4916885 .3839027 .4328176 ---------+-------------------------------------------------------------------- diff | .0501506 .0282567 -.0052747 .1055758 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 1.7748 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.9619 Pr(|T| > |t|) = 0.0761 Pr(T > t) = 0.0381 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 251 .5896414 .0311104 .4928816 .5283695 .6509133 1 | 1304 .7016871 .0126746 .4576931 .6768222 .726552 ---------+-------------------------------------------------------------------- combined | 1555 .6836013 .0117976 .4652201 .6604604 .7067422 ---------+-------------------------------------------------------------------- diff | -.1120457 .0319503 -.174716 -.0493754 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -3.5069 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.0002 Pr(|T| > |t|) = 0.0005 Pr(T > t) = 0.9998 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 1086 .2117864 .0124038 .4087625 .1874481 .2361246 1 | 469 .1876333 .0180471 .3908359 .1521698 .2230967 ---------+-------------------------------------------------------------------- combined | 1555 .2045016 .0102316 .4034667 .1844325 .2245708 ---------+-------------------------------------------------------------------- diff | .0241531 .0222919 -.0195723 .0678785 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 1.0835 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.8606 Pr(|T| > |t|) = 0.2788 Pr(T > t) = 0.1394 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 882 .1360544 .0115508 .3430409 .1133842 .1587247 1 | 673 .1589896 .0141059 .3659384 .1312927 .1866865 ---------+-------------------------------------------------------------------- combined | 1555 .1459807 .0089569 .3532005 .1284119 .1635495 ---------+-------------------------------------------------------------------- diff | -.0229352 .0180742 -.0583876 .0125173 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -1.2689 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.1023 Pr(|T| > |t|) = 0.2047 Pr(T > t) = 0.8977 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 574 .0923345 .0120939 .2897501 .0685806 .1160883 1 | 981 .0958206 .0094025 .2944952 .0773692 .114272 ---------+-------------------------------------------------------------------- combined | 1555 .0945338 .0074217 .292664 .0799761 .1090914 ---------+-------------------------------------------------------------------- diff | -.0034861 .0153843 -.0336622 .02669 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -0.2266 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.4104 Pr(|T| > |t|) = 0.8208 Pr(T > t) = 0.5896 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 411 .0291971 .0083146 .1685638 .0128524 .0455417 1 | 1144 .0323427 .0052327 .1769858 .0220759 .0426094 ---------+-------------------------------------------------------------------- combined | 1555 .0315113 .0044315 .1747511 .0228188 .0402037 ---------+-------------------------------------------------------------------- diff | -.0031456 .0100526 -.0228636 .0165725 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -0.3129 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.3772 Pr(|T| > |t|) = 0.7544 Pr(T > t) = 0.6228 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 251 .0079681 .005623 .0890857 -.0031064 .0190427 1 | 1304 .0069018 .0022935 .0828219 .0024024 .0114013 ---------+-------------------------------------------------------------------- combined | 1555 .007074 .002126 .0838358 .0029038 .0112441 ---------+-------------------------------------------------------------------- diff | .0010663 .0057803 -.0102718 .0124044 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 0.1845 Ho: diff = 0 degrees of freedom = 1553 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.5732 Pr(|T| > |t|) = 0.8537 Pr(T > t) = 0.4268 . *4. OLS in the balanced quintiles; . *(i) Without controls; . reg ophe takeup if prob_tile >=2 & prob_tile <=4; Source | SS df MS Number of obs = 4665 -------------+------------------------------ F( 1, 4663) = 531.19 Model | 756891.823 1 756891.823 Prob > F = 0.0000 Residual | 6644259.87 4663 1424.88953 R-squared = 0.1023 -------------+------------------------------ Adj R-squared = 0.1021 Total | 7401151.7 4664 1586.86786 Root MSE = 37.748 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | -25.99841 1.128029 -23.05 0.000 -28.20988 -23.78693 _cons | 78.04104 .8736117 89.33 0.000 76.32835 79.75374 ------------------------------------------------------------------------------ . *(ii) Including pscore as a control; . reg ophe takeup pscore if prob_tile >=2 & prob_tile <=4; Source | SS df MS Number of obs = 4665 -------------+------------------------------ F( 2, 4662) = 281.80 Model | 798246.148 2 399123.074 Prob > F = 0.0000 Residual | 6602905.55 4662 1416.32466 R-squared = 0.1079 -------------+------------------------------ Adj R-squared = 0.1075 Total | 7401151.7 4664 1586.86786 Root MSE = 37.634 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- takeup | -24.32368 1.166559 -20.85 0.000 -26.61068 -22.03667 pscore | -30.43726 5.632828 -5.40 0.000 -41.48027 -19.39425 _cons | 95.44268 3.336113 28.61 0.000 88.90232 101.983 ------------------------------------------------------------------------------ . *5. Use psmatch2 command > * (i) let it calculate propensity score using controls; . psmatch2 takeup $controls1 $controls2, out(ophe); Probit regression Number of obs = 7775 LR chi2(11) = 2475.45 Prob > chi2 = 0.0000 Log likelihood = -4030.6958 Pseudo R2 = 0.2349 ------------------------------------------------------------------------------ takeup | Coef. Std. Err. z P>|z| [95% Conf. Interval] -------------+---------------------------------------------------------------- age_hh | -.0194497 .0019688 -9.88 0.000 -.0233086 -.0155908 educ_hh | -.0484692 .0073272 -6.61 0.000 -.0628302 -.0341082 age_sp | -.018038 .0022927 -7.87 0.000 -.0225316 -.0135443 educ_sp | -.0374161 .008088 -4.63 0.000 -.0532682 -.021564 ethnicity_hh | .2828849 .0362622 7.80 0.000 .2118123 .3539576 female_hh | -.0882187 .0575876 -1.53 0.126 -.2010882 .0246509 hhsize_basal | .2117337 .0079329 26.69 0.000 .1961854 .2272819 dirtfloor_~l | .6887635 .0342953 20.08 0.000 .6215459 .7559811 bathroom_b~l | -.229428 .0340143 -6.75 0.000 -.2960947 -.1627612 landhectar~l | -.0488611 .0055285 -8.84 0.000 -.0596968 -.0380255 min_dist | .0016101 .0004096 3.93 0.000 .0008072 .002413 _cons | .6183208 .1087314 5.69 0.000 .4052112 .8314304 ------------------------------------------------------------------------------ ---------------------------------------------------------------------------------------- Variable Sample | Treated Controls Difference S.E. T-stat ----------------------------+----------------------------------------------------------- ophe Unmatched | 52.2937256 84.4813791 -32.1876535 .947966805 -33.95 ATT | 52.2937256 66.0254728 -13.7317472 1.95801705 -7.01 ----------------------------+----------------------------------------------------------- Note: S.E. does not take into account that the propensity score is estimated. | psmatch2: psmatch2: | Common Treatment | support assignment | On suppor | Total -----------+-----------+---------- Untreated | 3,204 | 3,204 Treated | 4,571 | 4,571 -----------+-----------+---------- Total | 7,775 | 7,775 . * (i) use already obtained propensity score, without imposing common support; . psmatch2 takeup, out(ophe) pscore (pscore); There are observations with identical propensity score values. The sort order of the data could affect your results. Make sure that the sort order is random before calling psmatch2. ---------------------------------------------------------------------------------------- Variable Sample | Treated Controls Difference S.E. T-stat ----------------------------+----------------------------------------------------------- ophe Unmatched | 52.2937256 84.4813791 -32.1876535 .947966805 -33.95 ATT | 52.2937256 78.9537467 -26.6600211 1.67256719 -15.94 ----------------------------+----------------------------------------------------------- Note: S.E. does not take into account that the propensity score is estimated. | psmatch2: psmatch2: | Common Treatment | support assignment | On suppor | Total -----------+-----------+---------- Untreated | 3,204 | 3,204 Treated | 4,571 | 4,571 -----------+-----------+---------- Total | 7,775 | 7,775 . * (i) use already obtained propensity score, imposing common support; . psmatch2 takeup, out(ophe) pscore (pscore) com; There are observations with identical propensity score values. The sort order of the data could affect your results. Make sure that the sort order is random before calling psmatch2. ---------------------------------------------------------------------------------------- Variable Sample | Treated Controls Difference S.E. T-stat ----------------------------+----------------------------------------------------------- ophe Unmatched | 52.2937256 84.4813791 -32.1876535 .947966805 -33.95 ATT | 52.3226472 78.9886863 -26.6660391 1.67266939 -15.94 ----------------------------+----------------------------------------------------------- Note: S.E. does not take into account that the propensity score is estimated. psmatch2: | psmatch2: Common Treatment | support assignment | Off suppo On suppor | Total -----------+----------------------+---------- Untreated | 0 3,204 | 3,204 Treated | 7 4,564 | 4,571 -----------+----------------------+---------- Total | 7 7,768 | 7,775 . * (i) use already obtained propensity score, imposing common support, kernel; . psmatch2 takeup, out(ophe) pscore (pscore) kernel com; ---------------------------------------------------------------------------------------- Variable Sample | Treated Controls Difference S.E. T-stat ----------------------------+----------------------------------------------------------- ophe Unmatched | 52.2937256 84.4813791 -32.1876535 .947966805 -33.95 ATT | 52.3226472 77.6213024 -25.2986552 1.33306838 -18.98 ----------------------------+----------------------------------------------------------- Note: S.E. does not take into account that the propensity score is estimated. psmatch2: | psmatch2: Common Treatment | support assignment | Off suppo On suppor | Total -----------+----------------------+---------- Untreated | 0 3,204 | 3,204 Treated | 7 4,564 | 4,571 -----------+----------------------+---------- Total | 7 7,768 | 7,775 . *5. age2, age3, educ2, educ3, hhsize2, hhsize3; . *================================* > CASE 6: ALEATORIZACION > *================================*; . use "$data\evaluation.dta", clear; (Household Roster (households with completed interview)) . tab eligible treatcom if round==0; | control community =0; Eligible | treatment community household | =1 = 1 | 0 1 | Total -----------+----------------------+---------- 0 | 2,334 3,105 | 5,439 1 | 2,727 4,670 | 7,397 -----------+----------------------+---------- Total | 5,061 7,775 | 12,836 . *1; . foreach x of global variables1 > {; 2. describe `x'; 3. ttest `x' if round==0 & eligible, by(treatcom); 4. }; storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- ophe float %9.0g Out of pocket health expenditures (per capita per month) Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 2727 58.35079 .3257011 17.00834 57.71214 58.98943 1 | 4670 58.36946 .2554968 17.45999 57.86856 58.87035 ---------+-------------------------------------------------------------------- combined | 7397 58.36257 .2010759 17.2937 57.96841 58.75674 ---------+-------------------------------------------------------------------- diff | -.0186729 .4168157 -.8357504 .7984045 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -0.0448 Ho: diff = 0 degrees of freedom = 7395 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.4821 Pr(|T| > |t|) = 0.9643 Pr(T > t) = 0.5179 storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- age_hh float %9.0g Head's age Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 2727 42.35314 .2758298 14.40402 41.81228 42.89399 1 | 4670 41.94756 .2013988 13.76307 41.55272 42.3424 ---------+-------------------------------------------------------------------- combined | 7397 42.09708 .1628166 14.00317 41.77791 42.41625 ---------+-------------------------------------------------------------------- diff | .405576 .337474 -.255969 1.067121 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 1.2018 Ho: diff = 0 degrees of freedom = 7395 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.8853 Pr(|T| > |t|) = 0.2295 Pr(T > t) = 0.1147 storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- educ_hh float %9.0g Head's education - years Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 2727 2.81513 .0495828 2.589247 2.717906 2.912354 1 | 4670 2.952663 .0390954 2.671678 2.876018 3.029309 ---------+-------------------------------------------------------------------- combined | 7397 2.90196 .0307217 2.642246 2.841737 2.962183 ---------+-------------------------------------------------------------------- diff | -.1375334 .0636638 -.2623325 -.0127342 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -2.1603 Ho: diff = 0 degrees of freedom = 7395 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.0154 Pr(|T| > |t|) = 0.0308 Pr(T > t) = 0.9846 storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- age_sp float %9.0g Spouse's age Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 2727 36.96081 .224439 11.72036 36.52072 37.4009 1 | 4670 37.0697 .1706035 11.6586 36.73524 37.40417 ---------+-------------------------------------------------------------------- combined | 7397 37.02956 .1358133 11.68073 36.76333 37.29579 ---------+-------------------------------------------------------------------- diff | -.1088914 .2815281 -.6607667 .4429838 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -0.3868 Ho: diff = 0 degrees of freedom = 7395 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.3495 Pr(|T| > |t|) = 0.6989 Pr(T > t) = 0.6505 storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- educ_sp float %9.0g Spouse's education - years Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 2727 2.767278 .0484081 2.527902 2.672358 2.862198 1 | 4670 2.767649 .0358233 2.448072 2.697418 2.837879 ---------+-------------------------------------------------------------------- combined | 7397 2.767512 .0288077 2.477632 2.711041 2.823983 ---------+-------------------------------------------------------------------- diff | -.0003704 .0597163 -.1174314 .1166905 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -0.0062 Ho: diff = 0 degrees of freedom = 7395 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.4975 Pr(|T| > |t|) = 0.9951 Pr(T > t) = 0.5025 storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- ethnicity_hh float %9.0g (ind) =1 if indiv. speaks an indigenous language Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 2727 .4195086 .0094516 .4935691 .4009756 .4380416 1 | 4670 .4169165 .0072157 .4931016 .4027703 .4310627 ---------+-------------------------------------------------------------------- combined | 7397 .4178721 .005735 .4932422 .4066299 .4291143 ---------+-------------------------------------------------------------------- diff | .0025921 .0118882 -.0207121 .0258963 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 0.2180 Ho: diff = 0 degrees of freedom = 7395 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.5863 Pr(|T| > |t|) = 0.8274 Pr(T > t) = 0.4137 storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- female_hh float %9.0g Head is Female =1 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 2727 .0781078 .0051395 .2683904 .06803 .0881856 1 | 4670 .0738758 .003828 .2615967 .0663711 .0813805 ---------+-------------------------------------------------------------------- combined | 7397 .075436 .0030709 .2641114 .0694162 .0814557 ---------+-------------------------------------------------------------------- diff | .004232 .0063655 -.0082461 .0167101 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 0.6648 Ho: diff = 0 degrees of freedom = 7395 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.7469 Pr(|T| > |t|) = 0.5062 Pr(T > t) = 0.2531 storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- hhsize_basal float %9.0g household size at baseline Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 2727 5.70297 .0380336 1.986141 5.628393 5.777548 1 | 4670 5.761456 .0292213 1.996906 5.704169 5.818744 ---------+-------------------------------------------------------------------- combined | 7397 5.739895 .023173 1.99301 5.694469 5.78532 ---------+-------------------------------------------------------------------- diff | -.0584858 .048031 -.1526403 .0356687 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -1.2177 Ho: diff = 0 degrees of freedom = 7395 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.1117 Pr(|T| > |t|) = 0.2234 Pr(T > t) = 0.8883 storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- dirtfloor_basal byte %8.0g dirt floor at baseline =1 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 2727 .7389072 .0084126 .4393109 .7224115 .7554029 1 | 4670 .7119914 .0066272 .4528836 .6989991 .7249838 ---------+-------------------------------------------------------------------- combined | 7397 .7219143 .00521 .4480861 .7117013 .7321273 ---------+-------------------------------------------------------------------- diff | .0269158 .0107953 .0057539 .0480777 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 2.4933 Ho: diff = 0 degrees of freedom = 7395 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.9937 Pr(|T| > |t|) = 0.0127 Pr(T > t) = 0.0063 storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- bathroom_basal byte %8.0g bathroom at baseline = 1 Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 2727 .5603227 .0095066 .4964389 .5416819 .5789635 1 | 4670 .5728051 .0072394 .494724 .5586124 .5869978 ---------+-------------------------------------------------------------------- combined | 7397 .5682033 .0057596 .4953599 .5569128 .5794938 ---------+-------------------------------------------------------------------- diff | -.0124824 .0119384 -.035885 .0109202 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -1.0456 Ho: diff = 0 degrees of freedom = 7395 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.1479 Pr(|T| > |t|) = 0.2958 Pr(T > t) = 0.8521 storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- landhectars_b~l byte %9.0g (hh) total hectars of land Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 2727 1.723139 .0506409 2.644501 1.623841 1.822437 1 | 4670 1.638972 .0371344 2.537671 1.566171 1.711773 ---------+-------------------------------------------------------------------- combined | 7397 1.670001 .0299714 2.577712 1.611249 1.728754 ---------+-------------------------------------------------------------------- diff | .0841668 .0621208 -.0376076 .2059412 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 1.3549 Ho: diff = 0 degrees of freedom = 7395 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.9123 Pr(|T| > |t|) = 0.1755 Pr(T > t) = 0.0877 storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- min_dist double %11.0g distance from community to closest Hospital(km) Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 2727 106.5951 .8182168 42.72784 104.9907 108.1995 1 | 4670 109.2872 .6097702 41.67011 108.0917 110.4826 ---------+-------------------------------------------------------------------- combined | 7397 108.2947 .489273 42.08032 107.3356 109.2538 ---------+-------------------------------------------------------------------- diff | -2.692088 1.013744 -4.679315 -.7048614 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = -2.6556 Ho: diff = 0 degrees of freedom = 7395 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 0.0040 Pr(|T| > |t|) = 0.0079 Pr(T > t) = 0.9960 . *2; . ttest ophe if round==1 & eligible==1, by (treatcom); Two-sample t test with equal variances ------------------------------------------------------------------------------ Group | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- 0 | 2727 59.87518 .5648961 29.49926 58.76751 60.98284 1 | 4670 52.18854 .4764452 32.55902 51.25448 53.12259 ---------+-------------------------------------------------------------------- combined | 7397 55.02232 .3683639 31.68144 54.30022 55.74441 ---------+-------------------------------------------------------------------- diff | 7.68664 .7583417 6.200075 9.173206 ------------------------------------------------------------------------------ diff = mean(0) - mean(1) t = 10.1361 Ho: diff = 0 degrees of freedom = 7395 Ha: diff < 0 Ha: diff != 0 Ha: diff > 0 Pr(T < t) = 1.0000 Pr(|T| > |t|) = 0.0000 Pr(T > t) = 0.0000 . *3; . *i; . reg ophe treatcom if round==1 & eligible==1; Source | SS df MS Number of obs = 7397 -------------+------------------------------ F( 1, 7395) = 102.74 Model | 101723.087 1 101723.087 Prob > F = 0.0000 Residual | 7321742.59 7395 990.093657 R-squared = 0.0137 -------------+------------------------------ Adj R-squared = 0.0136 Total | 7423465.68 7396 1003.71359 Root MSE = 31.466 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- treatcom | -7.68664 .7583417 -10.14 0.000 -9.173206 -6.200075 _cons | 59.87518 .6025534 99.37 0.000 58.694 61.05635 ------------------------------------------------------------------------------ . *ii; . reg ophe treatcom $controls1 if round==1 & eligible==1; Source | SS df MS Number of obs = 7397 -------------+------------------------------ F( 7, 7389) = 38.79 Model | 263139.826 7 37591.4037 Prob > F = 0.0000 Residual | 7160325.85 7389 969.052084 R-squared = 0.0354 -------------+------------------------------ Adj R-squared = 0.0345 Total | 7423465.68 7396 1003.71359 Root MSE = 31.13 ------------------------------------------------------------------------------ ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- treatcom | -7.551109 .7507836 -10.06 0.000 -9.022859 -6.079359 age_hh | .2142521 .0479124 4.47 0.000 .1203302 .3081741 educ_hh | -.1766159 .1686579 -1.05 0.295 -.5072335 .1540017 age_sp | -.0732899 .0560714 -1.31 0.191 -.1832057 .036626 educ_sp | .3738553 .1773032 2.11 0.035 .0262904 .7214202 ethnicity_hh | -5.970241 .7399211 -8.07 0.000 -7.420697 -4.519785 female_hh | 8.305747 1.426952 5.82 0.000 5.508515 11.10298 _cons | 54.68297 1.907535 28.67 0.000 50.94366 58.42228 ------------------------------------------------------------------------------ . *iii; . reg ophe treatcom $controls1 $controls2 if round==1 & eligible==1; Source | SS df MS Number of obs = 7397 -------------+------------------------------ F( 12, 7384) = 149.86 Model | 1453844.49 12 121153.708 Prob > F = 0.0000 Residual | 5969621.18 7384 808.453573 R-squared = 0.1958 -------------+------------------------------ Adj R-squared = 0.1945 Total | 7423465.68 7396 1003.71359 Root MSE = 28.433 ----------------------------------------------------------------------------------- ophe | Coef. Std. Err. t P>|t| [95% Conf. Interval] ------------------+---------------------------------------------------------------- treatcom | -7.340958 .6865648 -10.69 0.000 -8.686821 -5.995095 age_hh | .1605522 .0439668 3.65 0.000 .0743648 .2467396 educ_hh | -.1856506 .1548107 -1.20 0.230 -.4891237 .1178224 age_sp | .0169904 .0513343 0.33 0.741 -.0836394 .1176202 educ_sp | -.1019037 .1630226 -0.63 0.532 -.4214744 .2176671 ethnicity_hh | -6.824433 .7262334 -9.40 0.000 -8.248058 -5.400808 female_hh | 2.425367 1.316884 1.84 0.066 -.1561014 5.006835 hhsize_basal | -6.593968 .1737573 -37.95 0.000 -6.934582 -6.253354 dirtfloor_basal | -7.076904 .7742281 -9.14 0.000 -8.594612 -5.559196 bathroom_basal | 1.200041 .6847042 1.75 0.080 -.142175 2.542256 landhectars_basal | .3612661 .1327118 2.72 0.007 .1011132 .621419 min_dist | -.0200554 .008306 -2.41 0.016 -.0363376 -.0037732 _cons | 99.43459 2.231664 44.56 0.000 95.0599 103.8093 ----------------------------------------------------------------------------------- . end of do-file . log close name: log: D:\DATA.IDB\Courses\Chile\FINAL FINAL\myownthing Chile\solution_log FINAL VERSION.txt log type: text closed on: 7 Feb 2012, 12:00:49 -----------------------------------------------------------------------------------------------------------