Trends in Health and Aging
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.
Enter one or more words in the search box in the upper right hand corner of the 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” -- is now shown after clicking the forward arrow.
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
age and sex.
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.
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”:
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.
Tables can be copied into other applications, such as a word processor
or spread sheet.
Click on the Actions menu from table view and choose Download report data. Choose the format to download the table.
Each table contains a Help feature that will assist you in manipulating and analyzing the data. Please e-mail email@example.com if you experience any problems.