1 / 16

Presented by: Liang Long Cambridge Systematics , Inc.

American FactFinder2 Access Equal Employment Opportunity (EEO) Tabulation 2006 - 2010 County to County Flows Self Tutorial. Presented by: Liang Long Cambridge Systematics , Inc. Data Limitations Geography Only County and Place level flows are available

heidi-charles
Download Presentation

Presented by: Liang Long Cambridge Systematics , Inc.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. American FactFinder2Access Equal Employment Opportunity (EEO) Tabulation 2006 - 2010 County to County FlowsSelf Tutorial Presented by: Liang Long CambridgeSystematics, Inc.

  2. Data Limitations • Geography • Only County and Place level flows are available • AFF only provides workplace flows access. • Suppression Rules • A maximum of 9 separate residence are are reported, and commuting flows from all remaining counties are aggregated as “All Other Counties.” • 50,000 or 100,000 population threshold for county’s residence (depending on the table) • Minimum 50 un-weighted cases per residence – to – worksite flows needed *

  3. Example

  4. I want to get flows to Montgomery County, Maryland • EEOtabulations have information on workplace flows. • Workplace flows are included in tables EEO 1W through EEO 7W • Table used in this example • Table EEO 1W: Detailed Census Occupation by Sex and Race/Ethnicity for Worksite Geography Universe: Civilians employed at work 16 years.

  5. Solution (step-by-step illustration)

  6. Step 1 Open American Factfinder2 web page. (http://factfinder2.census.gov/faces/nav/jsf/pages/index.xhtml)

  7. Step 2 Select Advanced Search option. Then click on Show me all. This will take you to main Advanced Search window

  8. Step 3 Open Topics in left navigation bar by clicking right facing arrow head

  9. Step 4 Expand Dataset by clicking on the + sign. Select EEO Tabulation 2006-2010 (5-year ACS data) by clicking on it.

  10. Step 5 Open Geographies in the left navigation bar and select County – 050.

  11. Step 6 Select Maryland as state and then select Montgomery County, Maryland and then click Add to your Selection. Close Geographies once all the selections are added.

  12. Listed Nine Counties • Washington, District of Columbia • Anne Arundel County, MD • Carroll County, MD • Frederick County, MD • Howard County, MD • Montgomery County, MD • Prince George’s County, MD • Arlington County, VA • Fairfax County, VA • All Other Counties

  13. Step 7 Select Table EEO 1W in the table list and then select view. (or, type in EEO 1W in the search within results box and select go).

  14. Step 8 To make modifications, click on Modify Table option on the screen. Modifications, like transposing rows/columns and omitting fields, can be performed to attain the desired results Once all the modifications are complete, select option for Download. You can choose a comma-delimited .csv; .xls, or .pdf. American FactFinder2 will build your table and then click Download. Save the file to your computer

  15. EEO County Flows self tutorial http://www.fhwa.dot.gov/planning/census_issues/ctpp/training/affeeo.cfm

  16. Thank You !Questions?

More Related