7,612
edits
Changes
Jump to navigation
Jump to search
Urban Start-up Agglomeration and Venture Capital Investment (view source)
Revision as of 14:27, 3 November 2020
, 14:27, 3 November 2020→New Do File
reg growthinv18lfperstartup i.year i.placeid nohull tothullcountl tothullareal tothulldensityl avghulldisthml if regheur1==1, cluster(placeid)
nohull | .0029949 0029323 .0007993 0007413 3.75 96 0.000 .0014186 0014704 .00457130043941 tothullcountl | -.0555213 0526231 .0124065 0113923 -4.48 62 0.000 -.0799879 0750896 -.03105470301567 tothullareal | .0194877 0155028 .0041551 0041201 43.69 76 0.000 .0112936 0073776 .0276819023628 tothulldensityl | .0083321 0057162 .0049398 0040038 1.69 43 0.093 155 -.0014096 0021797 .01807370136121 avghulldisthml | -.001081 0022889 .0027112 0029852 -0.40 77 0.691 444 -.0042658 0081759 .0064277003598
reg growthinv18lfperstartup i.year i.placeid nohull tothullcountl tothullareal tothulldensityl avghulldisthml growthinv18l numstartupsl numdealsl if regheur1==1, cluster(placeid)
nohull | .0045458 0047632 .0007755 0007554 56.86 31 0.000 .0030165 0032736 .00607520062528 tothullcountl | .0042399 0008837 .0087493 012177 0.48 07 0.629 942 -.0130145 0231303 .02149430248977 tothullareal | .0045121 0011863 .0042544 0042324 10.06 28 0.290 780 -.0038778 0071603 .01290210095329 tothulldensityl | .0163778 0067998 .0048519 0043843 31.38 55 0.001 123 -.0018464 .0068095 .0259462015446 avghulldisthml | -.0024717 0063252 .0026637 0028367 -02.93 23 0.355 027 -.0077247 0119194 -.00278130007311 growthinv18l | .0075835 0076041 .0025118 0024995 3.02 04 0.003 .0026301 0026749 .0125370125333 numstartupsl | -.1492758 1450849 .016447 0158493 -9.08 15 0.000 -.1817106 176341 -.11684111138289 numdealsl | .0121621 0124877 .005014 0050118 2.43 49 0.016 014 .002274 002604 .02205010223714
Lines 252 to 255 of the do file also compare the lense given by the max r2 method and the 1st heuristic method. The results are below. Note that the second spec shows the 1st heuristic for all city-years and the third spec shows it for the city-years that have a max R2 layer, to make a fairer comparison.
variable | p50 mean sd N min max p10 p90
-------------+--------------------------------------------------------------------------------
nohull | 2 4.519621 352647 8.1655 107042 3797 0 109 108 1 9 tothullcount | 11 9 2220.48512 60706 40.38281 26376 3797 0 572 566 6 4 4442 tothullarea | 4218.05454 31188252 110.2049 757 1020348.574 9474 3797 0 143436079.08 538 41.035411 523386 677236.41762767 tothullden~y | .3111306 5860988 46.461828 013232 2843.35013 74094 3797 0 8131429.2376 742 .0116532 0277004 57.873065329074
growthinv18 | 31.8453 133.0608 508.1196 3797 0 22282.6 1.235763 292.4397
numdeals | 2 6.629181 16.46614 3797 0 275 0 15
variable | p50 mean sd N min max p10 p90
-------------+--------------------------------------------------------------------------------
nohull | 2 4.753304 581159 8.607258 548611 2951 0 109 108 1 9 tothullcount | 11 9 2321.58353 68519 42.91556 78684 2951 0 572 566 6 4 4342 tothullarea | 4319.43438 43593 318114.6861 4633 1075360.779 3934 2951 0 143436079.08 4538 1.259536 86059 664252.985267 tothullden~y | .3187791 5797117 56.188776 835335 3149.84423 19501 2951 0 8131429.2376 742 .0138936 60314084 7.80843848711
growthinv18 | 33.16967 141.5326 563.4799 2951 0 22282.6 1.412436 298.6927
numdeals | 3 6.630973 17.17611 2951 0 275 0 14
