7,612
edits
Changes
Jump to navigation
Jump to search
|Is billed to=AccMcNair01|Has notes=|Is dependent on=|Depends upon itproject status=Tabled
=Spring 2017=
[[Category: Internal]]
[[Internal Classification: Issue Brief| ]]
Women in Entrepreneurship (Issue Brief) (view source)
Revision as of 13:40, 21 September 2020
, 13:40, 21 September 2020no edit summary
{{Project|Has project output=Content|Has sponsor=McNair ProjectsCenter
|Has title=Women in Entrepreneurship (Issue Brief)
|Has owner=Carlin Cherry
|Has start date=Spring 2016
|Has keywords=Women, Entrepreneurship
}}
=Timeline and plan for summer=
*note: I am using "hopethisworks8.txt" to make my graphs
*4-5 artifacts, 4-5 specifications, last artifact a regression table (tables, charts)
**something about data itself. pie chart (how many companies do we have, how many do we have ceo information for, how many do we have founder) and then relatedly many can we classify as men or women
***this will influence all remaining graphs - use this info to guide the rest of your graphs
***classified drs using their first name matched to common first name list, that's why we were able to classify some drs as women, some as men, and some drs but gender unknown
**graph with time on x axis, % on y axis, women founders, women ceos, women management positions (management position being anything that is vp and above) over time
***will write up these results-ie most of the women in "womens management positions"
**conditional on having (ceo identified) how many women, how many men, drs, dr men, dr women, dr unknown.
**bar graph with women in various industries, y axis will have percentage
***should also make note of total percentage of VC dollars in each industry
**regression table
***variable names, with n and r^2, industry/year fixed effects Y/N
***each one of these will correspond to a regression
***variables: IPO, acquisition, exit all correspond to 0,1
***rounds, dollars invested
=Spring 2017===Current plan to complete project==#Lit Review (which will be compiled here [[Women in Entrepreneurship Lit Review]]). Keep track of the things that have already been done in other research reports, so that we can do something different/original or so we can prove their data wrong. Done 3/28.#Brainstorm ways to fix Dr. problem in data (assigning gender to those who are doctors), recode them. reran new tables with new coded doctors. done 4/4.#Think of new variables to add depending on the guidance from the lit review (might include adding different variables than solely womenceo/womenfounder but will depend on litreview). ##add control variable for the people in data who have no gender#I think from there I can do analysis and start to write report! ==For analysis== Note that:*finaldatasetcode.sql (in 181/Women) has been updated*hopethisworks5.txt (in both 181/Women and E/Women) has been created**Use this as your dataset now**It contains IPO, IPOyear, IPOAmount, MA, MAyear, MAAmount, and Exit**IPO, MA, and Exit are 0/1 variables. Year is an int, and Amount is a real.**Many MAs will not have amounts. Build graphs of:*Over time (last ten yrs)**percent of co's with woman ceo (binary)**percent of co's with woman founder (binary)**percent of co's with woman clevel (binary)**percent of co's with women in top management (vp and above)**average fraction of women founders**average fraction of women clevel**average fraction of women in top management (vp and above)*Some of the above by industry*Some of the above by state Regresions:*rounds womanvar w/controls*inv womanvar w/controls*exit womanvar w/controls*ipo womanvar w/controls*ma womanvar w/controls*ipoamount womanvar w/controls*maamount womanvar w/controls ==Call with SDC Platinum to determine information about the data==#How does Thompson get their data?##Why is coverage better for some firms than others?##Is the data self-reported by the companies?#How does Thompson upload executive data?##How often – after last round of funding?##After it’s uploaded, is the data updated continuously?#Better coverage for companies that get more rounds of financing/IPO/M&A? #VC data sourced from government filings, public press releases, and quarterly surveys of private equity firms. If company does not participate in survey, then SDC does not have the data, which is why coverage for some firms is better than others. #Deals team is the one that uploads all the data. As soon as SDC gets an update, or has a source that is updated, they automatically upload that to system as well. It typically takes 24-48 hours for new info to be reflected in database. #Yes, there is better coverage for companies that have IPO/M&A/get more rounds of financing.
==TO DO after 2/28==
#Check cleancos and verify that it is actually clean(yes)#Make Dr. a control variable(yes)
#Sum all c-level, etc.
#aggregate to company level
We need to build:
*IPO 1/0
*M&A 1/0
*Number of rounds
*Total invested
*Is the CEO a woman 1/0
*Are any of the founders women 1/0
*Is CEO doctor 1/0
*Number of founders
*Number of founders that are doctors
*Number of women founders
*State - coded
*Industry -code them!
*Year of First investment -extracted
Ed is going to add IPO and Acq to rc1andcp3
Here's the code to add zeros to cleanpeople:
DROP TABLE cleanpeople2;
CREATE TABLE cleanpeople2 AS
SELECT
prefix,
firstname,
lastname,
jobtitle,
fulltitle,
cname,
CASE WHEN genval IS NOT NULL THEN genval ELSE 0::int END AS women,
CASE WHEN doctor IS NOT NULL THEN doctor ELSE 0::int END AS doctor,
CASE WHEN charman IS NOT NULL THEN charman ELSE 0::int END AS charman,
CASE WHEN ceo IS NOT NULL THEN ceo ELSE 0::int END AS ceo,
CASE WHEN cfo IS NOT NULL THEN cfo ELSE 0::int END AS cfo,
CASE WHEN coo IS NOT NULL THEN coo ELSE 0::int END AS coo,
CASE WHEN cio IS NOT NULL THEN cio ELSE 0::int END AS cio,
CASE WHEN cto IS NOT NULL THEN cto ELSE 0::int END AS cto,
CASE WHEN otherclvl IS NOT NULL THEN otherclvl ELSE 0::int END AS otherclvl,
CASE WHEN boardmember IS NOT NULL THEN boardmember ELSE 0::int END AS boardmember,
CASE WHEN president IS NOT NULL THEN president ELSE 0::int END AS president,
CASE WHEN vp IS NOT NULL THEN vp ELSE 0::int END AS vp,
CASE WHEN founder IS NOT NULL THEN founder ELSE 0::int END AS founder,
CASE WHEN director IS NOT NULL THEN director ELSE 0::int END AS director
FROM cleanpeople WHERE jobtitle IS NOT NULL;
==TO DO up to 2/28==
[[Category: McNair Projects]]
</includeonly><!-- flush --><!-- flush --><!-- flush -->
