There
are two ways to locate a table on this site: using the table topics list (shown
below) or the search tables box (see Search Tables instructions).
For
example, to locate the table on hypertension, click on Chronic Conditions. A
list of table titles appears. The third table in the list below gives data on
hypertension prevalence in the United States.
By clicking on the information icon you
will see the explanatory notes for the table and the data source.
Another way to locate tables is to perform a search. You can use the search
tables box on the home page for Trends in Health and Agingor on the Table
screen after you click on any table topic.
Enter
one or more words in the search box in the upper right hand corner ofthe Tables screen and click the GO
button.
You
may perform a more specific search by using ‘AND’ between search words. You can
also enter two or more words separated by a space. Only those items that contain
all the words will be found.
A
list of table titles will appear. In some cases, the same table may be in
multiple folders and will therefore appear more than once in the search results
window. If you click the Show all Tables button you return to the main
listing of tables.
To
view a table, click on the table
title. In the example below, the table “Hypertension by Sex,
Race/Hispanic Origin, and Age, United States, Selected Years....” will be
opened.
Once you have opened a table, you are in the
table view, and you can browse through the data items in the table.
Browsing
through dimensions
To
browse through a dimension, for example “Sex”, click on either the forward or
backward arrow in
the dimension tile. The next category for “Sex” after “Both sexes” – “Male” --
isnow shown after clicking the forward arrow.
Rearranging dimensions
To
change the position of a dimension, for example to view the table by sex and
age, put your pointer over the grey shaded area of the desired dimension tile (“Sex”),a
cross symbol will
appear. Now click and slowly drag the “Sex” tile in place of the “Year” tile
until it turns yellow.
Drop the “Sex”
tile. Now the table shows prevalence of hypertension by
You can also change the table view using the
Actions
drop down menu on the upper left hand side of the table.
For
example, to change the view so that the estimates only for black non-Hispanic
male will be shown, click on the action menu and move the mouse down so that
Select Items to View is highlighted. An adjacent box appears with all the
available dimensions in the table. First, chose “Race/Hispanic origin”.
A window with the available race/Hispanic origin categories will appear.
By
default, “All races”, “Non-Hispanic White”, “Non-Hispanic Black”, and “Mexican
American” categories are shown in the table and all the boxes are checked. To
choose only “Non-Hispanic Black” in the table display, uncheck the “All races”,
“Non-Hispanic White”, and “Mexican American” boxes.
Next,
click on the age dimension tile that is shown under “Rows.” To choose only
65+(age-adjusted) age groups, uncheck all other age groups.
To
make additional selections, click on any remaining dimension. When you are
finished making selections for the table view, click on the table icon (located
next to the Actions menu button) to display the table with your custom
view.
To
return to the original display, click on the Actions button and choose Reset
Default View.
Some
numbers may be missing or appear with the footnotes. View the notes by pointing
your mouse on the number or on the cell with the missing value.
You
may also display your selections in a chart by clicking the chart icon located
next to the Actions menu button. For more information about charts, see
Making Charts.
Nesting
Beyond 20/20 allows users the option to change
the display of the data in the table by rows or columns; this is called nesting.
To nest rows, click on the grey shaded area of
the desired dimension tile (“Units”)and slowly drag it to the top or
bottom edge of the column labels (“Year”) until a heavy yellow line (or
highlight) appears. In this example, the “Units” dimension is selected by
clicking it, then dragged to the “Year” dimension tile in the Column tile:
When
the mouse is released, “Units” is nested inside the “Year” dimension. In this
table Units contain hypertension prevalence (percent) and measures
of sampling error.
Columns
can be nested in the same way as shown below, starting again with the default
table view.
After
the “Units” tile is dragged so that the yellow highlighted bar appears along the
row tiles (along the right-hand side of the “Age” dimension tile).
Release
the mouse and “Units” will be nested within the column “Age”:
Sorting
The data can be sorted in descending or ascending order by the values in column
you choose.
Click
on the appropriate arrow in the selected column to sort the data. For example,
to sort the rows in descending order according to the values in the column for
the year 1999-2002, click on the down arrow. The values are now arranged in
descending order with age group “75 and over”
the highest value:
To create a chart, click the chart icon next to
the Actions menu button. Charts will appear for all row categories. The
example below shows the prevalence of hypertension data based on the nested view
of the table by race, sex, and year:
You
can nest dimensions in the chart view just as in the table view by moving the
dimension tiles as shown above.
You
can make a chart larger by clicking on it. Below is shown the result for
clicking on the “All” race/Hispanic origin chart:
The
data shown in the chart can be customized in the following ways.
Click
on the underlined categories shown in the chart title on chart view as shown
above (e.g., “Age”, “Units”, or “Race”) OR
Click
on the Actions menu and choose Select Items to View as shown
below. Then select the dimension you wish to change
Either option
will display the following view in which you can choose categories to view. In
the example below, only the “Male” category is chosen. In the same way, you can
choose to show only “Non-Hispanic black” group by clicking on the Race/Hispanic
Origin dimension tile and checking the box next to “Non-Hispanic Black” category
and unchecking the boxes next to all other categories.
To view the chart
resulting from these selections, click on the chart icon next to the Actions
menu button:
The Actions
menu also provides other options. You may customize the chart type, size, and
choose to show data labels.
The
available chart types include pie, 3D pie, line, area, stacked bar, horizontal
stacked bar, 3D bar, grouped bar, and horizontal grouped bar. The default chart
is grouped bar.
The
available chart sizes are small, medium and large. The default chart size is
medium.
Users
may also choose to view or not view the data labels.
To print, click
Printable Version in the Actions menu. The customized table or
chart can now be printed without other page elements. Use your Internet
browser's Print command to print.
Each table contains a Help feature that will assist you in
manipulating and analyzing the data. Please e-mail
nha@cdc.gov if you
experience any problems.
More
options
If you are planning to use our data on a regular bases and
want to use mapping, statistical testing, better charting options, and access
tables off-line, use our free
Beyond 20/20 software.