Changes
Jump to navigation
Jump to search
Year CEOs Founders Start-ups Partners FundExecsDROP TABLE PercentWomenCEOsCompany; -------------------------------------------------------------CREATE TABLE PercentWomenCEOsCompany AS 1980 2% 2% 4% SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE ceo = 1% 2%; 1981 ..--.22597
*Table on money raised?DROP TABLE PercentWomenChairmanCompany;*Data on likelihood of follow-on round ==still to do:==CREATE TABLE PercentWomenChairmanCompany AS#this data still discounts a SELECT sum(smallmf) percentage of data /count(doctors who didn't have a common namemf)FROM ManWomanCompany3 WHERE chairman = 1;#have data organized, now we need to figure out how to extract it in meaningful terms for the report--.142417
<onlyinclude>Over the past century, the United States has witnessed two large-scale social trends involving [[Women in Entrepreneurship|women in entrepreneurship]] that have had a significant impact on the country's economic growth. DROP TABLE PercentWomenCIOCompany;CREATE TABLE PercentWomenCIOCompany AS*First, huge numbers of women have made their way into the official labor force. Around this time 50 years ago SELECT sum(February 1966mf), women's labor force participation rate was 39.6%, but in February 2016, 56.8% of women participated in the labor force [https://research.stlouisfed.org/fred2/series/LNS11300002]. This demonstrates substantial growth in women's entry to the labor forcecount(mf) FROM ManWomanCompany3 WHERE cio = 1;--. 31707
*Second, women are achieving a higher degree of education than in years past. As labor market barriers to women have been lowered, the benefits of a college education grew more for women than men, and females outpace males in college enrollment. [http://www.pewresearch.org/fact-tank/2014/03/06DROP TABLE PercentWomenCTOCompany;CREATE TABLE PercentWomenCTOCompany ASSELECT sum(mf)/womens-college-enrollment-gains-leavecount(mf) FROM ManWomanCompany3 WHERE cto = 1;-men-behind/] This has provided women with access to the same jobs as men.12588
However, these trends have slowed from their early twenty-first century spikesDROP TABLE PercentWomenboardmemberCompany;CREATE TABLE PercentWomenboardmemberCompany ASSELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE boardmember = 1; room for growth is smaller now than it was before. Economists predict that economic growth from these two trends is unlikely to be repeated to the same magnitude. With this, everyone is looking for the modern-day economy-boosting equivalent to women entering the labor force and achieving higher education. Given the slowing rates of business creation, the long-term pessimism about growth in the United States, and the rising share of women among educated workers, it seems clear that the future of American economic growth is in the hands of women. Encouraging women to enter into fields of entrepreneurship, particularly high-growth entrepreneurship, might be the United States' silver bullet.</onlyinclude>2545
This issue brief aims to examine the role of women in entrepreneurship today by examining their jobs DROP TABLE PercentWomenVPCompany;CREATE TABLE PercentWomenVPCompany ASSELECT sum(or lack thereofmf) in entrepreneurship and examine the effectiveness of current policy related to women in entrepreneurship/count(mf) FROM ManWomanCompany3 WHERE vicepresident = 1;--.3468
Overall, women-owned businesses account for slightly less than 1/3 of all businesses in the United States. At first glance the statistics portray a positive picture for the field's growth: the number of women-owned firms has grown 68 percent since 2007DROP TABLE womenstates;CREATE TABLE womenstates ASSELECT companystate, compared to only 47 percent for all businesses. [http://www.theatlantic.com/business/archive/2015/04/women-are-owning-more-and-more-small-businessessum(mf)/390642/]. However, these women owned businesses are typically only run by the woman herselfcount(mf) FROM ManWomanCompany3 GROUP BY companystate; among employer firms, women-owned businesses account for only 16% of the total, and their shares of revenue and employees are in the single digits. [http://www.kauffman.org/~/media/kauffman_org/research%20reports%20and%20covers/2014/11/sources_of_economic_hope_womens_entrepreneurship.pdf]
The few women in entrepreneurial leadership roles also have to deal with negative societal perceptions of their jobs. According to data from a 2015 Pew Research Center survey, 43% of Americans believe that the U.S. is not prepared to hire women for top-tier executive positions. A relatively smaller, but still significant, number of Americans (23%) believe that women don’t have the time to hold an executive position, given their “family responsibilities”. [http://www.citylab.com/work/2015/09/where-can-female-entrepreneurs-find-the-most-success/406987/]
The American public's generally negative perception of women in entrepreneurship presents itself institutionally as well. Even though female founders perform equal to or better than their male counterparts when raising money online, only 10 percent of startups which raised Series A last year had female founders. [http://www.inc.com/lisa-calhoun/30-surprising-facts-about-female-founders.html] Texas claims the worst record of supporting women seeking venture capital. Last year, 42 Texas startups got Series A rounds, yet not a single startup had female founders. In terms of venture capital structure, ninety-four percent of decision makers at venture capital funds are male, and 90% of today's venture capital funds never see a female founder. Among chief executives of S.&P. 1500 firms, for each woman, there are four men named John, Robert, William or James. [http://www.nytimes.com/2015/03/03/upshot/fewer-women-run-big-companies-than-men-named-john.html?_r=2] But venture capital firms with women partners are more than twice as likely to invest in companies with a woman on the executive team and three times as likely to invest in companies with women CEOs.
Though at first glance women-owned business growth seems striking, the numbers are deceptive in that their shares of revenue and employees are in single digits. Furthermore, women who do go into entrepreneurship face societal disapproval of their actions, with a plurality of Americans believing not only that the country is not prepared to hire women to executive positions, but also that women are incapable of holding these positions due to their family responsibilities. Further, women get start-up capital for their companies 2-3 times as often from women-led VC funds, but only 6% of decision makers at VC funds are women. It's no wonder women are vastly underrepresented in this field.==Example output data==
==What women need== Year CEOs Founders Start-ups Partners FundExecs ------------------------------------------------------------- 1980 2% 2% 4% 1% 2% 1981 ...
Almost half-of female founders (48 percent) cite a lack of available mentors or advisers as holding them back. A third say lack *Table on money raised?*Data on likelihood of capital is a constraint. [http://www.inc.com/lisafollow-calhoun/30-surprising-facts-about-female-founders.html]on round ==Relevant policystill to do:== The Obama administration recognized the importance of expanding the role that women-owned businesses play in the national economy. Some of his initiatives include increasing access to capital, incentivizing #this data still discounts a (small business growth and hiring, encouraging women owned business competition for government contracts, and enhancing long term survival ) percentage of women owned businesses. Two primary pieces of legislation data (doctors who didn't have bolstered the limited growth that the United States has seen in the field of women entrepreneurs, The Small Business Jobs Act of 2010 and the Women’s Equity in Contracting Act. Both of these seek to help businesses headed up by women win more government contracts. a common name) The president has worked on increasing small business access to capital through the Recovery Act and the Small Business Jobs Act. Through this act#have data organized, the president has reformed SBA lending practices and built on existing infrastructure. SBA loans are 3-5x more likely to go to women and minorities than traditional business loans. Over 12,000 SBA Recovery loans have gone now we need to women-owned small businesses, totaling more than $3 billion. [http://www.dol.gov/wb/media/Obama%20Administration's%20Support%20for%20Women%20Entrepreneurs%20%282%29.pdf] The president has also increased tax cuts with the aim of helping small businesses invest in their firms and create jobs. Specific figure out how to women, the SBA opened several new Women's Business Centers extract it in 2009 and 2010, bringing their total to 114. Jessica Milli, senior research associate at the Institute of Women’s Policy Research, said things like the Jobs Act and SBA's programs meaningful terms for women "really aim to put women-owned businesses...at a competitive advantage. (They) restrict competition, which has really helped to boost revenues and help more businesses get into the industry.” But such policies can’t, and haven't, solved all the challenges inherent to being a female entrepreneur. Even with targeted legislation, women business owners still face a significant wage gap and continually have smaller amounts of start-up capital than their male peersreport.
→Our research
[[Women in Entrepreneurship Lit Review]]
=The Paper=
==Introduction==
Over the past century, the United States has witnessed two large-scale social trends involving [[Women in Entrepreneurship|women in entrepreneurship]] that have had a significant impact on the country's economic growth. First, huge numbers of women have made their way into the official labor force. Around this time 50 years ago (February 1966), women's labor force participation rate was 39.6%, but in February 2016, 56.8% of women participated in the labor force [https://research.stlouisfed.org/fred2/series/LNS11300002]. This demonstrates substantial growth in women's entry to the labor force. Second, women are achieving a higher degree of education than in years past. As labor market barriers to women have been lowered, the benefits of a college education have grown more for women than men, and females now outpace males in college enrollment. [http://www.pewresearch.org/fact-tank/2014/03/06/womens-college-enrollment-gains-leave-men-behind/] This has provided women with similar access to the same jobs as men.
However, these trends have slowed from their early twenty-first century spikes; room for growth is smaller now than it was before. Economists predict that economic growth from these two trends is unlikely to be repeated to the same magnitude. With this, everyone is looking for the modern-day economy-boosting equivalent to women's entry to the labor force. Given the rising share of women among educated workers, it seems clear that the future of American economic growth is in the hands of women. Encouraging women to enter into fields of entrepreneurship, particularly high-growth entrepreneurship, might be the United States' silver bullet.
This issue brief aims to examine the role of women in entrepreneurship today by examining their jobs (or lack thereof) in entrepreneurship related fields, and examine the effectiveness of current policy related to women in entrepreneurship.
==Status Quo==
===Our research===
We examined all leaders in companies from 1980-2016 who have the titles of either chariman, CEO, CFO, COO, CIO, CTO, board member, President, Vice President, Founder, and Director. Of company members with those titles, only 29.8% were women. Of those women leaders, 22% were CEOs, 14% chairwomen, 27% CFOs, 26% COOs, 31% CIOs, 12% CTOs, 25% board members, 20% presidents, 34% vice presidents, 23% founders, and 39% directors. (from tables, PercentWomenXCompany, where X is job title)
Generally, the percentage of women in "leadership roles" in companies has trended upwards since 1980. (from companywomentot table) However, the number of women CEOs over the past two decades has not dramatically increased or decreased, aside from a dramatic upward spike in women CEOs during 2015. (from PercentWomenCEOCompanybyyear table)
Grouped by state, Michigan has highest percentage of women in leadership in its companies, coming in at 37.5%. Texas has 26.6%. Wyoming has a whopping 0%. (from womenstates)
These data show that of the women listed as "Company Executives", only a very small percentage have positions of power. However, this number has grown since 1980, which demonstrates a slow but positive growth of women in executive positions in general.
===Info from external sources===
Overall, women-owned businesses account for slightly less than 1/3 of all businesses in the United States. At first glance the statistics portray a positive picture for the field's growth: the number of women-owned firms has grown 68 percent since 2007, compared to only 47 percent for all businesses. [http://www.theatlantic.com/business/archive/2015/04/women-are-owning-more-and-more-small-businesses/390642/]. However, these women owned businesses are typically only run by the woman herself; among employer firms, women-owned businesses account for only 16% of the total, and their shares of revenue and employees are in the single digits. [http://www.kauffman.org/~/media/kauffman_org/research%20reports%20and%20covers/2014/11/sources_of_economic_hope_womens_entrepreneurship.pdf]
The few women in entrepreneurial leadership roles also have to deal with negative societal perceptions of their jobs. According to data from a 2015 Pew Research Center survey, 43% of Americans believe that the U.S. is not prepared to hire women for top-tier executive positions. A relatively smaller, but still significant, number of Americans (23%) believe that women don’t have the time to hold an executive position, given their “family responsibilities”. [http://www.citylab.com/work/2015/09/where-can-female-entrepreneurs-find-the-most-success/406987/]
The American public's generally negative perception of women in entrepreneurship presents itself institutionally as well. Even though female founders perform equal to or better than their male counterparts when raising money online, only 10 percent of startups which raised Series A last year had female founders. [http://www.inc.com/lisa-calhoun/30-surprising-facts-about-female-founders.html] Texas claims the worst record of supporting women seeking venture capital. Last year, 42 Texas startups got Series A rounds, yet not a single startup had female founders. In terms of venture capital structure, ninety-four percent of decision makers at venture capital funds are male, and 90% of today's venture capital funds never see a female founder. Among chief executives of S.&P. 1500 firms, for each woman, there are four men named John, Robert, William or James. [http://www.nytimes.com/2015/03/03/upshot/fewer-women-run-big-companies-than-men-named-john.html?_r=2] But venture capital firms with women partners are more than twice as likely to invest in companies with a woman on the executive team and three times as likely to invest in companies with women CEOs.
Though at first glance women-owned business growth seems striking, the numbers are deceptive in that their shares of revenue and employees are in single digits. Furthermore, women who do go into entrepreneurship face societal disapproval of their actions, with a plurality of Americans believing not only that the country is not prepared to hire women to executive positions, but also that women are incapable of holding these positions due to their family responsibilities. Further, women get start-up capital for their companies 2-3 times as often from women-led VC funds, but only 6% of decision makers at VC funds are women. It's no wonder women are vastly underrepresented in this field.
==What women need==
Almost half-of female founders (48 percent) cite a lack of available mentors or advisers as holding them back. A third say lack of capital is a constraint. [http://www.inc.com/lisa-calhoun/30-surprising-facts-about-female-founders.html]
==Relevant policy==
The Obama administration recognized the importance of expanding the role that women-owned businesses play in the national economy. Some of his initiatives include increasing access to capital, incentivizing small business growth and hiring, encouraging women owned business competition for government contracts, and enhancing long term survival of women owned businesses. Two primary pieces of legislation have bolstered the limited growth that the United States has seen in the field of women entrepreneurs, The Small Business Jobs Act of 2010 and the Women’s Equity in Contracting Act. Both of these seek to help businesses headed up by women win more government contracts.
The president has worked on increasing small business access to capital through the Recovery Act and the Small Business Jobs Act. Through this act, the president has reformed SBA lending practices and built on existing infrastructure. SBA loans are 3-5x more likely to go to women and minorities than traditional business loans. Over 12,000 SBA Recovery loans have gone to women-owned small businesses, totaling more than $3 billion. [http://www.dol.gov/wb/media/Obama%20Administration's%20Support%20for%20Women%20Entrepreneurs%20%282%29.pdf] The president has also increased tax cuts with the aim of helping small businesses invest in their firms and create jobs. Specific to women, the SBA opened several new Women's Business Centers in 2009 and 2010, bringing their total to 114.
Jessica Milli, senior research associate at the Institute of Women’s Policy Research, said things like the Jobs Act and SBA's programs for women "really aim to put women-owned businesses...at a competitive advantage. (They) restrict competition, which has really helped to boost revenues and help more businesses get into the industry.” But such policies can’t, and haven't, solved all the challenges inherent to being a female entrepreneur. Even with targeted legislation, women business owners still face a significant wage gap and continually have smaller amounts of start-up capital than their male peers.
==Conclusion==
As women's prevalence in the United States workforce has increased, the United States has experienced an economic boom. However, women's numbers are still small in entrepreneurial fields, and even more microscopic in leadership positions in those fields. Current policy fails because it doesn't properly address women's lack of access to capital and mentorship. Moving forward, the United States must seek strategies to incentivize more women to enter the entrepreneurial workforce.
=The Research=
LEFT JOIN titles01 ON manwomancompany2.jobtitle=titles01.title;
==Example output datatables for percent of women in a given job title==DROP TABLE PercentWomenCompany;CREATE TABLE PercentWomenCompany ASSELECT sum(mf)/count(mf) FROM ManWomanCompany3;--.29812
DROP TABLE PercentWomenCFOCompany;
CREATE TABLE PercentWomenCFOCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE cfo = 1;
--.27087
DROP TABLE PercentWomenCOOCompany;CREATE TABLE PercentWomenCOOCompany ASSELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE coo =The Paper=1;==Introduction==--.26353
DROP TABLE PercentWomenPresidentCompany;
CREATE TABLE PercentWomenPresidentCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE president = 1;
--.19646
DROP TABLE PercentWomenfounderCompany;CREATE TABLE PercentWomenfounderCompany ASSELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE founder ==Status Quo==1;--.2394
DROP TABLE PercentWomendirectorCompany;
CREATE TABLE PercentWomendirectorCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE director = 1;
--.38625
==table for finding percentage of women in companies by state==
