Skip to content

Skip to looking for section

Examples

Component ID: #ti894968991

  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 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 top or bottom of the form.
    • this creates the table below
CPS Data Collected in Year: 2011
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 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 54,605 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


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: 2011
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 2010
Insured Uninsured
Totals Totals 306,110 256,206 49,904
Sex 150,643 123,735 26,908
Male
Female 155,466 132,470 22,996
Educational Attainment
62,155 56,386 5,769
Children under 15 Totals
Sex 31,773 28,797 2,976
Male
Female 30,382 27,589 2,793
No high school diploma Totals 43,303 32,115 11,188
Sex 22,186 15,936 6,249
Male
Female 21,117 16,179 4,939
High school or equivalent Totals 70,476 54,556 15,920
Sex 35,164 26,103 9,061
Male
Female 35,312 28,452 6,859
Some college, less than 4-yr degree Totals 65,979 54,605 11,375
Sex 30,351 24,689 5,663
Male
Female 35,628 29,916 5,712
Bachelor's degree or higher Totals 64,196 58,544 5,652
Sex 31,170 28,210 2,960
Male
Female 33,027 30,334 2,693


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


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: 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 54,605 11,375
Bachelor's degree or higher 64,196 58,544 5,652
Sex 150,643 123,735 26,908
Male
Female 155,466 132,470 22,996


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


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
    • 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
    • Also in Section 3, Statistics, select “One Decimal” from the “Percentages by” 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
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 2010
Insured Uninsured
Persons Persons Persons
Sum PCT Sum PCT Sum PCT
Totals 306,110 100.0% 256,206 83.7% 49,904 16.3%
Educational Attainment 62,155 100.0% 56,386 90.7% 5,769 9.3%
Children under 15
No high school diploma 43,303 100.0% 32,115 74.2% 11,188 25.8%
High school or equivalent 70,476 100.0% 54,556 77.4% 15,920 22.6%
Some college, less than 4-yr degree 65,979 100.0% 54,605 82.8% 11,375 17.2%
Bachelor's degree or higher 64,196 100.0% 58,544 91.2% 5,652 8.8%


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


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 “No” from the “Display the default sums” 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 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 2010
Insured Uninsured
Family Income in 2010 Family Income in 2010 Family Income in 2010
Mean Mean Mean
Totals 72,568 78,302 43,133
Educational Attainment 72,950 75,702 46,050
Children under 15
No high school diploma 52,373 58,872 33,716
High school or equivalent 55,393 59,885 39,999
Some college, less than 4-yr degree 69,400 74,596 44,457
Bachelor's degree or higher 107,933 112,082 64,962


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


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.
    • 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)
    • 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: 2011
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 2010
Insured Uninsured
Totals 5,727 4,979 760
Educational Attainment 1,124 1,012 85
Children under 15
No high school diploma 685 537 231
High school or equivalent 1,254 1,030 224
Some college, less than 4-yr degree 1,110 959 151
Bachelor's degree or higher 1,553 1,442 112


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


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
    • 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: 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 Sex
Male Female
Totals 74,916 38,343 36,573
Age 25,555 13,066 12,489
00 to 05
06 to 17 49,361 25,277 24,084


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


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 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: 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 Sex
Male Female
Totals 87,431 44,720 42,711
Age 46,228 23,600 22,628
00 to 10
11 to 20 41,202 21,120 20,083


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

X
  Is this page helpful?
Thumbs Up Image Yes    Thumbs Down Image No
X
No, thanks
255 characters remaining
X
Thank you for your feedback.
Comments or suggestions?