ECON3610 E-STAT

1
ECON3610E-STAT

• Presented by Christina Nilsen, Data Services
  Librarian
• Thompson Rivers University

2
What is E-Stat?

• Statistics Canada product
• Provides access to socio-economic data about
  Canada (from CANSIM)
• Free, online, interactive tool
• Only available to educational institutions
• Provides access to Census data population
  agricultural censuses

3
Why Use E-Stat?

• Some of the reasons why you might use E-Stat
• To make investment decisions
• To evaluate social conditions
• To conduct feasibility studies
• To conduct market analyses
• To forecast economic conditions
• To plan programs or services
• To profile demographics

4
What is CANSIM?

• Canadian Socioeconomic Information Management
  System
• Statistics Canada product
• Database of social and economic data about Canada
  and Canadian life
• Different tiers of service
• Fee-based commercial service
• Institutional subscription to universities/college
  s via E-stat
• CANSIM/E-stat data is updated annually in the
  summer
• Contains over 42 million time series

5
Topics covered by CANSIM

• Aboriginal peoplesAgricultureBusiness
  performance and ownershipBusiness, consumer and
  property servicesChildren and youthConstruction
  Crime and justiceCulture and leisureEconomics
  accountsEducation, training and learning
  EnergyEnvironmentEthnic diversity and
  immigrationFamilies, households and
  housingGovernmentHealthIncomes, pensions,
  spending and wealthInformation and communication
  technologyInternational tradeLabour
• LanguagesManufacturingPopulation and
  demographyPrices and price indexesRetail and
  wholesaleScience and technologySeniorsSociety
  and communityTransportationTravel and tourism

6
About the Census

• What is a census?
• An official count of the citizens who live in a
  particular country. It is used to get an
  accurate picture of a countrys size and the
  characteristics of the people who live there.

7
About the Census

• What is the purpose of the census in Canada?
• To adjust federal electoral districts (for seats
  in Parliament)
• To help determine federal transfer payments
• To help determine government programs and
  services, including health-care, education,
  transportation
• To assist in social and economic research

8
About the Census

• 1871-1981 - census was conducted every ten years
• 1981- today - census conducted every five years
• Did you know?
• The census is always conducted on the second
  Tuesday in May. Why? Need to balance between
  unfavourable weather, poor road conditions,
  accurate crop acreage, summer holidays, people
  moving in June

9
About the Census

• Census of Population Two questionnaires
• Everyone answers 10 questions in 2011
• http//www.gazette.gc.ca/rp-pr/p1/2010/2010-08-21/
  html/order-decret-eng.html
• National Voluntary Household Survey
  (distributed to 4.5 million households)
• http//www.statcan.gc.ca/survey-enquete/household-
  menages/5178-eng.htm
• Long-form Census Questionnaire Controversy
• On June 26, 2010, Tony Clement, Minister of
  Industry, announced that the voluntary National
  Household Survey (NHS) would replace the
  mandatory long-form census questionnaire in
  Canada.   The government's decision has fueled a
  heated debate between those who view the
  previously mandatory long-form questionnaire as
  an invasion of privacy, and those who see it as
  an important source of information essential to
  public policy, research and business

10
About the Census

• Census Questions Change a few examples
• Head of household
• Until 1976 head of household was defined as the
  husband, but in 1981 it was dropped entirely
• Infirmities
• Until 1911, respondents were asked to disclose
  whether members of their household were bind,
  deaf and dumb, insane or simple minded
• Common law relationships (since 1991)
• Housework (since 1996)
• Same sex common law couples (since 2001)

11
Sample E-Stat Problem
How much unpaid housework do men versus women
perform in Canada?
12
Sample Question from 2006 Census

• 33. Last week, how many hours did this person
  spend doing the following activities        
• doing unpaid housework, yard work or home
  maintenance for members of this household, or
  others?              
• Some examples include preparing meals,
  washing the car, doing laundry, cutting the
  grass, shopping, household planning, etc.        
       
• None              
• Less than 5 hours              
• 5 to 14 hours              
• 15 to 29 hours              
• 30 to 59 hours              
• 60 hours or more

13
Locating Census Data Using E-STAT
14
1. Click on Statistical Sources on the TRU
Library Homepage
15
2. Click on E-STAT on the TRU Librarys
Statistical Sources page
16
3. Click on Search Censuses in E-STAT
17
4. Select 2006 Census and click Go
18
5. Select 2006 Census of Population (Provinces,
Census Divisions, Municipalities) and click Go
19
6. Select 2006 Cumulative Profile and click Go
20
7. Select 2006 Canada, Provinces and
Territories (1) as the Geographic Region
21
8. Click on View checklist to select multiple
characteristics
22
9. Scroll down to locate the variables that you
need
23
10. Check off the variables that you want
24
11. Scroll down to the bottom of the screen and
click on Return to selection page
25
12. Scroll down and click on Reduce or sort geo
list
26
13. Select Canada to limit your geographic
area and then scroll down
27
14. Select HTML Table (GeographyColumns) and
then click Go
28
15. Review results and then change the display to
be percentages instead of actual data
29
16. The information is now displayed as
percentage ()
30
17. Scroll down and change your screen output to
a Pie Chart
31
18. Data displayed as a pie chart
32
Using CANSIM
33
Sample E-Stat Problem
What are the labour force participation rates by
gender in Canada over time?
34
1. Click on Statistical Sources on the TRU
Library Homepage
35
2. Click on E-STAT on the TRU Librarys
Statistical Sources page
36
3. Click on Search CANSIM in E-STAT
37
4. Type Labour force participation rate in
search box to locate tables. Then click on the
Search button.
38
5. Select Table 282-0001 for labour force
participation rates by sex.
39
6. Make selections from the pick lists available
(geography, labour force characteristics, gender
etc.).
40
6. Make selections from the pick lists available
(geography, labour force characteristics, gender
etc.).
41
6. Click retrieve as a table (button located at
bottom of screen)
42
6. Select output specifications then click
retrieve now
43
6. View your results
44
Census Geography

• Census Metropolitan Area (CMA) Census
  Agglomeration (CA)
• Area consisting of one or more neighbouring
  municipalities situated around a major urban
  core. A census metropolitan area must have a
  total population of at least 100,000 of which
  50,000 or more live in the urban core. A census
  agglomeration must have an urban core population
  of at least 10,000.
• Statistics Canadas Illustrated Glossary for
  Census Geography
• http//geodepot.statcan.ca/2006/180506051805140305
  /03150707/0914040524_05-eng.jsp
• Reference Maps (Census / Geography / Reference
  Maps)

45
Census Geography

• Census Subdivision
• Area that is a municipality or an area that is
  deemed to be equivalent to a municipality for
  statistical reporting purposes (e.g., as an
  Indian reserve or an unorganized territory).
  Municipal status is defined by laws in effect in
  each province and territory in Canada.
• Census Tract
• Area that is small and relatively stable. Census
  tracts usually have a population of 2,500 to
  8,000. They are located in large urban centres
  that must have an urban core population of 50,000
  or more.

46
Additional Information

• TRU Library Research Guides
• Business Economic Statistics (Includes ECON3610
  Course Guide) http//libguides.tru.ca/businesssta
  ts
• Census in Canada http//libguides.tru.ca/censusca
  nada
• E-Stat - Retrieving data from the 2006 Census
  http//libguides.tru.ca/e-stat
• How to Cite Census Products http//libguides.tru.
  ca/content.php?pid198232sid1849860
• TRU Library Data Services http//www.tru.ca/libra
  ry/faculty/faculty_data.html
• Other
• Stats Canada census data http//www12.statcan.gc.c
  a/census-recensement/index-eng.cfm
• Stats Canada Geography Reference Products
  Illustrated Glossary http//geodepot.statcan.ca/2
  006/180506051805140305/03150707/0914040524_05-eng.
  jsp
• About the Data Liberation Initiative (DLI)
  http//www.statcan.gc.ca/dli-ild/about-apropos-eng
  .htm
•  
•