Please help me!!!!
Define location quotient (LQ)? What does it imply if LQ is equal to 1, less than 1 or more than 1? You have been provided total establishment data by the North American Industrial classification systems (NAICS) for Orange County, California and the USA for 2013. The data was downloaded from County Business Patterns, US Census. Use the location quotient tool to calculate the size of LQ for each industry and analyze the results to answer the following questions.
- Prepare a table showing the industries that have LQ>1 and industries that have LQ
- What are your observations on the patterns of industry specialization in Orange County relative to California and California relative to US?
- Is the Orange County primarily a finance, insurance and real estate (FIRE) sector specializing region? Does it have other industries? What can you say about California relative to US?
Major Industry Orange County, 2013 California, 2013 USA, 2013 Location Location Total Total Total Quotient, Quotient for establishments establishments establishments Orange County California 89496 874243 7488353 1.000 1.000 40 1910 22111 0.205 0.740 NAICS Code NAICS code description Total for all sectors 11---- Agriculture, Forestry, Fishing and Hunting 819 21 ---- 22---- 23---- 31---- 42---- 44--- Mining, Quarrying, and Oil and Gas Extraction Utilities Construction Manufacturing Wholesale Trade Retail Trade Transportation and Warehousing Information Finance and Insurance Real Estate and Rental and Leasing 37 83 63641 4637 7507 9461 1177 1476 6327 5468 1185 66168 38154 59269 106820 21397 21536 49930 499601 28720 18004 658483 292094) 419648 1063616 215547 135627 472242 357533 0.441 0.684 0.940 1.187 1.237 0.865 0.537 0.669 1.238 1,069 0.244 0.564 0.861 1.119 1.210 0.860 0.850 1.360 0.906 1.197 48---- 51---- 52---- 53---- 54---- 55---- 14482 707 117282 5132 869445 52909 1.206 1.346 1.155 0.831 393354 56---- 61---- 62---- 71---- 72---- Professional, Scientific, and Technical Services , , Management of Companies and Enterprises Administrative and Support and Waste Management and Remediation Services Educational Services Health Care and Social Assistance Arts, Entertainment, and Recreation Accommodation and Food Services Other Services (except Public Administration) Industries not classified Total 4647 12601 11065 1035 7321 6237 165 178992 42454 13139 104640 21618 80054 71028 1748 1748486 981041 843603 126952 673810 734406 121451 14976706 1.069 0,937 1.033 0.468 0.893 0.858 0.922 1.000 0.924 1.147 1.062 1.459 1.018 0.828 1.233 1.000 81 99...- Major Industry Orange County, 2013 California, 2013 USA, 2013 Location Location Total Total Total Quotient, Quotient for establishments establishments establishments Orange County California 89496 874243 7488353 1.000 1.000 40 1910 22111 0.205 0.740 NAICS Code NAICS code description Total for all sectors 11---- Agriculture, Forestry, Fishing and Hunting 819 21 ---- 22---- 23---- 31---- 42---- 44--- Mining, Quarrying, and Oil and Gas Extraction Utilities Construction Manufacturing Wholesale Trade Retail Trade Transportation and Warehousing Information Finance and Insurance Real Estate and Rental and Leasing 37 83 63641 4637 7507 9461 1177 1476 6327 5468 1185 66168 38154 59269 106820 21397 21536 49930 499601 28720 18004 658483 292094) 419648 1063616 215547 135627 472242 357533 0.441 0.684 0.940 1.187 1.237 0.865 0.537 0.669 1.238 1,069 0.244 0.564 0.861 1.119 1.210 0.860 0.850 1.360 0.906 1.197 48---- 51---- 52---- 53---- 54---- 55---- 14482 707 117282 5132 869445 52909 1.206 1.346 1.155 0.831 393354 56---- 61---- 62---- 71---- 72---- Professional, Scientific, and Technical Services , , Management of Companies and Enterprises Administrative and Support and Waste Management and Remediation Services Educational Services Health Care and Social Assistance Arts, Entertainment, and Recreation Accommodation and Food Services Other Services (except Public Administration) Industries not classified Total 4647 12601 11065 1035 7321 6237 165 178992 42454 13139 104640 21618 80054 71028 1748 1748486 981041 843603 126952 673810 734406 121451 14976706 1.069 0,937 1.033 0.468 0.893 0.858 0.922 1.000 0.924 1.147 1.062 1.459 1.018 0.828 1.233 1.000 81 99
