The Department of Labor has sponsored a special tabulation of Census data on
Limited English proficient (LEP) populations as a resource for planning
employment and training services. Information is broken out for 39 Census
languages and language clusters, and the tabulations are designed to match the
service areas of states and local Workforce Investment Areas. Each state and
local Workforce Investment Area (LWIA) has a separate Excel workbook file
containing six worksheets or pages. In addition to this Introduction page, there
are a Glossary, a Quick Reference Guide, and three large tables:
Table 1: Total Population (the number of people in the state or LWIA age 5 and
older who speak a language other than English at home, along with a self-reported
measure of how well they speak English.)
Table 2: Adults (the number of adults in the state or LWIA age 18 and older who speak a language other than English at home, along with a self-reported measure
of how well they speak English.)
Table 3: Characteristics (a socio-economic profile of the population that reports
speaking English "not very well" or "not at all" with their employment status,
occupation, income, earnings and other labor market characteristics.)
Where the Data Come From
Source data for the tabulations comes from a 1-in-6 sample of U.S. households
contacted for the 2000 Census - - the same source used for many tables
available through American FactFinder (
http://factfinder.census.gov). The tables presented here were designed by DOL specifically with the workforce investment
system in mind, and are not available through FactFinder. If you would like to
check on the way your service area was defined for these tables, go to the
Definitions of Local Workforce Investment Areas page on this site.
What the Data Tables Contain
- Tables 1 and 2 are estimates of the numbers of LEP people within the
service area. They display the number and percentage of people within each
language group who can speak English at four levels of ability, ranging from
"very well" to "not at all." Understanding the entire range of language ability
can be helpful in service planning, and it allows users to define their own
cut-off points for limited English proficiency if needed. (For example, for some
purposes, it may be useful to know the number of residents who speak English
less than well.) There is also an estimate across all non-English languages, and
an estimate of the population that speaks only English at home.
Tables 1 and 2 are identical in layout: Table 1 includes the entire population
age 5 and above, while Table 2 is limited to the population age 18 and above,
who may be eligible for WIA services to Adults.
- Table 3 takes a closer look at the social and economic characteristics of people
who speak a language other than English at home and whose English proficiency
is limited to speaking English "not well" or "not at all." Foreign language
speakers who speak English "well" or "very well" are not represented
in Table 3. Output covers the same 39 languages or language clusters that
appear in Tables 1 and 2, plus a summary across all non-English languages.
For purposes of comparison, there is also a column that shows the characteristics
of residents who speak only English at home. Most measures refer to the
population age 18 and over.
Some Practical Tips for Working with the Data Tables in Excel
To view a different table or page of the file: To navigate between tables or
pages, just click on the
gray tabs that appear near the bottom of your screen.
To view the tables on-screen: Use the
arrow keys,
PageUp/ PageDown keys,
and
scroll bars to move to different parts of the table. The
Zoom feature in the
top menu bar (very much like Word's) allows you to reduce or enlarge the view.
You can also hold the table headings in view while you move around in the table.
Position the cursor at the 'corner' of the top and left-hand labels (cell B7 in Tables
1 and 2, cell B10 in Table 3), and click on
Window > Freeze panes in the top menu.
Printing: The files are set up to print in landscape format, with column and row headings reproduced on each page. To print just one table, go to that table's
worksheet and select
File > Print > OK. To print the entire workbook (all tables,
plus the Introduction, Quick Reference, and Glossary sheets), check 'Entire workbook'
in the lower-left of the print dialogue box.
Tables 1 and 2 should print out onto two pages, and Table 3 onto 18 pages.
However, Excel files may print differently on different printers, and unnecessary
pages can sometimes be generated. To avoid this, select
File > Print preview
and check for nearly-blank pages. They can usually be eliminated by selecting
File > Page setup >
Page, and adjusting the scaling to 95% or 90% of normal size.
For More Advanced Users: The tables are active Excel spreadsheets. The contents can be reformatted, and new worksheets can be created that analyze the data
in different ways -- for example, by regrouping languages or creating new
percentage measures.
Identifiers and Missing LWIAs
LWIA Identifiers. All tables show the state, and an LWIA name and number in
the Heading information. Although it will usually be easy to identify your LWIA,
some recent name changes may not be reflected in these listings.
The LWIA number is the organization's official identifier in the DOL WIASRD
database. In a few cases (mostly new LWIAs) the correct number could not be
determined, and the LWIA was assigned a 'dummy' number ending in 99. The
LWIA name and number can easily be changed before printing.
LWIAs with statewide service areas (including District of Columbia, Puerto Rico,
and the multi-state Navajo Nation service area) should use the state-level tabulations.
Output for some LWIAs was censored because of insufficient population
size. In all its published output, Census applies very strict rules to protect the
confidentiality of individuals and families. The Census Disclosure Review Board
scrutinized the LEP special tabulation very closely because of its very detailed
breakout of small language groups, and in some cases determined that the
population of an LWIA service area was too small to allow results to be published.
Tabulations for 31 LWIAs were censored because of confidentiality concerns.
In the ten states where this occurred, data for all excluded service areas within
the state are grouped together and presented under the title 'Balance of
State.' A list of affected LWIAs appears at the end of these instructions.
Limitations of the Data
Like all data sources, the LEP special tabulation has limitations to keep in mind:
- It refers to a single point in time (February 2000). The characteristics of the
population may have changed since then.
-
Although the base sample is very large, it is still a sample and subject to a
degree of statistical error. In most cases the Census Bureau has also rounded
population counts to the nearest 0 or 5.
- In some areas of the country, it is likely that recent immigrants were under-
counted in the 2000 Census, leading to under-estimates of the LEP population.
- The crucial measure for defining LEP -- Ability to speak English -- is based on
self-report, or on an answer given by another member of the household.
- In some cases there may have been errors in reporting the type of language
spoken at home, as the names used by speakers of a language to identify it may
reflect ethnic, geographic, or political factors rather than true linguistic distinctions.
Technical documentation for the source data in these tables (including definitions
of terms and guidelines for calculating standard errors and confidence intervals)
can be found in the Census 2000 Summary File 3 technical documentation,
available at
Census Summary File-3 Technical Documentation. The Glossary
worksheet that comes with the tables also provides helpful definitions of terms.
| State | Name | LWIA | Data can be found in... |
|---|
| Arizona | Apache County | 4060 | AZ Balance of State |
| Graham County | 4015 | " " |
| Greenlee County | 4020 | " " |
| Navajo County | 4075 | " " |
| Nineteen Tribal Nations WIA | 4090 | " " |
| Santa Cruz County | 4040 | " " |
| California | Mendocino County | 6235 | CA Balance of State |
| Richmond (city) | 6055 | " " |
| San Benito County | 6225 | " " |
| Colorado | Big Ten Counties Northeast Colorado | 8045 | CO Balance of State |
| Northwest Region | 8045 | " " |
| South Central Region | 8045 | " " |
| Southeast Region | 8045 | " " |
| Southwest Region | 8045 | " " |
| Upper Arkansas Region | 8045 | " " |
| Western Region | 8045 | " " |
| Florida | Florida Crown -Region 7 | 12230 | FL Balance of State |
| Hawaii | County of Kauai | 15020 | HI Balance of State |
| Illinois | Vermilion County | 17090 | IL Balance of State |
| Iowa | Iowa Valley Community College, Region 6 | 19030 | IA Balance of State |
| NW Iowa Planning; Regions 3 | 19100 | " " |
| NW Iowa Region 4 | 19110 | " " |
| Region XII COG; Region 8 | 19155 | " " |
| WIA Matura Action Corporation, Region 14 | 19150 | " " |
| Minnesota | Duluth (city) | 27005 | MN Balance of State |
| Northwest Minnesota | 27045 | " " |
| Winona County | 27080 | " " |
| New York | Sullivan County | 36140 | NY Balance of State |
| Tompkins County | 36225 | " " |
| Oklahoma | Northwest Oklahoma | 40005 | OK Balance of State |
