Difference between revisions of "Hubs Analysis 2017"
Jump to navigation
Jump to search
(Created page with "{{McNair Projects |Has title=Hubs |Has owner=Hira Farooqi, |Has keywords=Data Analysis |Has project status=Active }}") |
|||
(11 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | {{McNair | + | {{Project |
− | |Has title=Hubs | + | |Has project output=Data |
− | |Has owner=Hira Farooqi | + | |Has sponsor=McNair Center |
+ | |Has title=Hubs Analysis 2017 | ||
+ | |Has owner=Hira Farooqi | ||
|Has keywords=Data Analysis | |Has keywords=Data Analysis | ||
− | |Has project status= | + | |Has project status=Subsume |
}} | }} | ||
+ | ==Analysis Stage 1 == | ||
+ | |||
+ | The results are based on preliminary data analysis. The do-file that performs some analysis is located here: | ||
+ | Z:\Hubs\2017\hubs_data | ||
+ | |||
+ | It is titled '''load_vc_hubs_data.do'''. | ||
+ | |||
+ | The sample of hubs used at this stage is the 29-30 hubs that were shortlisted in summer 2016. After data cleaning we get a sample of ~ 25 hubs. Important observations from initial fixed effects regressions are: | ||
+ | |||
+ | * The sign of correlation between vc funding and the presence of hubs is very sensitive to the measure of vc funding. It is positive for early investment and negative for later investments. | ||
+ | *The size and significance of the correlation is sensitive to number of deals vs the amount of funding. Results are more significant for number of deals compared to the results for value of the deals. | ||
+ | *Including SBIR data significantly reduces the number of groups in the panel and hence the sample size. | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | ==Analysis Stage2 == | ||
+ | All the final data files related to Hubs analysis are located here: | ||
+ | Z:\Hubs\2017\hubs_data | ||
+ | |||
+ | *The stata do file '''hubs_load_data.do''' uploads the final hubs data file. This is the raw data that includes variables early funding, late funding, number of early funding deals, number of late funding deals, dummies for whether a hub is present etc. The do file processes data, creates more variables. It also estimates the hazard rate model, and matches the sample based on estimated hazard ratios. It eliminates all city_states that were never matched with a neighbor in ANY year from 2000-2017. The output from this file is '''matched_hubs.dta'''. | ||
+ | |||
+ | *We need a panel data with controls and treatments, such that for each matched control-treatment pair, with pairid = n, in '''matched_hubs.dta''' we assign the same pairid = n to observations of city_states 2 periods before and after they were assigned control and treatment status originally. The matlab code in '''time_matching_hubs.m''' performs this. However the resulting panel has problems of overlap. For instance if chicago_2008 was treatment and boulder_2014 was control with pair id 200 in the original hazard rate match, chicago_2009 is a control in some pair 203 and this observation gets matched with our pair id 200. Need to resolve this. | ||
+ | |||
+ | *The stata do file '''hubs_load_clean.do''' uploads this final panel data set - but this panel has the problem of overlaps discussed above. | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | [[category:Internal]] |
Latest revision as of 13:41, 21 September 2020
Hubs Analysis 2017 | |
---|---|
Project Information | |
Has title | Hubs Analysis 2017 |
Has owner | Hira Farooqi |
Has start date | |
Has deadline date | |
Has keywords | Data Analysis |
Has project status | Subsume |
Subsumed by: | Hubs |
Has sponsor | McNair Center |
Has project output | Data |
Copyright © 2019 edegan.com. All Rights Reserved. |
Analysis Stage 1
The results are based on preliminary data analysis. The do-file that performs some analysis is located here:
Z:\Hubs\2017\hubs_data
It is titled load_vc_hubs_data.do.
The sample of hubs used at this stage is the 29-30 hubs that were shortlisted in summer 2016. After data cleaning we get a sample of ~ 25 hubs. Important observations from initial fixed effects regressions are:
- The sign of correlation between vc funding and the presence of hubs is very sensitive to the measure of vc funding. It is positive for early investment and negative for later investments.
- The size and significance of the correlation is sensitive to number of deals vs the amount of funding. Results are more significant for number of deals compared to the results for value of the deals.
- Including SBIR data significantly reduces the number of groups in the panel and hence the sample size.
Analysis Stage2
All the final data files related to Hubs analysis are located here:
Z:\Hubs\2017\hubs_data
- The stata do file hubs_load_data.do uploads the final hubs data file. This is the raw data that includes variables early funding, late funding, number of early funding deals, number of late funding deals, dummies for whether a hub is present etc. The do file processes data, creates more variables. It also estimates the hazard rate model, and matches the sample based on estimated hazard ratios. It eliminates all city_states that were never matched with a neighbor in ANY year from 2000-2017. The output from this file is matched_hubs.dta.
- We need a panel data with controls and treatments, such that for each matched control-treatment pair, with pairid = n, in matched_hubs.dta we assign the same pairid = n to observations of city_states 2 periods before and after they were assigned control and treatment status originally. The matlab code in time_matching_hubs.m performs this. However the resulting panel has problems of overlap. For instance if chicago_2008 was treatment and boulder_2014 was control with pair id 200 in the original hazard rate match, chicago_2009 is a control in some pair 203 and this observation gets matched with our pair id 200. Need to resolve this.
- The stata do file hubs_load_clean.do uploads this final panel data set - but this panel has the problem of overlaps discussed above.