)/cmu-logo.jpg "Carnegie Mellon"){kind=logo}
Tutorial 6: Changing the Output Display
So far in all the tutorials, the outputs have been shown in MicroMorts (chance in a million of dying). However, the web site allows for the display of other output metrics. This tutorial explains the available options. Throughout this tutorial, a search comparing causes of death between US and European 50-59 year old males will be used to demonstrate the options. The details of the search parameters for this search are in Figure 6-1.
)/images/figure61.jpg "Figure 6-1")
Figure 6-1: Details of the input search parameters
After the search has been completed, the Display Option box, which is next to the Search Parameter summary, controls the output metrics and display characteristics (see Figure 6-2).
)/images/figure62.jpg "Figure 6-2")
Figure 6-2: Display options
The output table with the default MicroMorts metric is shown in Figure 6-3. The output shows that for 50-59 year old males, the risk of dying in the next year is higher for Europeans
)/images/figure63.jpg "Figure 6-3")
Figure 6-3: Output table in MicroMorts
Just by scanning the output table, it may be hard to determine which causes lead to this difference. However, by single clicking on the United States (or Europe) title, the table can be sorted from high to low or low to high for that column (see Figure 6.4). The sort shows that there is essentially no difference in the circulatory system risk, but there are large differences in cancer risks. Follow-on queries could investigate whether this difference between US and Europeans holds for women, other age categories, sub-regions/states/countries, and specific types of cancers.
The following Display Options are available:
- Table or Graph: Some of the output tables allow for graphical displays. The graphs use default settings that may not be the most useful. For more sophisticated graphs, we recommend that you export the output data to Excel to facilitate custom tailoring of your graphics. Export options are discussed later in this tutorial.
- Language: Simple or Technical: This function enables the user to display certain parts the output to professional terms found in the ICD 10 (see Figure 6.5). The results of selecting technical terminology can be seen in Figure 6-6.
)/images/figure64.jpg "Figure 6-4")
Figure 6-4: Output table in MicroMorts sorted by causes in the US
- Expanding categories: This allows the Primary Comparison categories (shown on the left side of the table) to be shown in greater detail. For example, the 21 “Cause of Death” categories can be expanded to 66 categories (see Figure 6-7). The 10-year age categories can be expanded to individual ages, regions in the US can be expanded to individual states, and regions in Europe can be expanded to individual countries. Step 2: Secondary Comparison categories cannot be expanded.
- Pick a metric to display: Using this option, the default output metric, MicroMorts can be changed to percentages (see Figure 6-8), number of deaths (see Figure 6-9 and 10), and population (see Figure 6-11).
)/images/figure65.jpg "Figure 6-5")
Figure 6-5: Output table in MicroMorts
)/images/figure66.jpg "Figure 6-6")
Figure 6-6: Technical language
)/images/figure67a.jpg "Figure 6-7")
...
)/images/figure67b.jpg "Figure 6-7")
Figure 6-7: Expanding categories
)/images/figure68.jpg "Figure 6-8")
Figure 6-8: Percent of MicroMorts assigned to each cause
)/images/figure69.jpg "Figure 6-9")
Figure 6-9: Output in Expected # of Deaths in a Year
)/images/figure610.jpg "Figure 6-10")
Figure 6-10: Sorting with different units of measure
- Export to Excel: All output tables can be exported to Microsoft Excel. This allows for additional comparisons to be made, search results to be archived, and graphs to be produced. Just above and to the right of the output table is the Export button. Selecting it will lead to a pop-up window (see Figure 6-11).
)/images/figure611.jpg "Figure 6-11")
Figure 6-11: Exporting information to excel