1 / 63

Getting to Know Data Sources

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

muncel
Download Presentation

Getting to Know Data Sources

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Getting to Know Data Sources SOC 3140 Prof. Sylvie Lafrenière Susan Mowers, GSG / Library

  2. 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

  3. Library:Doors to Research and Data

  4. 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

  5. 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

  6. More about Data …

  7. 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

  8. Surveys … one example of Survey Data

  9. 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

  10. GEG3104

  11. 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

  12. IT ALL COMES FROM THE QUESTIONS!2006 Census– SHORT (2A) and LONG (2B) Questionnaires,on, e.g., family relationship … etc. GEG3104

  13. 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

  14. Getting a Handle on Surveys : Who’s in the GSS 18?

  15. 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

  16. Possible special population groups GEG3104

  17. 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

  18. 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

  19. 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

  20. 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

  21. Can you compare religious discrimination before and after 9/11? GEG3104

  22. SAMPLE SIZES FOR… Visible minority status / Religion DO THEY WARRANT STUDY?

  23. GSS 18 Data Dictionary http://gsg.uottawa.ca/data/teaching/soc/version2-12M0018-GPE-Data-dictionary-main.pdfon visible minority status GEG3104

  24. GSS 18 Data Dictionary http://gsg.uottawa.ca/data/teaching/soc/version2-12M0018-GPE-Data-dictionary-main.pdfDiscrimination … related to visible minority status … GEG3104

  25. …is often considered to be 2,000 A significant sample size GEG3104

  26. 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

  27. GSS 18 Data Dictionary http://gsg.uottawa.ca/data/teaching/soc/version2-12M0018-GPE-Data-dictionary-main.pdfDiscrimination related to Religion GEG3104

  28. What is this difference between the two columns …? GEG3104

  29. From WEIGHTS and MEASURES Author: Wendy Watkins, Carleton University DLI, Guelph (2000)

  30. 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

  31. 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

  32. SPSS hands-on exercise Differentiating weighted and unweighted results?

  33. Unweighted results – Let’s weight these… GEG3104

  34. Again, we look for the weight variable in the Dictionary for our variables, e.g., WGHT-PER for DIS-REL GEG3104

  35. 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

  36. 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

  37. Lets tabulate some variables (our results will be weighted) … GEG3104

  38. Cross tabulating our 4 variables in SPSS • Click on Analyse and Descriptive Statistics: • Then click on Cross-tabs … GEG3104

  39. Cross-tabulating cont’d 3. Scroll down until you arrive here (you will start by selecting these three variables) GEG3104

  40. 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

  41. 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

  42. 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

  43. You are ready to cross-tabulate your weighted results! 8. Click on “OK” GEG3104

  44. Weighted tabulations ! GEG3104

  45. Basic documentation checklistfor the GSS 18 For your reference…

  46. 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

  47. Other surveys

  48. 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

  49. 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

  50. Browse surveys available from STC DLI • All are DLI surveys comprise cross-sectional survey data • Browse collection of surveys from DLI -click here GEG3104

More Related