Example 3: Population by sex and age

In this example we will try to answer the following questions:

1. children of which gender are born more frequently?

2. does this gender ratio change with age?

To answer these questions we will make the following changes to the grid:

1. drag the "Age_group" field from the Field list into the row region

2. drag the "Year" and "Country" fields into the filters region

3. drag the "Sex" field from the Field list and the measures field to the measure fields region

4. exclude the values of '100+' and '5-9' from the values of the "Age_group" dimension

5. leave only 2006 in the "Year" dimension

6. leave only Russia in the "Country" dimension

These steps produce the following grid:

Just as previously, the raw data is less informative than a chart (though the figures may be important for printed reports), so let's switch to the chart page:

A chart makes it easy to answer our initial questions:

1. more boys are born than girls

2. however, from the age group 40-44 more women survive than men