Spreadsheet: 725113d1616533485-vlookup-value-error-but-correct-formula-tax-concentration-ratio-data-32321
Sheet: Sheet5

Meaning of NAICS code (NAICS2017_LABEL) | C4 Concentration Ratio
Oil and gas extraction | 0.1850386392103049
Coal mining | 0.3424142195861903
Metal ore mining | 0.5132194458409364
Nonmetallic mineral mining and quarrying | 0.1865102068747669
Support activities for mining | 0.2507228427791136
Electric power generation, transmission and distribution | 0.194467302818004
Natural gas distribution | 0.2421513559720444
Water, sewage and other systems | 0.4065816902072389
Residential building construction | 0.1073278539542502
Nonresidential building construction | 0.05571260955976558
Utility system construction | 0.1227769066438192
Land subdivision | 0.1291731793718453
Highway, street, and bridge construction | 0.08927936966603597
Other heavy and civil engineering construction | 0.1452097891028317
Foundation, structure, and building exterior contractors | 0.01306477593666139
Building equipment contractors | 0.03461158417982665
Building finishing contractors | 0.0253928184128794
Other specialty trade contractors | 0.03918263768491115
Animal food manufacturing | 0.3013212485690512
Grain and oilseed milling | 0.4354300108260051
Sugar and confectionery product manufacturing | 0.3493317999896291
Fruit and vegetable preserving and specialty food manufacturing | 0.1883050208108936
Dairy product manufacturing | 0.1644274287820079
Animal slaughtering and processing | 0.4253678405059489
Seafood product preparation and packaging | 0.276444684213026
Bakeries and tortilla manufacturing | 0.197286064683443
Other food manufacturing | 0.2558108479533793
Beverage manufacturing | 0.3322017984481695
Tobacco manufacturing | 0.9108834626628332
Fiber, yarn, and thread mills | 0.4606837674191095
Fabric mills | 0.1885512325201306
Textile and fabric finishing and fabric coating mills | 0.1997298614152055
Textile furnishings mills | 0.3990785514874214
Other textile product mills | 0.1438193375027499
Apparel knitting mills | 0.2942864393050761
Cut and sew apparel manufacturing | 0.0735265811534911
Apparel accessories and other apparel manufacturing | 0.280417249732918
Leather and hide tanning and finishing | 0.6001713471209372
Footwear manufacturing | 0.4211350156139596
Other leather and allied product manufacturing | 0.2254854977175084
Sawmills and wood preservation | 0.1818881669020439
Veneer, plywood, and engineered wood product manufacturing | 0.2617106566764912
Other wood product manufacturing | 0.1517341786188496
Pulp, paper, and paperboard mills | 0.4523216997791072
Converted paper product manufacturing | 0.2571306271050997
Printing and related support activities | 0.137800311494789
Petroleum and coal products manufacturing | 0.4194979944587622
Basic chemical manufacturing | 0.2467628844365993
[NAME], synthetic rubber, and artificial synthetic fibers and filaments manufacturing | 0.2544573134861142
Pesticide, fertilizer, and other agricultural chemical manufacturing | 0.3109762486226311
Pharmaceutical and medicine manufacturing | 0.357377425376211
Paint, coating, and adhesive manufacturing | 0.2890902310352087
Soap, cleaning compound, and toilet preparation manufacturing | 0.4105525544799808
Other chemical product and preparation manufacturing | 0.1110777678096385
Plastics product manufacturing | 0.08473291998124707
Rubber product manufacturing | 0.3402528852986418
Clay product and refractory manufacturing | 0.2266478778848412
[NAME] and glass product manufacturing | 0.2665916196502786
Cement and concrete product manufacturing | 0.127604640209825
Lime and gypsum product manufacturing | 0.5376133749286347
Other nonmetallic mineral product manufacturing | 0.2223536976290792
Iron and steel mills and ferroalloy manufacturing | 0.5009022895211136
Steel product manufacturing from purchased steel | 0.1302873437669981
[NAME] and aluminum production and processing | 0.3836680864030036
Nonferrous metal (except aluminum) production and processing | 0.2022222174470502
Foundries | 0.2091144536275233
Forging and stamping | 0.1733286725094429
Cutlery and handtool manufacturing | 0.2945972576754521
Architectural and structural metals manufacturing | 0.06109826563164957
Boiler, tank, and shipping container manufacturing | 0.3154897601873743
Hardware manufacturing | 0.2915481848660037
Spring and wire product manufacturing | 0.16949683124757
Machine shops; turned product; and screw, nut, and bolt manufacturing | 0.04272667371168521
Coating, engraving, heat treating, and allied activities | 0.1271783901767721
Other fabricated metal product manufacturing | 0.09442763172367523
Agriculture, construction, and mining machinery manufacturing | 0.3428348867493031
Industrial machinery manufacturing | 0.1436990182049098
Commercial and service industry machinery manufacturing | 0.1397711299418697
Ventilation, heating, air-conditioning, and commercial refrigeration equipment manufacturing | 0.2662249571087644
Metalworking machinery manufacturing | 0.0866832821554501
Engine, turbine, and power transmission equipment manufacturing | 0.4388008106101471
Other general purpose machinery manufacturing | 0.07323035311468906
Computer and peripheral equipment manufacturing | 0.3944653136957335
Communications equipment manufacturing | 0.3038572667762628
Audio and video equipment manufacturing | 0.30838984112261
Semiconductor and other electronic component manufacturing | 0.2516860767674733
Navigational, measuring, electromedical, and control instruments manufacturing | 0.1747946498687862
Manufacturing and reproducing magnetic and optical media | 0.3791554716997904
Electric lighting equipment manufacturing | 0.2028618936822832
Household appliance manufacturing | 0.628525269736056
Electrical equipment manufacturing | 0.2658257227118618
Other electrical equipment and component manufacturing | 0.1464136634932335
Motor vehicle manufacturing | 0.6152508260584233
Motor vehicle body and trailer manufacturing | 0.3231021777411739
Motor vehicle parts manufacturing | 0.1527373195398079
Aerospace product and parts manufacturing | 0.6544125808201017
Railroad rolling stock manufacturing | 0.4003243716265082
Ship and boat building | 0.4636580962410254
Other transportation equipment manufacturing | 0.5069698713547907
Household and institutional furniture and kitchen cabinet manufacturing | 0.2018702977077611
Office furniture (including fixtures) manufacturing | 0.2166365398907202
Other furniture related product manufacturing | 0.5255299550961403
Medical equipment and supplies manufacturing | 0.2141081502217342
Other miscellaneous manufacturing | 0.08980982673752134
Motor vehicle and motor vehicle parts and supplies merchant wholesalers | 0.400508783853741
Furniture and home furnishing merchant wholesalers | 0.116022590662519
Lumber and other construction materials merchant wholesalers | 0.1141943968670177
Professional and commercial equipment and supplies merchant wholesalers | 0.139935568685306
Metal and mineral (except petroleum) merchant wholesalers | 0.1413553419762679
Household appliances and electrical and electronic goods merchant wholesalers | 0.2602725840401419
Hardware, plumbing and heating equipment and supplies merchant wholesalers | 0.1833410885498241
Machinery, equipment, and supplies merchant wholesalers | 0.1080126282176796
Miscellaneous durable goods merchant wholesalers | 0.07981389542379819
Paper and paper product merchant wholesalers | 0.2484628718271306
Drugs and druggists' sundries merchant wholesalers | 0.4734834901145408
Apparel, piece goods, and notions merchant wholesalers | 0.1403866043177656
Grocery and related product merchant wholesalers | 0.1441784453028568
Farm product raw material merchant wholesalers | 0.3067431231154362
Chemical and allied products merchant wholesalers | 0.1465538056554487
Petroleum and petroleum products merchant wholesalers | 0.2585158604484742
Beer, wine, and distilled alcoholic beverage merchant wholesalers | 0.2381500594651965
Miscellaneous nondurable goods merchant wholesalers | 0.2118691510763644
Wholesale electronic markets and agents and brokers | 0.2877252946409464
Automobile dealers | 0.05897959425160634
Other motor vehicle dealers | 0.09944682752562457
Automotive parts, accessories, and tire stores | 0.3305357372881763
Furniture stores | 0.2152030088093007
Home furnishings stores | 0.3157671893170179
Electronics and appliance stores | 0.5844901874593398
Building material and supplies dealers | 0.5527895087475165
Lawn and garden equipment and supplies stores | 0.2214221254762093
Grocery stores | 0.3464063241204361
Specialty food stores | 0.05454761197873201
Beer, wine, and liquor stores | 0.1240882814477149
Health and personal care stores | 0.5956843227530544
Gasoline stations | 0.1729302679467897
Clothing stores | 0.30115028167338
Shoe stores | 0.3550561202226356
Jewelry, luggage, and leather goods stores | 0.2857410781581471
Sporting goods, hobby, and musical instrument stores | 0.3070592189338002
Book stores and news dealers | 0.6651429306370239
Department stores | 0.7297549464743627
General merchandise stores, including warehouse clubs and supercenters | 0.8409457377086368
Florists | 0.01410765952721658
Office supplies, stationery, and gift stores | 0.4344739496601254
Used merchandise stores | 0.117382288668432
Other miscellaneous store retailers | 0.222826285120683
Electronic shopping and mail-order houses | 0.3659375502354542
Vending machine operators | 0.4177382155804404
Direct selling establishments | 0.1113858659367963
Scheduled air transportation | 0.6910388460623055
Nonscheduled air transportation | 0.3677079483651581
Deep sea, coastal, and great lakes water transportation | 0.5857134763268108
Inland water transportation | 0.4917328898358104
General freight trucking | 0.1211783479999447
Specialized freight trucking | 0.05820732518131871
Urban transit systems | 0.4580045449482434
Interurban and rural bus transportation | 0.5785039280428099
Taxi and limousine service | 0.5610089401080588
School and employee bus transportation | 0.3450224431049469
Charter bus industry | 0.1415531934793492
Other transit and ground passenger transportation | 0.1535797029942833
Pipeline transportation of crude oil | 0.5222274394851322
Pipeline transportation of natural gas | 0.503567502402246
Other pipeline transportation | 0.5815228219415546
Scenic and sightseeing transportation, land | 0.2260045850778168
Scenic and sightseeing transportation, water | 0.176592093322795
Scenic and sightseeing transportation, other | 0.4658885828753361
Support activities for air transportation | 0.1193475718415986
Support activities for rail transportation | 0.2469594446227387
Support activities for water transportation | 0.2427716567278295
Support activities for road transportation | 0.09251300522366641
Freight transportation arrangement | 0.1216026123872513
Other support activities for transportation | 0.1175429855336609
Couriers and express delivery services | 0.911533652013196
Local messengers and local delivery | 0.2014043768034022
Warehousing and storage | 0.1537191553874384
Newspaper, periodical, book, and directory publishers | 0.1457277003604013
Software publishers | 0.3237161662272712
Motion picture and video industries | 0.3252905514306381
Sound recording industries | 0.6245295081998783
Radio and television broadcasting | 0.4043084190409703
Cable and other subscription programming | 0.6216705941254838
Wired and wireless telecommunications carriers | 0.6231783604281846
Satellite telecommunications | 0.5062833407351289
Other telecommunications | 0.4661892820162321
Data processing, hosting, and related services | 0.1724396129164062
Other information services | 0.5202386365016641
Monetary authorities - central bank | 0.8036307018444376
Depository credit intermediation | 0.2007583584984814
Nondepository credit intermediation | 0.4080406754513102
Activities related to credit intermediation | 0.2593196036735821
Securities and commodity contracts intermediation and brokerage | 0.3007829553450025
Securities and commodity exchanges | 0.9877702496977462
Other financial investment activities | 0.1262800257344108
Insurance carriers | 0.1545900216791257
Agencies, brokerages, and other insurance related activities | 0.4169778866540776
Lessors of real estate | 0.05851600052772021
Offices of real estate agents and brokers | 0.1237025317419631
Activities related to real estate | 0.09744820522664412
Automotive equipment rental and leasing | 0.5697007101657122
Consumer goods rental | 0.3872205323277639
General rental centers | 0.07263076234614259
Commercial and industrial machinery and equipment rental and leasing | 0.224631120839196
Lessors of nonfinancial intangible assets (except copyrighted works) | 0.2684305114135108
Legal services | 0.02909874792874197
Accounting, tax preparation, bookkeeping, and payroll services | 0.2969681803440238
Architectural, engineering, and related services | 0.09111144819790253
Specialized design services | 0.03252122470481211
Computer systems design and related services | 0.1186996626097307
Management, scientific, and technical consulting services | 0.1133567094649294
Scientific research and development services | 0.108564764086187
Advertising, public relations, and related services | 0.1837725092064
Other professional, scientific, and technical services | 0.1032834693218852
Office administrative services | 0.01952491915008574
Facilities support services | 0.2257543928102089
Employment services | 0.2628543852059427
Business support services | 0.1125237979964878
Travel arrangement and reservation services | 0.2406966124901983
Investigation and security services | 0.2457257970887959
Services to buildings and dwellings | 0.05636325685550716
Other support services | 0.08950938361779112
Waste collection | 0.4120171577915174
Waste treatment and disposal | 0.3746536048546258
Remediation and other waste management services | 0.09283929693989396
Business schools and computer and management training | 0.06591000163908754
Technical and trade schools | 0.1619377664432327
Other schools and instruction | 0.0462210835161195
Educational support services | 0.2876954955445976
Offices of physicians | 0.03495158613852185
Offices of dentists | 0.02633914903468868
Offices of other health practitioners | 0.0479598566679403
Outpatient care centers | 0.2360333218131943
Medical and diagnostic laboratories | 0.2974235328296689
Home health care services | 0.1034046556763985
Other ambulatory health care services | 0.1663233949734028
General medical and surgical hospitals | 0.08305522987555874
Psychiatric and substance abuse hospitals | 0.1959275234686929
Specialty (except psychiatric and substance abuse) hospitals | 0.2840357790101251
Nursing care facilities (skilled nursing facilities) | 0.08939806785426214
Residential intellectual and developmental disability, mental health, and substance abuse facilities | 0.06555696969913119
Continuing care retirement communities and assisted living facilities for the elderly | 0.1255305738502569
Other residential care facilities | 0.07264522042361132
Individual and family services | 0.04479479800794123
Community food and housing, and emergency and other relief services | 0.1471905807579505
Vocational rehabilitation services | 0.06727967132688942
Child day care services | 0.081900673765649
Performing arts companies | 0.1027229262405422
Spectator sports | 0.06506987713707553
Promoters of performing arts, sports, and similar events | 0.2896510544371559
Agents and managers for artists, athletes, entertainers, and other public figures | 0.2559293051281185
Independent artists, writers, and performers | 0.0198974525947862
Museums, historical sites, and similar institutions | 0.09400013407043548
Amusement parks and arcades | 0.6583812849387908
Gambling industries | 0.1526007989565715
Other amusement and recreation industries | 0.07929563884507664
Traveler accommodation | 0.1742542271832672
RV (recreational vehicle) parks and recreational camps | 0.06199800218717896
Rooming and boarding houses | 0.2701035865429732
Special food services | 0.5179604527381356
Drinking places (alcoholic beverages) | 0.03632956341790848
Restaurants and other eating places | 0.04521365815464717
Automotive repair and maintenance | 0.04897392831024033
Electronic and precision equipment repair and maintenance | 0.2350767081398708
Commercial and industrial machinery and equipment (except automotive and electronic) repair and maintenance | 0.1107345507469029
Personal and household goods repair and maintenance | 0.2125946416210925
Personal care services | 0.07255465684923765
Death care services | 0.1995977218554423
Drycleaning and laundry services | 0.3019370971946885
Other personal services | 0.1654006349242485
Grantmaking and giving services | 0.09838157823073163
Social advocacy organizations | 0.1209206921256545
Civic and social organizations | 0.0332756835115061
Business, professional, labor, political, and similar organizations | 0.0519608283926396