Skip Main Navigation Skip To Navigation Content

Current Population Survey (CPS)

Skip top of page navigation
You are here: Census.govPeople and HouseholdsCurrent Population Survey (CPS) MainDataTable Creator Help › Examples

Examples

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

1. Create a simple table  back to top
  • NOTE: You can create a table by completing Section 2, Define Your Table, 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 bottom of the page
    • This creates the table below
CPS Data Collected in Year: 2011
Persons - All
(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 2010
Insured Uninsured
Totals 306,110 256,206 49,904
Educational Attainment 62,155 56,386 5,769
Children under 15
No high school diploma 43,303 32,115 11,188
High school or equivalent 70,476 54,556 15,920
Some college, less than 4-yr degree 65,979 58,544 11,375
Bachelor's degree or higher 64,196 58,544 5,652

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

2. 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:
    • If you previously created the first example table, use the "Clear Form" button at the top of the page to clear all previous entries, if necessary.
    • 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 bottom of the page
    • This creates the table below—note that the counts by Sex are nested within each value of Educational Attainment
CPS Data Collected in Year: 2014
Persons - All
(Numbers in Thousands)
The 2014 CPS ASEC included redesigned questions for income and health insurance coverage. The redesigned income questions were implemented to a subsample using a probability split panel design.
The source of data for this table is the portion of the CPS ASEC sample which received the income questions consistent with the 2013 CPS ASEC, approximately 68,000 addresses.

Totals Health Insurance Coverage
in 2013
Insured Uninsured
Totals Totals 313,395 271,442 41,953
Sex 153,596 131,339 22,258
Male
Female 159,799 140,103 19,696
Educational Attainment 61,051 56,745 4,306
Children under 15 Totals
Sex 31,183 28,905 2,277
Male
Female 29,869 27,839 2,029
No high school diploma Totals 42,090 33,143 8,947
Sex 21,569 16,496 5,074
Male
Female 20,521 16,648 3,873
High school or equivalent Totals 71,145 58,038 13,107
Sex 35,638 28,398 7,240
Male
Female 35,507 29,640 5,867
Some college, less than 4-yr degree Totals 69,041 59,105 9,936
Sex 31,827 27,008 4,818
Male
Female 37,214 32,097 5,117
Bachelor's degree or higher Totals 70,068 64,411 5,657
Sex 33,380 30,531 2,848
Male
Female 36,688 33,880 2,809

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

3. 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 the "Separate" radio button under the second section, Define Your Table. It can be found immediately above the First Row selection box
    • 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 bottom of the page
    • 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: 2014
Persons - All
(Numbers in Thousands)
The 2014 CPS ASEC included redesigned questions for income and health insurance coverage. The redesigned income questions were implemented to a subsample using a probability split panel design.
The source of data for this table is the portion of the CPS ASEC sample which received the income questions consistent with the 2013 CPS ASEC, approximately 68,000 addresses.

Totals Health Insurance Coverage
in 2013
Insured Uninsured
Totals 313,395 271,442 41,953
Educational Attainment 61,051 56,745 4,306
Children under 15
No high school diploma 42,090 33,143 8,947
High school or equivalent 71,145 58,038 13,107
Some college, less than 4-yr degree 69,041 59,105 9,936
Bachelor's degree or higher 70,068 64,411 5,657
Sex 153,596 131,339 22,258
Male
Female 159,799 140,103 19,696

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

4. 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:
    In Section 3, Statistics, select "Health Insurance Coverage" from the "Percentages by" selection box—note that your "Percentages by" selection MUST be a variable that 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 "Educational Attainment" from the First Row variable selection box
    • Select "Health Insurance Coverage" from the First Column variable selection box
    • Also in Section 3, Statistics, select "One Decimal" from the "Percentages by" selection box
    • Also in Section 3, Statistics, select "One Decimal" from the "Percentages by" selection box
    • This creates the table below
CPS Data Collected in Year: 2014
Persons - All
Percentages by Health Insurance Coverage
(Sums in Thousands)
The 2014 CPS ASEC included redesigned questions for income and health insurance coverage. The redesigned income questions were implemented to a subsample using a probability split panel design.
The source of data for this table is the portion of the CPS ASEC sample which received the income questions consistent with the 2013 CPS ASEC, approximately 68,000 addresses.

Totals Health Insurance Coverage in 2013
Insured Uninsured
Persons Persons Persons
Sum PCT Sum PCT Sum PCT
Totals 313,395 100.0% 271,442 86.6% 41,953 13.4%
Educational Attainment 61,051 100.0% 56,745 92.9% 4,306 7.1%
Children under 15
No high school diploma 42,090 100.0% 33,143 78.7% 8,947 21.3%
High school or equivalent 71,145 100.0% 58,038 81.6% 13,107 18.4%
Some college, less than 4-yr degree 69,041 100.0% 59,105 85.6% 9,936 14.4%
Bachelor's degree or higher 70,068 100.0% 64,411 91.9% 5,657 8.1%

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

5. 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 Section 3, Statistics, 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 "Mean" (the default) from the "Statistics" selection box
    • Press the "Get Table" button at the bottom of the page
    • This creates the table below
CPS Data Collected in Year: 2014
Persons - All
The 2014 CPS ASEC included redesigned questions for income and health insurance coverage. The redesigned income questions were implemented to a subsample using a probability split panel design.
The source of data for this table is the portion of the CPS ASEC sample which received the income questions consistent with the 2013 CPS ASEC, approximately 68,000 addresses.

Totals Health Insurance Coverage
in 2013
Insured Uninsured
Family Income
in 2013
Family Income
in 2013
Family Income
in 2013
Mean Mean Mean
Totals 78,550 83,352 47,478
Educational Attainment 80,883 82,659 57,479
Children under 15
No high school diploma 58,132 63,770 37,247
High school or equivalent 58,095 61,711 42,083
Some college, less than 4-yr degree 73,052 77,268 47,971
Bachelor's degree or higher 114,970 119,123 67,677

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

6. Using a filter/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:
    • In the Filters/Subset section located at the top of the page, select "Maryland" from the "All States" drop-down menu (you can select up to five subsetting conditions for a table)
    • 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 bottom of the page
    • 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: 2014
Persons - All
The 2014 CPS ASEC included redesigned questions for income and health insurance coverage. The redesigned income questions were implemented to a subsample using a probability split panel design.
The source of data for this table is the portion of the CPS ASEC sample which received the income questions consistent with the 2013 CPS ASEC, approximately 68,000 addresses.

State: MD Totals Health Insurance Coverage
in 2013
Insured Uninsured
Family Income
in 2013
Family Income
in 2013
Family Income
in 2013
Mean Mean Mean
Totals 96,837 101,441 57,322
Educational Attainment 99,078 101,764 54,278
Children under 15
No high school diploma 68,841 76,269 40,497
High school or equivalent 67,152 69,181 55,128
Some college, less than 4-yr degree 85,570 88,806 62,304
Bachelor's degree or higher 133,849 137,422 76,578

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

7. Using an alternate pre-defined formatt  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
    • In section 4, Customized Formatting, 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 bottom of the page
    • 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: 2014
Persons - All
(Numbers in Thousands)
The 2014 CPS ASEC included redesigned questions for income and health insurance coverage. The redesigned income questions were implemented to a subsample using a probability split panel design.
The source of data for this table is the portion of the CPS ASEC sample which received the income questions consistent with the 2013 CPS ASEC, approximately 68,000 addresses.

Totals Sex
Male Female
Totals 74,055 37,716 36,338
Age 23,997 12,257 11,740
00 to 05
06 to 17 50,058 25,459 24,599

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

8. 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
    • In Section 4, Customized Formatting, under the "Age Ranges" section, select "Customize your own ranges by filling in the boxes below" from the drop-down menu
    • This will open the Age Range Minimum and Maximum section. 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 gaps in the age ranges are not allowed, 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 bottom of the page
    • 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: 2014
Persons - All
(Numbers in Thousands)
The 2014 CPS ASEC included redesigned questions for income and health insurance coverage. The redesigned income questions were implemented to a subsample using a probability split panel design.
The source of data for this table is the portion of the CPS ASEC sample which received the income questions consistent with the 2013 CPS ASEC, approximately 68,000 addresses.

Totals Sex
Male Female
Totals 86,202 43,905 42,297
Age 44,433 22,721 21,711
00 to 10
11 to 20 41,769 21,184 20,586

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


Source: U.S. Census Bureau | Current Population Survey (CPS) |  Last Revised: 2015-03-17T12:55:45-04:00