Combining multiple census characteristics and mapping the result
(2006 Census of Population)

When working with statistics, it may be desirable to combine existing characteristics to achieve the desired results. E-STAT lets us extract detailed data for selected geographic areas in Canada using data from the censuses of population, and then tabulate, manipulate, graph or map the results. This specific activity demonstrates one type of manipulation - how to sum selected characteristics to form a new variable. In this case we first select the population for the three age groups under 15 for each gender, and then sum these six characteristics to produce a new variable, the total population under the age of 15. Next, we show how to map this new variable, change the map title, and save the resulting map to a word processing document.

See How-To - User guide for the Search Census module for more help.

From the E-STAT sidebar, select Search Censuses.

How to find a Census table using Search Censuses

• Under Select a Census, choose 2006 Census.
• At the Database selection page, choose 2006 Census of Population (Provinces, Census Divisions, Municipalities).
• At the Profile selection page, choose 2006 Population by age group and sex.

How to select a geography

• Under Geography, select 2006 - Provinces and Territories in Canada (default selection) from the drop down list.

How to select a characteristic

• Under Characteristics, select the following;
  • Male, 0 to 4 years
  • Male, 5 to 9 years
  • Male, 10 to 14 years
  • Female, 0 to 4 years
  • Female, 5 to 9 years
  • Female, 10 to 14 year

• Choose Table Areas as Rows for the output format.

Characteristics summing

• Click Sum starting with the 1^st characteristic in order to create a sub total to group all the ages 0 - 14.

• Select the Map icon at the bottom of the screen to view the result.

This generates a proportional circle map, showing population for the selected group.

How to specify your title for a map

• Click the Map titles tab.
• Write a title in the box. For example: 2006 Census of Population - 0 to 14 years of age for Canada.

How to copy and paste a graph or map

• You can copy the map into a word processing document.