630 likes | 768 Vues
Getting to Know Data Sources. SOC 3140 Prof. Sylvie Lafrenière Susan Mowers, GSG / Library. Outline. Doors to sociology research at the Library Sociology Librarian, research expertise GSG Centre, access to Data Getting a handle on Statistics Canada surveys From Data to Statistics
E N D
Getting to Know Data Sources SOC 3140 Prof. Sylvie Lafrenière Susan Mowers, GSG / Library
Outline • Doors to sociology research at the Library • Sociology Librarian, research expertise • GSG Centre, access to Data • Getting a handle on Statistics Canada surveys • From Data to Statistics • Using data tools and documentation GEG3104
Sociology Librarian Research expert Andrée Côté • Available for appointments • 613-562-5800 (3656) • Andree.Cote@uottawa.ca • Morisset, first floor • EXPERTISE! Using the Library collections, databases and services for sociology GEG3104
Additional Services GSG • Geographic Statistical and Government INFORMATION CENTRE • GSG helps students to find, access and use: • Data, statistics, geographic and government information, including • DLI and other data • Technical support for using data • Services on site, lab, statistical and GIS software • Hard-to-find government information • Contact Susan: Morisset Library, Room 308 in person smowers@uottawa.caby email GEG3104
DATA DATA DATA!! VIA Data Liberation Initiative DLI: partnership between 74 Canadian universities + Statistics Canada. …students can access all DLI datathrough GSG (3rd floor Morisset) and Web - person-level public-use microdata, - statistics at a detailed level of geography, time series data, - and Geographic data DLI contact: Susan… smowers@uottawa.ca … Commercial use is strictly prohibited. GEG3104
Survey Question … STATISTICS CANADA’S NUMÉRO UNO (BIGGEST) SURVEY ! … it’s “so big”, it can only happen every 5 years! … What is this survey called ? GEG3104
From your mailbox: May 16, 2006 … to statistics in the media September 13, 2007 Married people now in the minority; For the first time in Canada, most adults are not legally wed, census shows. …more people are choosing common law over marriage. …Public-use microdata to be releasedSummer 2009 The 2006 Census of Population GEG3104
IT ALL COMES FROM THE QUESTIONS!2006 Census– SHORT (2A) and LONG (2B) Questionnaires,on, e.g., family relationship … etc. GEG3104
Want more information on the Census? • Survey page on the Census at Statistics Canada http://www12.statcan.ca/english/census/index.cfm • Main CENSUS page at Statistics Canada http://www.statcan.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=3901&lang=en&db=IMDB&dbg=f&adm=8&dis=2 GEG3104
What special groups of interest might there be in the GSS 18 ? Click on Statistics Canada – Main survey page below: http://www.statcan.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=4504&lang=en&db=IMDB&dbg=f&adm=8&dis=2 GEG3104
IT ALL COMES FROM THE QUESTIONS!GSS 18 Questionnaire …http://gsg.uottawa.ca/data/teaching/soc/version2-12M0018-GPE-questionniare.pdffor example, Visible Minority Status GEG3104
IT ALL COMES FROM THE QUESTIONS!GSS 18 Questionnaire …http://gsg.uottawa.ca/data/teaching/soc/version2-12M0018-GPE-questionniare.pdffor example, Discrimination related to Visible Minority Status GEG3104
IT ALL COMES FROM THE QUESTIONS!GSS 18 Questionnaire …http://gsg.uottawa.ca/data/teaching/soc/version2-12M0018-GPE-questionniare.pdffor example, Discrimination based on Religion GEG3104
Given the question on Discrimination based on Religion in the GSS 18 (2004)… FIND OUT: Should you be able to confirm whether discrimination based on religion increased after September 11, 2001? Click on: http://gsg.uottawa.ca/data/teaching/soc/version2-12M0018-GPE-Comparison Victimization cycles.pdf Go to page 30 (page 394 at bottom of page) GEG3104
Can you compare religious discrimination before and after 9/11? GEG3104
SAMPLE SIZES FOR… Visible minority status / Religion DO THEY WARRANT STUDY?
GSS 18 Data Dictionary http://gsg.uottawa.ca/data/teaching/soc/version2-12M0018-GPE-Data-dictionary-main.pdfon visible minority status GEG3104
GSS 18 Data Dictionary http://gsg.uottawa.ca/data/teaching/soc/version2-12M0018-GPE-Data-dictionary-main.pdfDiscrimination … related to visible minority status … GEG3104
…is often considered to be 2,000 A significant sample size GEG3104
GSS 18 Data Dictionary http://gsg.uottawa.ca/data/teaching/soc/version2-12M0018-GPE-Data-dictionary-main.pdfon religion: e.g., other “including” Muslim …? GEG3104
GSS 18 Data Dictionary http://gsg.uottawa.ca/data/teaching/soc/version2-12M0018-GPE-Data-dictionary-main.pdfDiscrimination related to Religion GEG3104
From WEIGHTS and MEASURES Author: Wendy Watkins, Carleton University DLI, Guelph (2000)
Why are Weights Used? • Data are often collected in a disproportionate manner • E.g., A greater percentage of the population are interviewed in PEI than Ontario • Weighting adjusts for this bias • Each weighted observation represents one observation in the population • Weighting important for academic research (journal pubn…) Author: W. Watkins, 2000 GEG3104
How does SPSS Apply Weights? • SPSS has a simple procedure for applying weights • Open our data file: • Click on: https://login.proxy.bib.uottawa.ca/login?url=http://gsg.uottawa.ca/data-license/gss_general_social_survey/c18-victimisation-2004/eng/data/gss18pumfm-3142-class-only.sav • Click on : “Data” • Click on “Weight cases by” • Choose appropriate weight variable (read documentation) • Click “OK” Author: W. Watkins, 2000 GEG3104
SPSS hands-on exercise Differentiating weighted and unweighted results?
Again, we look for the weight variable in the Dictionary for our variables, e.g., WGHT-PER for DIS-REL GEG3104
WE WILL turn on our PERSON WEIGHT variable and then run our tabulations for VISIBLE MINORITY STATUS 1. Ensure you have opened the GSS18 dataset at: https://login.proxy.bib.uottawa.ca/login?url=http://gsg.uottawa.ca/data-license/gss_general_social_survey/c18-victimisation-2004/eng/data/gss18pumfm-3142-class-only.sav 2. Click on Data and … Weight Cases … GEG3104
Finish turning weighting on… 3. Click on Person weight and tick circle “Weight cases by” 4. Click on the arrow 5. ..and click on “OK” GEG3104
Lets tabulate some variables (our results will be weighted) … GEG3104
Cross tabulating our 4 variables in SPSS • Click on Analyse and Descriptive Statistics: • Then click on Cross-tabs … GEG3104
Cross-tabulating cont’d 3. Scroll down until you arrive here (you will start by selecting these three variables) GEG3104
Cross-tabulating cont’d 4. Click on the variable below and click on arrow for Row(s), we will continue on for the next two variables below.. GEG3104
Cross-tabulating cont’d 5. Select the next variable below as shown, click on the same arrow (Row(s)) and do the same for the next variable below. GEG3104
Cross-tabulating cont’d 6.Three variables will appear in the Rows box. 7. Click on Visible minority status (just above), then click on the arrow for Column(s) GEG3104
You are ready to cross-tabulate your weighted results! 8. Click on “OK” GEG3104
Weighted tabulations ! GEG3104
Basic documentation checklistfor the GSS 18 For your reference…
GSS 18 Documentation Checklist Statistics Canada – Main survey page on the GSS 18:http://www.statcan.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=4504&lang=en&db=IMDB&dbg=f&adm=8&dis=2 Complete Users Guide to the GSS 18 survey and data:http://gsg.uottawa.ca/data/teaching/soc/version2-12M0018-GPE.pdf includes questionnaire, data dictionaries, survey, sampling and weighting methodology, comparison of content of cycles 3, 8, 23, and 18 … Comparison of cycles: http://gsg.uottawa.ca/data/teaching/soc/version2-12M0018-GPE-Comparison Victimization cycles.pdf Data Dictionary: http://gsg.uottawa.ca/data/teaching/soc/version2-12M0018-GPE-Data-dictionary-main.pdf Questionnaire: http://gsg.uottawa.ca/data/teaching/soc/version2-12M0018-GPE-questionniare.pdf GEG3104
Some Statistics Canada Surveys of Households • Census every 5 years • Special Surveys, various health, labour force, longitudinal survey of children and youth… • Post-censal surveys, every 5 or 10 years : Aboriginal Peoples Survey; Ethnic Diversity Survey; Participation and Activity Limitations Survey GEG3104
Health DivisionCanadian Community Health Survey (CCHS) • Collects information related to health and health determinants for the Canadian population. Over 130,000 responses cycles 1.1, 2.1, 3.1… • Special topics, e.g., 1.2 content, Mental Health and Well-being GEG3104
Browse surveys available from STC DLI • All are DLI surveys comprise cross-sectional survey data • Browse collection of surveys from DLI -click here GEG3104