Hubs Analysis 2017 - Revision history

Ed at 17:41, 21 September 2020

2020-09-21T17:41:43Z

Ed at 17:34, 21 September 2020

2020-09-21T17:34:18Z

Ed at 17:20, 20 September 2020

2020-09-20T17:20:03Z

Ed at 17:12, 20 September 2020

2020-09-20T17:12:16Z

Ed at 19:20, 26 October 2017

2017-10-26T19:20:59Z

Ed at 19:19, 26 October 2017

2017-10-26T19:19:16Z

HiraF: /* Analysis Stage2 */

2017-08-04T19:57:33Z

Analysis Stage2

HiraF: /* Analysis Stage 1 */

2017-08-04T19:47:38Z

Analysis Stage 1

HiraF at 21:56, 20 July 2017

2017-07-20T21:56:38Z

HiraF: /* Analysis Stage 1 */

2017-07-20T21:54:40Z

Analysis Stage 1

@@ Line 1: / Line 1: @@
 {{Project
-|Has project output=
+|Has project output=Data
 |Has sponsor=McNair Center
 |Has title=Hubs Analysis 2017

@@ Line 1: / Line 1: @@
 {{Project
 |Has sponsor=McNair Center
 |Has title=Hubs Analysis 2017

@@ Line 1: / Line 1: @@
 {{Project
 |Has title=Hubs Analysis 2017
 |Has owner=Hira Farooqi

@@ Line 1: / Line 1: @@
-{{McNair Projects
+{{Project
 |Has title=Hubs Analysis 2017
 |Has owner=Hira Farooqi

@@ Line 1: / Line 1: @@
 {{McNair Projects
 |Has title=Hubs Analysis 2017
-|Has owner=Hira Farooqi,
+|Has owner=Hira Farooqi
 |Has keywords=Data Analysis
 |Has project status=Subsume

← Older revision		Revision as of 19:57, 4 August 2017
Line 29:		Line 29:
	*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'''.		*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.	+	*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.

← Older revision		Revision as of 19:47, 4 August 2017
Line 17:		Line 17:
	*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.		*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.		*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.
		+
		+

← Older revision		Revision as of 21:56, 20 July 2017
Line 17:		Line 17:
	*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.		*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.		*Including SBIR data significantly reduces the number of groups in the panel and hence the sample size.
		+
		+
		+
		+
		+	[[category:Internal]]

← Older revision		Revision as of 21:54, 20 July 2017
Line 16:		Line 16:
	* 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 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.		*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.