250 likes | 266 Views
Discover the wealth of socioeconomic information available through E-Stat and CANSIM, learn how to access market insights, statistical reports, and census data to make informed business decisions. Gain insight into economic conditions, demographic profiles, and industry trends with these essential tools.
E N D
MGMT 230 Market/Industry Research: Finding Statistics Presented by: Christina Nilsen, Data Services Librarian Thompson Rivers University
Objectives • Introduction to E-Stat & CANSIM • Different ways to search for economic data in E-Stat / CANSIM • Understanding NAICS and NOC-S classifications used by Statistics Canada • Canadian Business Patterns (Beyond 20/20) • Where to find market share and industry overviews/reports • Business Source Complete • Industry Canada • Hoovers • Print sources • Other …
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
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
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/colleges via E-stat • CANSIM/E-stat data is updated annually in the summer • Contains over 42 million time series’
Topics covered by CANSIM • Aboriginal peoplesAgricultureBusiness performance and ownershipBusiness, consumer and property servicesChildren and youthConstructionCrime 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
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 country’s size and the characteristics of the people who live there.
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
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
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
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)
Sample E-Stat Problem #1 Identify the number of taxi operators in B.C., Alberta and Canada A few ways to search for CANSIM tables: • Search CANSIM in E-Stat by Survey • Look for a survey about taxis (table 407-0001) • Identify any related reports in the Daily • Try keyword searching CANSIM for “taxi”
Sample E-Stat Problem #2 Fleet management – trucking industry • How many commercial transports are on the road? • The largest companies, their size, revenues etc. • The number of owner/operators/brokers or individual operators
Sample E-Stat Problem #2 Fleet management – trucking industry • Search by survey: CANSIM in E-Stat • Trucking Commodity Origin and Destination Survey • Canadian Vehicle Survey • Number of Vehicles in Scope, by type of vehicle and type of activity, quarterly (table 405-0106)
Sample E-Stat Problem #2 Industry Reports • Industry Canada • Business Source Complete • Hoovers
Canadian Business Patterns • http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/cbp-sic-eng.htm • Provides counts of business and business establishments by: • employment size ranges • geography groupings: province/territory, census division, census subdivision, census metropolitan area and census agglomeration • industry using the North American Industry Classification NAICS • Data Liberation Initiative (DLI) product • Available for free, but only through institutional license • Must contact data librarian to access this (Christina Nilsen) • Works with Beyond 20/20, Statistics Canada’s free browser
Sample E-Stat Problem #3 cont. Identify the number of wheelchair users and manufacturers in B.C., Alberta, and Canada
Sample E-Stat Problem #3 cont. 2000/2001 Wheelchair users report: http://www.statcan.gc.ca/cgi-bin/af-fdr.cgi?l=eng&loc=http://www.statcan.gc.ca/studies-etudes/82-003/archive/2004/6848-eng.pdf&t=Use%20of%20wheelchairs%20and%20other%20mobility%20support%20devices
NAICS & NOC-S • NOC-S • Statistics Canada’s National Occupation Classification: http://stds.statcan.gc.ca/soc-cnp/2006/ts-rt-eng.asp?cretaria=h • NAICS: http://www.naics.com/ • Statistics Canada’s NAICS Codes Look-up • http://www.statcan.gc.ca/subjects-sujets/standard-norme/naics-scian/2007/index-indexe-eng.htm
E-Stat Output Formats CSV (comma separated values) PRN (tab separated values) DIF (data interchange format) WK1 …no longer compatible with Excel Flat File (one observation per record / tab delimited) SAS SPSS Beyond 20/20 Note that the existing instructions in the online E-stat guide are no longer valid, as the WK1 file extension is not recognized by MS Excel 2007 (It’s a Lotus file extension). Instead you have to use the CSV or PRN options (PRN spits out as .tab, tab separated)
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 Canada’s Illustrated Glossary for Census Geography http://geodepot.statcan.ca/2006/180506051805140305/03150707/0914040524_05-eng.jsp Reference Maps (Census / Geography / Reference Maps)
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.
How to Cite Statistics Canada Products Statistics Canada’s Guide: How to cite Statistics Canada products • http://www.statcan.gc.ca/pub/12-591-x/2006001/4113853-eng.htm • http://www.statcan.gc.ca.ezproxy.tru.ca/pub/12-591-x/2009001/02-step-etape/ex/ex-estat-eng.htm CANSIM Table Example: • Statistics Canada. No date. Table 477-0013 University enrolments, by registration status, program level, Classification of Instructional Programs, Primary Grouping (CIP_PG) and sex, annual (number), Monthly (table). CANSIM (database). Using E-STAT (distributor). Last updated March 2010. http://tinyurl.com/2893za3 (accessed November 2, 2010). CENSUS Table Example • Statistics Canada. No date. 2006 Census of Population (48 Census Metropolitan Areas/Census Agglomerations and Census Tracts) (table). 2006 Census of Canada (2006 Cumulative Profile, Kamloops (27 Census tracts) (database). Using E-STAT (distributor). Last updated 2006. http://tinyurl.com/2ezkp6x(accessed November 2, 2010). SFU Library Guide to Citing Statistics: http://www.lib.sfu.ca/help/writing/citing-statistics
TRU Library – E-Stat Libguide • http://libguides.tru.ca/estat