Foxtail Research

Market research Indiana Mid West
Analysis of Small businesses data reveals states with promising economic growth potential

We are in an era of slow economic growth, roughly at the rate of 0.8% per annum. I had mentioned in one of my earlier blogs that Disruption and Innovation are paramount to propel growth and to generate opportunities for ourselves and for our next generation. I analyzed Venture Capital deals data to uncover regions which are showing promising Entrepreneurship ecosystems. While startups are blossoming and growing into bigger size businesses with Venture Capital funding, there is this other side of the business ecosystem where the Main Street is ensuring sustainability and growth in the economy through the small business ecosystem. Here in this blog, I share my analysis on the small businesses (Main Street) business ecosystem across the nation.

Small businesses account for half of US GDP. They employ half of US employees. Small business owners take the initiative and invest their time and money to provide services for the community and nearby areas. Almost 80% of the small businesses operate without hiring employees (self-employed). Gig-economy has provided opportunities to be self-employed and is preferred by flexibility-loving people who can put their skills to work for companies as contractors or freelancers on a pay-per-hour basis. As small businesses grow from no employees to 5 to 10 to 50 to100 and further, they become a major source of employment. Thus Small businesses are an indicator of future growth. In this article, I analyze small businesses with no employees and small businesses with less than 20 employees.


In one of my previous blogs (https://www.foxtail-research.org/analysis-of-venture-capital-deals-data-reveals-new-regions-with-promising-innovation-potential-apart-from-california-massachusetts-new-york/), I developed a metric “per-capita entrepreneurship” to measure and analyze the current entrepreneurship and investment scenario across all the states in the nation and how this metric can be used for analysis and comparisons. In a similar line of thinking, I analyze the Main Street ecosystem with Small business data with businesses having no employees and less than 20 employees. As with venture capital data, I rank the states on a per-capita basis to identify states with growth potential.

Methodology

I collected data on three sets of information:

  • Small business establishments data from US census website1. I collected information for the years 2012 to 2022. The latest available dataset is for the year 2022. The dataset has information on the number of firms, establishments, payroll, receipts (for years ending in 2 and 7) by state, establishment size and NAICS (North American Industry Classification System) for each of the years. I filtered data to get information on establishments with less than 20 employees for all the NAICS.
  • Small business establishments with no employees data from US census website2. I collected information for the years 2012 to 2023. The latest available dataset is for the year 2023. The dataset has information on the number of establishments and receipts in 1000s of dollars by state, and NAICS (North American Industry Classification System) for each of the years. I collected the dataset for all the NAICS.
  • The 18-65 age population in each state. This is the population that will be actively engaged in higher education or will be in the workforce. I arrived at this information based on data available on the US Census data website3. The US Census bureau website had datasets of civilian population estimates for each age for each calendar year. I processed the datasets to get the population estimates for 18-65 population for the years 2012 to 2023.

From datasets in 1 and 3, I arrived at the number of firms and number of employees (with less than 20 employees size) for every 100 persons in the working age population of 18-65.  I summed up the number of firms or employees for all years from 2012 to 2022. I summed up all the populations from 2012 to 2022. Dividing the former over the latter gave the number of firms or employees for every 100 persons in the working age population. . The higher the number the more firms and employees are in small businesses in that state.

From datasets in 2 and 3, I arrived at the number of firms (for businesses with no employees) for every 100 persons in the working age population of 18-65 and at self-employed earnings (PCSE) .  PCSE is the amount of receipts earned in 1000s for every person in the working age population in that state. I summed up the number of firms or receipts for all years from 2012 to 2023. I summed up all the populations from 2012 to 2023. Dividing the former over the latter gave the number of firms for every 100 persons in the working age population and the per-capita self-employed earnings (PCSE).  The higher the number the more firms and employees are in small businesses in that state. The higher the PCSE, the higher is the state earning from firms with no employees.

Results, Analysis and Discussion

For Establishments with less than 20 employees

Below (Table 1) is the table of states with the average number of firms for every 100 people in the working age population. The rank is provided alongside in a separate column. From this table, Montana has on average 4.6 firms (with less than 20 employees) for every 100 persons in the working age population and is the state in the country which has the highest number of firms in this category and is ranked 1 the nation. Without this level of analyzing the data, the states of California, New York, Florida, Texas always come as the top 4 states with the highest number of small business firms due to their high populations.

Table 1: States along with average number of firms with less than 20 employees for the working age population

StateAverage Number of <20 employee size firms (for every 100 persons in the working age 18-65 population)Rank
Montana4.61
Wyoming4.52
Vermont3.83
South Dakota3.64
North Dakota3.65
Maine3.56
Colorado3.47
Idaho3.48
New York3.39
Florida3.310
Alaska3.311
Nebraska3.212
Oregon3.213
Utah3.114
New Jersey3.015
Rhode Island3.016
New Hampshire2.917
Minnesota2.918
Washington2.919
Delaware2.920
District of Columbia2.821
Iowa2.822
Massachusetts2.823
Kansas2.824
Illinois2.825
California2.726
Missouri2.727
Connecticut2.628
Oklahoma2.629
Hawaii2.530
Wisconsin2.531
Virginia2.532
Pennsylvania2.533
Maryland2.434
North Carolina2.435
Georgia2.436
Michigan2.437
Nevada2.438
Louisiana2.439
Arkansas2.440
South Carolina2.341
New Mexico2.342
Arizona2.243
Indiana2.244
Texas2.245
Ohio2.146
Mississippi2.147
Kentucky2.148
Alabama2.149
West Virginia2.050
Tennessee2.051

The state of Indiana ranks 44th with an average of 2.2 firms (with less than 20 employees) for every 100 persons in the working age population.

Below (Table 2) is the table of states with the average number of employees working in firms with less than 20 employees for every 100 people in the working age population. The rank is provided alongside in a separate column. From this table we can infer that in Wyoming, out of every 100 persons  in the working age population, an average of 16.8 persons (17 persons) are employed in firms which employ less than 20 people. It is the state which has the maximum number of people employed in firms in this category and is ranked number 1. 

Table 2:  States along with average number of people in working age population employed in firms with less than 20 employees

StateAverage Number of <20 employee size small business employees (for every 100 people in the population)Rank
Wyoming16.81
Montana16.72
Vermont15.23
North Dakota14.74
South Dakota14.65
Maine13.26
Oregon12.87
Idaho12.78
Alaska12.69
New Hampshire12.510
Nebraska12.511
District of Columbia12.312
Colorado12.013
Rhode Island11.914
New York11.915
New Jersey11.716
Kansas11.417
Iowa11.418
Washington11.319
Minnesota11.320
Delaware11.221
Massachusetts11.222
Utah11.223
Connecticut11.124
Wisconsin10.925
Florida10.926
Hawaii10.627
California10.528
Pennsylvania10.529
Oklahoma10.430
Missouri10.431
Louisiana10.332
Illinois10.233
Virginia10.134
Michigan10.035
Maryland9.936
Arkansas9.737
North Carolina9.638
Ohio9.639
Indiana9.540
New Mexico9.541
South Carolina9.542
Nevada9.243
Texas9.044
Alabama9.045
Georgia9.046
Mississippi8.947
West Virginia8.848
Kentucky8.849
Tennessee8.750
Arizona8.451

Indiana ranks 40th with average of 9.5 persons for every 100 persons in the working age population employed in firms with less than 20 employees

For Establishments with no employees

Below (Table 3) is the table of states with the average number of firms with no employees for every 100 people in the working age population. The rank is provided alongside in a separate column. From this table, Florida has on average 18.5 firms (with no employees) for every 100 persons in the working age population and is the state in the country which has the highest number of firms in this category and is ranked 1 the nation.

Table 3: States along with number of firms with no employees for the working age population

StateAverage Number of no-employee firms (for every 100 persons in the working age 18-65 population)Rank
Florida18.51
Vermont15.32
Wyoming14.93
Georgia14.74
Montana14.55
Colorado14.56
Texas14.17
New York14.08
Maine13.99
Maryland13.410
Louisiana13.311
California13.312
Hawaii13.113
South Dakota12.914
Utah12.915
Idaho12.916
New Jersey12.917
Tennessee12.918
Nevada12.819
Connecticut12.620
Alaska12.521
Illinois12.522
District Of Columbia12.423
Massachusetts12.424
New Hampshire12.325
North Carolina12.326
Mississippi12.327
Oklahoma12.228
Rhode Island11.929
North Dakota11.930
South Carolina11.931
Minnesota11.932
Delaware11.933
Nebraska11.934
Virginia11.835
Michigan11.836
Arizona11.737
Arkansas11.638
Kansas11.539
Missouri11.340
Oregon11.341
Alabama11.242
Ohio11.143
Iowa11.144
Kentucky10.745
Pennsylvania10.646
Indiana10.347
Washington10.248
New Mexico10.049
Wisconsin9.850
West Virginia8.051

Indiana ranks 47th in the nation and has an average of 10.3 firms with no employees for every 100 persons in the working age population.

Below (Table 4) is the table of states with the average amount of receipts (in thousands) from firms with no employees from each person in the working age population which I refer to as Per-Capita Self-Employed Earnings PCSE. The rank is provided alongside in a separate column. From this table, every no-employee firm in working age population collected an average of $8,650 from receipts in Florida and is the state in the country which has the highest PCSE and earns the 1st rank in the nation..

Table 4: States along with PCSE for the working age population

StatePCSE (in 1000s of dollars)Rank
Florida$8.651
Wyoming$8.542
Delaware$8.233
New Jersey$7.874
New York$7.755
Connecticut$7.726
New Hampshire$7.467
California$7.438
Colorado$7.389
Texas$7.2610
Montana$7.1011
Vermont$6.9812
Nevada$6.9313
Massachusetts$6.8714
Maine$6.6515
Hawaii$6.6416
District Of Columbia$6.5417
South Dakota$6.5218
Utah$6.4819
North Dakota$6.4720
Tennessee$6.4621
Georgia$6.2522
Alaska$6.2023
Idaho$6.1624
Maryland$6.1225
Oklahoma$5.9826
Louisiana$5.9427
Minnesota$5.8328
Arizona$5.7229
Illinois$5.7130
Oregon$5.6531
Rhode Island$5.6532
Nebraska$5.5933
North Carolina$5.4934
Kansas$5.4935
Virginia$5.4236
Pennsylvania$5.4137
South Carolina$5.4038
Washington$5.3239
Michigan$5.3040
Missouri$5.2941
Arkansas$5.2542
Iowa$5.2343
Ohio$5.2044
Mississippi$5.1945
Alabama$5.0246
Kentucky$4.9147
Wisconsin$4.8748
Indiana$4.5049
New Mexico$4.2250
West Virginia$3.1951

Indiana ranks 49th in the nation with an average of $4,500 collected from receipts from each person in the working age population running a self-employed firm.

Conclusion

Small businesses are the backbone of the economy and they have the potential to grow larger and employ more people in the economy. Even if they are just functioning as self-employed businesses, they are still strengthening the economy as the business owners  are providing their services for the society and community. Our analysis of no-employee firms and <20- employee firms shows that states such as Montana, Wyoming, North Dakota, South Dakota have strong small business ecosystems. A straight-forward grouping and summarization would have shown California, New York, Texas, Florida as top states for small businesses. However, with this analysis methodology of considering the working age population and removing the effects of population sizes, we are able to uncover states having active small business communities that are promising economic growth centers.

Bibiliography

1, https://www.census.gov/programs-surveys/susb/data/datasets.html

2. https://www.census.gov/programs-surveys/nonemployer-statistics.html

3. US Census data – https://www.census.gov/data/datasets/time-series/demo/popest/2020s-state-detail.html

Image courtesy: https://pixabay.com/illustrations/jobs-unemployment-main-street-1446885/

Leave a Reply

Your email address will not be published. Required fields are marked *

I’m Ramaa

Welcome to Foxtail Research, my cozy corner of the internet dedicated to all things research – market, data and insights. I invite you to join me on a journey of understanding markets, their behaviors, my models, and theories with a touch of mathematics and some computer programming. Let’s get geeky!

Let’s connect