Skip Main Navigation Skip To Navigation Content

Current Population Survey (CPS)

Skip top of page navigation
You are here: Census.gov People and Households Current Population Survey (CPS) MainData › Examples

Examples

  1. Create a simple table
  2. Create a table that displays nested row variables
  3. Create a table that displays separate row variables
  4. Showing percentages
  5. Showing an additional numeric variable statistic
  6. Using a subset
  7. Using an alternate pre-defined format
  8. Using a customized format

Create a simple table  back to top
  • NOTE: You can create a table by completing Define Your Table section, and using the default selections for all other sections.
  • To create a table that shows Educational Attainment by Health Insurance Coverage:
    • select "Educational Attainment" from the First Row variable selection box
    • select "Health Insurance Coverage" from the First Column variable selection box
    • press the "Get Table" button at the top or bottom of the form.
    • this creates the table below
CPS Data Collected in Year: 2004
Persons in Poverty Universe
 
(Numbers in Thousands)
 
NOTE: The Current Population Survey Annual Social and Economic Supplement is an annual survey of approximately 78,000 households nationwide. Therefore, use extreme caution when making inferences when the cell sizes are small.
Some CPS questions, such as income, ask about the previous year. Others, such as age, refer to the time of the survey. The column labels indicate any subject with a reference year which differs from the survey year.

  Totals Health Insurance Coverage in 2003
Insured Uninsured
Totals 287,699 242,893 44,806
Educational Attainment 60,115 53,617 6,498
Children under 15
No high school diploma 46,575 34,874 11,701
High school or equivalent 68,303 54,997 13,306
Some college, less than 4-yr degree 58,608 49,994 8,614
Bachelor's degree or higher 54,098 49,411 4,687

Source: U.S. Census Bureau
Current Population Survey, Annual Social and Economic Supplement, 2004

Create a table that displays nested row variables  back to top
  • To create a table that nests Educational Attainment and Sex by Health Insurance Coverage:
    • NOTE: If you previously created the first example table, then use the Clear Form button in the tool to reset the form. The steps below presume you have not previously created the previous example table.
    • Under Define Your Table section select "Educational Attainment" from the First Row variable selection box
    • select "Sex" from the Second Row variable selection box
    • select "Health Insurance Coverage" from the First Column variable selection box
    • press the "Get Table" button at the top or bottom of the form.
    • this creates the table below -- note that the counts by Sex are nested within each value of Educational Attainment
CPS Data Collected in Year: 2004
Persons in Poverty Universe
 
(Numbers in Thousands)
 
NOTE: The Current Population Survey Annual Social and Economic Supplement is an annual survey of approximately 78,000 households nationwide. Therefore, use extreme caution when making inferences when the cell sizes are small.
Some CPS questions, such as income, ask about the previous year. Others, such as age, refer to the time of the survey. The column labels indicate any subject with a reference year which differs from the survey year.

  Totals Health Insurance Coverage in 2003
Insured Uninsured
Totals Totals 287,699 242,893 44,806
Sex 140,931 117,216 23,715
Male
Female 146,768 125,677 21,091
Educational Attainment   60,115 53,617 6,498
Children under 15 Totals
Sex 30,675 27,353 3,321
Male
Female 29,440 26,263 3,177
No high school diploma Totals 46,575 34,874 11,701
Sex 23,518 16,950 6,568
Male
Female 23,057 17,924 5,133
High school or equivalent Totals 68,303 54,997 13,306
Sex 32,507 25,302 7,205
Male
Female 35,796 29,695 6,101
Some college, less than 4-yr degree Totals 58,608 49,994 8,614
Sex 26,975 22,793 4,182
Male
Female 31,633 27,201 4,432
Bachelor's degree or higher Totals 54,098 49,411 4,687
Sex 27,256 24,817 2,439
Male
Female 26,842 24,595 2,248

Source: U.S. Census Bureau
Current Population Survey, Annual Social and Economic Supplement, 2004

Create a table that displays separate row variables  back to top
  • To create a table that displays Educational Attainment and Sex as separate row variables by the column variable Health Insurance Coverage:
    • select "separate" from the selection box immediately above the First Row selection box and beside the text "Row Variables".
    • select "Educational Attainment" from the First Row variable selection box
    • select "Sex" from the Second Row variable selection box
    • select "Health Insurance Coverage" from the First Column variable selection box
    • press the "Get Table" button at the top or bottom of the form.
    • this creates the table below -- note that the counts Educational Attainment and Sex are not nested, they appear with the First Row variable's counts followed by the Second Row variable's counts
CPS Data Collected in Year: 2004
Persons in Poverty Universe
 
(Numbers in Thousands)
 
NOTE: The Current Population Survey Annual Social and Economic Supplement is an annual survey of approximately 78,000 households nationwide. Therefore, use extreme caution when making inferences when the cell sizes are small.
Some CPS questions, such as income, ask about the previous year. Others, such as age, refer to the time of the survey. The column labels indicate any subject with a reference year which differs from the survey year.

  Totals Health Insurance Coverage in 2003
Insured Uninsured
Totals 287,699 242,893 44,806
Educational Attainment 60,115 53,617 6,498
Children under 15
No high school diploma 46,575 34,874 11,701
High school or equivalent 68,303 54,997 13,306
Some college, less than 4-yr degree 58,608 49,994 8,614
Bachelor's degree or higher 54,098 49,411 4,687
Sex 140,931 117,216 23,715
Male
Female 146,768 125,677 21,091

Source: U.S. Census Bureau
Current Population Survey, Annual Social and Economic Supplement, 2004

Showing percentages  back to top
  • To create a table that shows Educational Attainment by Health Insurance Coverage and shows both the default person count and the percent (with one decimal place) of persons by Health Insurance Coverage:
    • select "Educational Attainment" from the First Row variable selection box
    • select "Health Insurance Coverage" from the First Column variable selection box
    • under the Statistics section, select "Health Insurance Coverage" from the "Percentages by" selection box --note that your "Percentages by" selection MUST be a variable you have selected for a Row, Column, or Page variable in your table and you may not use a "Percentage by" variable when you display two or more "separate" variables in Rows or Columns
    • select "One Decimal" from the "Percentages by" selection box
    • press the "Get Table" button at the top or bottom of the form.
    • this creates the table below
CPS Data Collected in Year: 2004
Persons in Poverty Universe
Percentages by Health Insurance Coverage
(Sums in Thousands)
 
NOTE: The Current Population Survey Annual Social and Economic Supplement is an annual survey of approximately 78,000 households nationwide. Therefore, use extreme caution when making inferences when the cell sizes are small.
Some CPS questions, such as income, ask about the previous year. Others, such as age, refer to the time of the survey. The column labels indicate any subject with a reference year which differs from the survey year.

  Totals Health Insurance Coverage in 2003
Insured Uninsured
Persons Persons Persons
Sum PCT Sum PCT Sum PCT
Totals 287,699 100.0% 242,893 84.4% 44,806 15.6%
Educational Attainment 60,115 100.0% 53,617 89.2% 6,498 10.8%
Children under 15
No high school diploma 46,575 100.0% 34,874 74.9% 11,701 25.1%
High school or equivalent 68,303 100.0% 54,997 80.5% 13,306 19.5%
Some college, less than 4-yr degree 58,608 100.0% 49,994 85.3% 8,614 14.7%
Bachelor's degree or higher 54,098 100.0% 49,411 91.3% 4,687 8.7%

Source: U.S. Census Bureau
Current Population Survey, Annual Social and Economic Supplement, 2004

Showing an additional numeric variable statistic  back to top
  • To create a table that shows Educational Attainment by Health Insurance Coverage and shows the average Family Income instead of the Person count:
    • select "Educational Attainment" from the First Row variable selection box
    • select "Health Insurance Coverage" from the First Column variable selection box
    • in the Statistics section, select "Family Income" from the "Variable" selection box in the "Additional numeric variable statistics" section
    • select "Mean" (the default) from the "Statistics" selection box
    • select "No" from the "Display the default sums" selection box
    • press the "Get Table" button at the top or bottom of the form.
    • this creates the table below
CPS Data Collected in Year: 2004
Persons in Poverty Universe
 
 
 
NOTE: The Current Population Survey Annual Social and Economic Supplement is an annual survey of approximately 78,000 households nationwide. Therefore, use extreme caution when making inferences when the cell sizes are small.
Some CPS questions, such as income, ask about the previous year. Others, such as age, refer to the time of the survey. The column labels indicate any subject with a reference year which differs from the survey year.

  Totals Health Insurance Coverage in 2003
Insured Uninsured
Family Income in 2003 Family Income in 2003 Family Income in 2003
Mean Mean Mean
Totals 64,354 68,532 41,704
Educational Attainment 65,499 68,271 42,627
Children under 15
No high school diploma 45,666 49,939 32,929
High school or equivalent 51,559 54,572 39,101
Some college, less than 4-yr degree 64,244 67,697 44,199
Bachelor's degree or higher 95,443 98,318 65,132

Source: U.S. Census Bureau
Current Population Survey, Annual Social and Economic Supplement, 2004

Using a subset  back to top
  • To create a table that shows Educational Attainment by Health Insurance Coverage but only includes people in the state of Maryland:
    • select "Educational Attainment" from the First Row variable selection box
    • select "Health Insurance Coverage" from the First Column variable selection box
    • press the "Get Table" button at the top or bottom of the form.
    • now select "Maryland" from the "By State" selection box under Filters/Subsets section at the top of the results table (you can select up to five subsetting conditions for a table)
    • this creates the table below -- note that the subset is indicated in the box in the extreme upper left corner of the table
CPS Data Collected in Year: 2004
Persons in Poverty Universe
 
(Numbers in Thousands)
 
NOTE: The Current Population Survey Annual Social and Economic Supplement is an annual survey of approximately 78,000 households nationwide. Therefore, use extreme caution when making inferences when the cell sizes are small.
Some CPS questions, such as income, ask about the previous year. Others, such as age, refer to the time of the survey. The column labels indicate any subject with a reference year which differs from the survey year.

State: MD Totals Health Insurance Coverage in 2003
Insured Uninsured
Totals 5,485 4,725 760
Educational Attainment 1,132 1,047 85
Children under 15
No high school diploma 825 594 231
High school or equivalent 1,289 1,026 263
Some college, less than 4-yr degree 913 804 110
Bachelor's degree or higher 1,325 1,254 71

Source: U.S. Census Bureau
Current Population Survey, Annual Social and Economic Supplement, 2004

Using an alternate pre-defined format  back to top
  • To create a table that shows Age by Sex but uses the Age groupings of age 0-5 and 6-17 (and excludes people of all other ages):
    • select "Age" from the First Row variable selection box
    • select "Sex" from the First Column variable selection box
    • under the Customized Formatting section, select "00-05,06-17" from the "Age Ranges" selection box (this lists the age groupings that frequently occur in our published tables); note that this also subsets by age
    • press the "Get Table" button at the top or bottom of the form.
    • this creates the table below -- note that the subset is NOT shown in the upper-left box of the table; the subset is not shown when that variable is a row, column, or page variable
CPS Data Collected in Year: 2004
Persons in Poverty Universe
 
(Numbers in Thousands)
 
NOTE: The Current Population Survey Annual Social and Economic Supplement is an annual survey of approximately 78,000 households nationwide. Therefore, use extreme caution when making inferences when the cell sizes are small.
Some CPS questions, such as income, ask about the previous year. Others, such as age, refer to the time of the survey. The column labels indicate any subject with a reference year which differs from the survey year.

  Totals Sex
Male Female
Totals 72,999 37,184 35,815
Age 23,629 12,039 11,590
00 to 05
06 to 17 49,370 25,145 24,225

Source: U.S. Census Bureau
Current Population Survey, Annual Social and Economic Supplement, 2004

Using a customized format  back to top
  • To create a table that shows Age by Sex but uses the Age groupings of age 0-10 and 11-20 (and excludes people of all other ages):
    • select "Age" from the First Row variable selection box
    • select "Sex" from the First Column variable selection box
    • under Customized Formatting section, select "Customize your own age ranges" under Age Ranges selection box and enter
      • "0" (or "00") in the "Minimum Age Range #1" box
      • "10" in the "Maximum Age Range #1" box
      • "11" in the "Minimum Age Range #2" box
      • "20" in the "Maximum Age Range #2" box
      (this is how to get age groupings that are not listed in the selection box above -- note that there may not be gaps in the age ranges, such as 3-9 and 11-17 with age 10 omitted); note that this also subsets by age
    • press the "Get Table" button at the top or bottom of the form.
    • this creates the table below -- note that the subset is NOT shown in the upper-left box of the table; the subset is not shown when that variable is a row, column, or page variable
CPS Data Collected in Year: 2004
Persons in Poverty Universe
 
(Numbers in Thousands)
 
NOTE: The Current Population Survey Annual Social and Economic Supplement is an annual survey of approximately 78,000 households nationwide. Therefore, use extreme caution when making inferences when the cell sizes are small.
Some CPS questions, such as income, ask about the previous year. Others, such as age, refer to the time of the survey. The column labels indicate any subject with a reference year which differs from the survey year.

  Totals Sex
Male Female
Totals 84,592 43,254 41,338
Age 43,125 22,060 21,065
00 to 10
11 to 20 41,467 21,194 20,273

Source: U.S. Census Bureau
Current Population Survey, Annual Social and Economic Supplement, 2004


Source: U.S. Census Bureau | Current Population Survey (CPS) |  Last Revised: