Modifying a frequency table
A frequency table shows the numbers and proportions of 'individuals' in various categories. There are a few ways in which such tables can be modified, either to make the information clearer or to highlight particular aspects.
Alphabetic ordering of the categories is rarely best.
The frequency for a combined category is the sum of the frequencies for the categories that are being merged. The percentages are also added.
The frequencies for the categories are unchanged, but the percentages should divide them by the total for the displayed categories, so they still add to 100%.
These techniques will be clearer in an example.
Road crashes by road feature
The table below shows the number of road crashes causing injury or death in New Zealand in 2005, categorised by the type of 'road feature' at the crash site.
The 'road features' were grouped into Intersections and Non-intersections in the report and are shown in different colours in the table. However the ordering of categories within the groups in the report was not particularly meaningful. Click the two checkboxes Sort by frequency to reorder the features by their frequency of accidents within each group.
Click the checkboxes Combine categories to combine the different types of intersections and non-intersections into a frequency table with two rows. This table highlights the differences between intersections and non-intersections.
Finally, expand the categories for Intersections and click Hide categories for the Non-intersections. This shows the distribution of road features for the accidents that occurred at intersections. Note that hiding the non-intersection categories restricts attention to the accidents that occurred at intersections. The total therefore changes to the number of accidents at intersections and the percentages become percentages out of this new total.