Summer 2020 Name: Calculate LQ for the selected industries for the following Massachusetts counties using the data provided in the separate page. Use at least 3 places after a decimal point when calculating and reporting LQ. Fill in the LQ values in the table below: NAICS 31-33 0.295 NAICS 61 NAICS 71 Area.Name Barnstable County Bristol County Middlesex County Nantucket County Suffolk County NAICS 54 0.898 0.459 NAICS 72 1.464 0.973 0.690 0.834 3.202 0.618 0.689 0.149 0.193 0.548 1.678 1.010 0.742 2.238 1.059 0.960 Answer the following questions using the information from the table you have completed. Submit this sheet with your input by the due date/time. 1. List all counties that have a higher concentration of workers in professional industry in this dataset. 2. What industry is more concentrated in Bristol County? Name this industry. 3. List all counties that have a higher concentration of both arts and accommodations/food services. 4. Which county has the highest L.Q. value in educational services? 5. Suffolk County has a lower concentration of arts. Choose: True / False. Explain why. Table 1. 10 calculate LQI NAICS 31-33 (Manufacturing) in Barnstable County, LQ = (2,045/74,140)/(11,605,501/124,085,947) which yields 0.295. This translates that Barnstable County has a less concentration for manufacturing industry compared to the national average. Table 1: The number of employees in 5 selected industries for 5 counties in Massachusetts and U.S. total Area Name NAICS 31-33 NAICS 54 Total NAICS 61 NAICS 71 NAICS 72 Employment Barnstable County 2,045 4,721 1,467 1,713 11,544 74,140 Bristol County 24,627 6,360 4,776 3,546 20,211 195,213 Middlesex County 56,048 114,036 81,772 11,607 63,869 869,949 Nantucket County 60 167 78 173 710 4,300 Suffolk County 10,757 70,586 59,178 11,334 60,744 595,158 U.S. 11,605,501 8,798,260 3,642,170 2,230,822 13,196,892 124,085,947 Note: Industries are categorized by the North American Industry Classification System (NAICS). The selected NAICS codes in this table are: NAICS 31-33 - Manufacturing (e.g. food, beverage, tobacco, textile, furniture, etc.) NAICS 54 - Professional, Scientific, and Technical Services (e.g. lawyers, accountants, research, etc.) NAICS 61 - Educational Services (e.g. elementary & secondary schools, colleges, technical schools, etc.) NAICS 71 - Arts, Entertainment, and Recreation (e.g. performing arts, spectator sports, museums, etc.) NAICS 72 - Accommodation and Food Services (e.g, hotels, restaurants, hairs, etc.) GEOG 2100-20 - Economic Geography Summer 2020 Name: Calculate LQ for the selected industries for the following Massachusetts counties using the data provided in the separate page. Use at least 3 places after a decimal point when calculating and reporting LQ. Fill in the LQ values in the table below: Area Name NAICS 31-33 NAICS 54 NAICS 61 NAICS 71 NAICS 72 1 ASA Summer 2020 Name: Calculate LQ for the selected industries for the following Massachusetts counties using the data provided in the separate page. Use at least 3 places after a decimal point when calculating and reporting LQ. Fill in the LQ values in the table below: NAICS 31-33 0.295 NAICS 61 NAICS 71 Area.Name Barnstable County Bristol County Middlesex County Nantucket County Suffolk County NAICS 54 0.898 0.459 NAICS 72 1.464 0.973 0.690 0.834 3.202 0.618 0.689 0.149 0.193 0.548 1.678 1.010 0.742 2.238 1.059 0.960 Answer the following questions using the information from the table you have completed. Submit this sheet with your input by the due date/time. 1. List all counties that have a higher concentration of workers in professional industry in this dataset. 2. What industry is more concentrated in Bristol County? Name this industry. 3. List all counties that have a higher concentration of both arts and accommodations/food services. 4. Which county has the highest L.Q. value in educational services? 5. Suffolk County has a lower concentration of arts. Choose: True / False. Explain why. Table 1. 10 calculate LQI NAICS 31-33 (Manufacturing) in Barnstable County, LQ = (2,045/74,140)/(11,605,501/124,085,947) which yields 0.295. This translates that Barnstable County has a less concentration for manufacturing industry compared to the national average. Table 1: The number of employees in 5 selected industries for 5 counties in Massachusetts and U.S. total Area Name NAICS 31-33 NAICS 54 Total NAICS 61 NAICS 71 NAICS 72 Employment Barnstable County 2,045 4,721 1,467 1,713 11,544 74,140 Bristol County 24,627 6,360 4,776 3,546 20,211 195,213 Middlesex County 56,048 114,036 81,772 11,607 63,869 869,949 Nantucket County 60 167 78 173 710 4,300 Suffolk County 10,757 70,586 59,178 11,334 60,744 595,158 U.S. 11,605,501 8,798,260 3,642,170 2,230,822 13,196,892 124,085,947 Note: Industries are categorized by the North American Industry Classification System (NAICS). The selected NAICS codes in this table are: NAICS 31-33 - Manufacturing (e.g. food, beverage, tobacco, textile, furniture, etc.) NAICS 54 - Professional, Scientific, and Technical Services (e.g. lawyers, accountants, research, etc.) NAICS 61 - Educational Services (e.g. elementary & secondary schools, colleges, technical schools, etc.) NAICS 71 - Arts, Entertainment, and Recreation (e.g. performing arts, spectator sports, museums, etc.) NAICS 72 - Accommodation and Food Services (e.g, hotels, restaurants, hairs, etc.) GEOG 2100-20 - Economic Geography Summer 2020 Name: Calculate LQ for the selected industries for the following Massachusetts counties using the data provided in the separate page. Use at least 3 places after a decimal point when calculating and reporting LQ. Fill in the LQ values in the table below: Area Name NAICS 31-33 NAICS 54 NAICS 61 NAICS 71 NAICS 72 1 ASA