Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Presented by: Liang Long Cambridge Systematics , Inc. PowerPoint Presentation
Download Presentation
Presented by: Liang Long Cambridge Systematics , Inc.

Presented by: Liang Long Cambridge Systematics , Inc.

99 Views Download Presentation
Download Presentation

Presented by: Liang Long Cambridge Systematics , Inc.

- - - - - - - - - - - - - - - - - - - - - - - - - - - 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?