BOC Programs

Revised 11-09-11

AFF2 Exercises

·  American Community Survey (ACS)

·  County Business Patterns

·  Nonemployer Statistics

2010 ACS 1-Year Estimates

Detailed Information about Family Types

1.  For Los Angeles County, California, how many Asian families are living below the poverty level with a female head of household, no husband present? Modify table: collapse income above poverty level/hide row – Download in Excel

AFF2 > Main tab > Quick Start = type (topic) Poverty & (geography) Los Angeles County, CA > Topics = People > People = Race & Ethnicity > Race & Ethnicity = Asian > B17010D: Poverty Status in the Past 12 months of Families … (Asian Alone) (Dataset = 2010 ACS 1-Year Estimates) > Modify Table > collapse rows > Download > Select Microsoft Excel > OK > Download > Open

Answer: 9,435

Back to Search. Clear all selections.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2010 ACS 1-Year Estimates

Grandparents Raising Their Grandchildren and Comparing Multiple Geographies

2.  For Chester, Delaware, Montgomery and Philadelphia counties in Pennsylvania, what is the number of grandparents who have identified themselves as Black or African American, who are 60 years old and over, who are responsible for their own grandchildren under 18 years old? After table selection, modify the table to remove the margins of error and create a map to compare your geographies.

AFF2 > Topics = People > People = Relationship > Relationship = Grandparent > Race & Ethnicity = Black or African American > Geographies = Geography Filter Options >Geography Filter Options = County> Within State = Pennsylvania > Geography Results = expand per page 75 > Geography Results = Chester, Delaware, Montgomery, Philadelphia counties > Add > Close window > B10051B Grandparents Living with Own Grandchildren under 18 years… (Black or African American Alone) (Dataset: 2010 ACS 1-Year Estimates) > Modify Table > uncheck margin of error columns > Hide Table Tools > Create a Map > Click on Grandparent Responsible . . . 60 years and over row and select the first cell with data = Show Map > click Table View (to toggle back to table)

Answer: Chester - - 328

Delaware - - 318

Montgomery - - 443

Philadelphia - - 1,986

Back to Search. Clear all selections.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2009 County Business Patterns

Finding County Level Business & Industry Data

3.  Which sector (2-digit NAICS code) in Los Angeles County, California, has the highest number of establishments in 2009? Which industry had the most paid employees through March 12? Once you have selected your table, modify the table to display only the following columns: geographic area name, 2-digit NAICS code, industry, year, number of establishments, and the paid employees including March 12.

AFF2 > Topics = Year > Year = 2009 > Dataset = 2009 Business Patterns > Geographies > Enter a geography name text box = Los Angeles County, CA > Enter or GO > Geography Results = Los Angeles County, California (hyperlink) > Close window > CB0900A1 = 2009 CBP: GAS: CBP > View > Modify Table > uncheck columns per instructions above > sort the last two columns (one at a time) in descending order

Answer:

Highest number of establishments:

54 - - Professional, Scientific, and Technical Services - - 30,796

Most paid employees:

62 - - Healthcare and Social Assistance - - 472,035

Back to Search. Clear all selections.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2009 Nonemployer Statistics

Finding Business & Industry Data for a Specific Industry

4.  Using 2009 data, which Maryland metropolitan area had the lowest number of nonemployer establishments in the Retail Trade industry?

AFF2 > Topics = Dataset > Dataset = 2009 Nonemployer Statistics > Geographies > Geography Filter Options = Metro/Micro Area > Within State = Maryland > Type of Metro Statistical Area/ Micropolitan Statistical Area = Metro Statistical Area > Check all > Add >Close filter window > Industry Codes > Industry Code Filter Options = Industry Sector > Industry Sector = 44-45 Retail Trade > Industry Code Results = 44-45 Retail Trade (hyperlink) > Close window > NS0900A2: 2009 Nonemployer Statistics: GAS for State, Metro Areas, and Counties > Modify table > sort ascending by number of establishments, then by 2007 NAICS code

Answer: Cumberland, MD-WV Metro Area - - 584

Page 1