Current Population Survey (CPS) Table Creator For the Annual Social and Economic Supplement

Detailed Examples Subsets Define Your Table Variables Statistics Related Sites

Statistics

• The available statistics are cell sums, percentages for a variable in the table, unweighted record counts, and, for one addional numeric variable, one or more of the statistics from the list of mean (average), minimum value, maximum value, and sum.
• You must include at least one statistic, but within this constraint, you can include any combination of the available statistics.

Row or Column Display of Statistics

• You can control whether you want the statistics displayed as rows or as columns. Columns are generally easier to read, but, for many variables, may make a table very wide, forcing the table to be parsed into sections.
• The system defaults to column display of statistics.
• If the table structure has rows, but no columns, the statistics will be displayed in columns no matter what you select for this field. All other combinations should display as you request.
• If the ONLY statistic requested is SUMs, column display produces a more attractive table than row display.

Sums

• The sum is a weighted count of the persons, families, or households in the cell.

Percentages

• If you include a percentage variable, the variable MUST have been selected for a row or a column variable (not a page variable).
• The percentage variable can be any nested row or column variable or the concatenated variable when only one concatenated variable (for a row or column) has been selected.
• If the table has multiple concatenated row (or column) variables, none of those variables may be used as a percentage variable since the table cells for the other concatenated variables will have no relationship to the percent variable.
• The percentages can be displayed as columns (the default) or as rows in the table. However, if your table has column variables only, you may not display percentages in rows.
• You may display percentages with zero (the default), one, or two decimal places.
• The percentage variable is displayed in the table's title.

Unweighted Record Counts

• The unweighted record count provides the number of records on the Current Population Survey input files contributing to these data.

Additional Numeric Variable Statistics

• The statistics currently available are mean (or average), minimum, maximum, and sum.
• No more than one additional variable can be included in a table.
• You may select one or more statistics for the selected variable. For multiple selections, the usual rules for window applications apply. Hold down the shift key and use the up- and down-arrows to select consective choices. Or hold down the control key and use the mouse to select any combination of choices. The statistics in the table will be listed in the order they appear in the selection lists, not the order in which you select them.
• The number of decimals you choose to display will apply to ALL additional statistics you select.

Census Bureau Links:   Home · Census 2000 · Subjects A to Z · Search · Data Tools · Catalog · Quality · Privacy Policy · Policies · FOIA · Contact Us