Journeys in Survey Research

  • Welcome
  • ​​Important notice
  • About the author
    • John F Hall: Career profile
    • John F Hall: Extra-curricular professional and political activities
  • About this site
    • What people have said about this site
    • Latest additions and modifications
    • How to use this site
  • Site guide + Search box
  • Dedications
  • Acknowledgments
    • Unsung heroes in support services
  • My personal pantheon (of the great and the good in survey research)
    • Mark Abrams >
      • Abrams publications
      • An interview with Mark Abrams (transcripts)
      • An interview with Mark Abrams (audio files)
      • Mark Abrams Prize
    • Angus Campbell >
      • SRU garden reception for Angus Campbell
    • Cathie Marsh
    • Tony Coxon
    • Roger Jowell
    • James A Davis
    • Norman Nie
  • Recent and planned activities
  • Textbooks for Research Methods and Data Analysis
    • Textbooks: SPSS >
      • Highly recommended SPSS textbooks >
        • McInnes (2017) >
          • MacInnes, Chapter 4:​ Getting Started with SPSS
          • MacInnes, Chapter 5 Dealing with Data Documentation
          • MacInness 2017 (Web links)
        • Marsh and Elliott (2008)
        • Sweet and Grace-Martin 2012
        • Babbie, Halley, Wagner and Zaino 2013
        • Babbie, Wagner and Zaino 2019
        • Julie Pallant, SPSS Survival Manual
        • Andy Field
        • Boslaugh 2005
        • McCormick & Salcedo (2015)
        • McCormick & Salcedo (2017)
      • SPSS textbooks worth a look >
        • Hy (1977)
      • On-line SPSS textbooks
      • Textbooks requested or awaiting review
    • Textbooks: Statistics for Social Research >
      • de Vries 2018
      • Bergin (2018)
    • Textbooks: Survey Methods >
      • Crouch & Housden (2003)
      • Andres (2012)
      • Blair, Czala and Blair (2014)
      • de Vaus (2014)
      • Hoinville, Jowell et al (1977)
      • Marsden & Wright [Eds] (2010) >
        • Contributors to Handbook of Survey Research
      • Marsh (1982)
      • Moser & Kalton (1971)
      • Oppenheim (1992)
      • Pallant 2016
    • Textbooks: Data curation and sharing >
      • Corti et el (2014)
  • 1: Survey Analysis Workshop (SPSS)
    • What is SPSS?
    • SPSS Without Tears >
      • My first time: in at the SPSS deep end (1972)
    • Introduction to Survey Analysis Workshop (SPSS) >
      • IBM® SPSS® Statistics (Overview)
      • Note on SPSS tutorials on this site
      • Background to current project >
        • Author's note
      • SPSS versions used
      • Stata and SPSS
    • Summary guide to SPSS tutorials >
      • Block 1: From questionnaire to SPSS saved file
      • Block 2: Analysing one variable >
        • 2.1: Nominal and ordinal variables
        • 2.2: Interval scale variables
        • 2.3: Data transformations
      • Block 3: Analysing two variables (and sometimes three) >
        • 3.1 Two variables (CROSSTABS)
        • 3.2 Three (or more) variables
        • 3.3 Multiple response (MULT RESPONSE)
        • 3.4 Conditional data transformations (IF and DO IF)
        • 3.5 Derived variables (COUNT and COMPUTE) >
          • 3.5.1 Introduction to COUNT and COMPUTE
          • 3.5.2 Teenage Attitudes (Tutorials)
      • Block 4: Hypothesis testing
      • SPSS files and documentation used for tutorials and exercises >
        • Data sets used in Survey Analysis Workshop >
          • British Social Attitudes
          • Pre-course questionnaire on interests and experience
          • Quality of Life in Britain
    • Useful links for SPSS >
      • On-line SPSS Intros and tutorials
      • SPSS courses
  • 1a: Statistical concepts and methods
  • 1b: Teaching with Survey Data
    • SN 28: Relative Deprivation and Social Justice 1962-63
  • 1c: Developing research projects using survey data
  • 1d: Workshop and presentations for ASSESS (SPSS users in Europe)
    • Old Dog, Old Tricks: Using SPSS syntax to beat the mouse-trap
    • The Beginners' Guide to Survey Analysis Using SPSS
    • Close Encounters of the Fourth Kind: working with alien SPSS files
    • ASSESS 2014 Links to Contents
  • 2: Survey Research Practice
    • SR 502: Survey Research Practice (1976 - 1992)
    • Courses in Survey Methods >
      • (United Kingdom) Degrees, diplomas and certificates
      • (USA & Canada) Degrees, diplomas and certificates in survey research
      • Summer schools for survey methods
      • Short courses for survey research
    • Opinion polls >
      • Election poll débâcles
    • Web-based resources for survey research >
      • Survey Resources Network
      • On-line surveys
      • Question Banks
      • Survey methods guides and tutorials
      • Clips, tips and blogs
    • Useful links for Survey Research
  • 2a: Survey Research Methodology, Practice and Training
    • The place of survey research in the social sciences
    • Survey Research and Social Action
    • Academic centres specialising in survey research >
      • United Kingdom
      • USA and Canada
      • Europe
    • Professional and Voluntary Associations
    • Survey research organisations
    • Journals for survey research
    • Articles on survey research
  • 2b: Major survey series
    • United Kingdom (Major survey series: academic and other) >
      • British Social Attitudes >
        • British Social Attitudes: ​Exploring the SPSS files >
          • British Social Attitudes 1983 onwards: Cumulative SPSS file
          • British Social Attitudes: Making files from different years compatible
    • United Kingdom (Major survey series: government) >
      • ONS National Well-being
    • Europe (Major survey series)
    • USA (Major survey series)
  • 3: Subjective Social Indicators (Quality of Life)
    • Quality of Life: Measurement and methodology
    • Measures of psychological well-being
    • Values and Quality of Life
    • SSRC Survey Unit Quality of Life in Britain surveys 1971-1975 >
      • Abstracts, data and documentation
      • Publications based on the SSRC Quality of Life in Britain surveys >
        • Bibliography for Quality of Life in Britain and related surveys
        • Quality of Life of the Elderly in Residential Care
      • Surveys in schools >
        • "Trinians" survey
        • Playground to Politics
  • 4: Survey Unit, Social Science Research Council (UK)
    • Surveys by SSRC Survey Unit
    • Publications: SSRC Survey Unit
    • Courses, Conferences and Seminars
  • 5a: Polytechnic of North London (1976-1992)
  • 5b: Survey Research Unit (1978-1992)
    • SRU Student publications
    • Training courses in survey methods
    • The place of SRU within PNL >
      • Director's Working Group on the Survey Research Unit
  • Village life in Normandy
    • Notre Dame de Cenilly >
      • Fête St Clair 2007
      • Fête St Clair 2010
      • Fête St Clair 2012 National pedal-car championships
      • La Noslière de Bas
    • War and Peace in N D de Cenilly >
      • Armistice Day
      • German Occupation (1940 - 1944)
      • D-Day (6th June 1944) >
        • D-Day ceremony 9 June 2013
        • D-Day 70th Anniversary 2014
        • Lancaster bomber crew (Memorial Ceremony 8 June 2011)
        • Lancaster bomber crew (Memorial Ceremony 8 June 2014)
        • Lancaster bomber crew (Memorial Ceremony 7 June 2015)
        • Lancaster bomber crew ​(Memorial ceremony 5 June 2016)
      • Liberation July 1944 >
        • Field hospital in N D de Cenilly
        • Liberation celebrations (July 2006)
        • Visit of US 2nd Armored Division veterans (2 Sep 2009)
        • Liberation celebrations 2014
        • Unveiling of new monument (13 June 2015)
        • Re-enactment camp (Gavray, 11 July 2015)
    • Midsummer music
    • Paris trip (post Brexit)
  • Contact
  • Origins of the British Crime Survey
  • British Crime Survey

3.2  Three (or more) variables

[Page last updated 20 May 2019]

Introducing a third variable. Controlling for test variables. Elaboration.

Logical model is X → Y . T   (the effect of X on Y controlling for T) where:

Y = Dependent variable
X = Independent variable
T = Test variable(s)

                

3.2.1 Elaboration


For a brief statistical explanation see: 3.2.1 Elaboration (extract from Statistical Notes for the course)

3.2.1.1  Earnings differences – Elaboration  [Revised 2 July 2021]
​
​​Using data from the 1989 British Social Attitudes Survey this detailed work-through produces zero- and 1st- order contingency tables to see what happens to differences in earnings from paid work (dependent variable) between men and women (independent variable) when controlling for selected test variables . 

It uses SPSS command:  CROSSTABS     <depvar> BY <indvar> BY <testvar>
for some tables but also demonstrates how CTABLES  produces neater and cleaner output.  Epsilon (percentage point difference) is calculated at each level.

New tutorials replicate this elaboration exercise on  data from the British Social Attitudes Survey 2009-2014

Data safeguarding requirements mean that no actual data can be uploaded to this site from the British Social Attitudes Survey (BSAS) .  There is a list of SPSS files available from UKDS on BSAS filenames.  Using this file, click on the survey you want,  click on Use Data, click on Access data   Alternatively, check the series list of available files and click the Access link to request downloads of individual source files direct from UKDS.  See: Downloading British Social Attitudes Survey (BSAS) data from the UK Data Service 
​
As well as the source files for each survey year, the list also includes two cumulative files and a panel study:

British Social Attitudes Survey, 1983-1989
British Social Attitudes Survey, 1983-1991; Cumulative File 
British Social Attitudes Survey Panel Study, 1983-1986

The metadata in the original source files are not mutually compatible: they need to be converted before two or more files can be combined.  British Social Attitudes: Making files from different years compatible contains  direct hyperlinks links to the source files at UKDS and an explanation of how to convert and combine them.

New General Data Protection Regulations (GDPR) mean that hyperlinks to SPSS *.sav files in the following tutorials  will cause type 404 errors.  The links have been disabled and all three tutorials are currently being rewritten to point users to the correct place. 

They include hyperlinks to an earlier version of a cumulative SPSS "mother" *.sav file I created for all waves of the British Social Attitudes 1983-2014 which, because of GDPR issues, I have removed from my site.  Users must now download the data for each survey direct from UKDS, but major differences in metadata mean that the files are incompatible.  (See:   British Social Attitudes 1983 onwards: ​Cumulative SPSS file 1983 - 2017)
​
To get round the problem, Jon Peck (retired Senior Software Engineer, IBM-SPSS) made a brilliant suggestion: create a special version of the mother file containing no cases.   Users can now use bsa1983to2017zerocases.sav to create mutually compatible files using the SPSS command:  APPLY DICTIONARY.  Any combination of two or more converted files can then be generated using SPSS command ADD FILES.   
See: British Social Attitudes: Making files from different years compatible and  
​         British Social Attitudes 1983 onwards : Cumulative SPSS file

The following tutorials are still accessible, but are currently being re-written without links to data files.
​

3.2.1.1  Earnings differences – Elaboration [revised 2 July 2021]

3.2.1.2  Elaboration 2 (Income differences BSA 2009 - 2014)
Selection and extraction of variables from mother file; selecting years 2009 to 2014 only; tidy up metadata; derived variables; check contents of file; frequency counts.

3.2.1.3  Elaboration 3 (Income differences 2009 – 2014_CROSSTABS)
Zero order 2-way contingency tables
​
3.2.1.4  Elaboration 4 (Income differences 2009 – 2014_CTABLES)​
1st, 2nd etc order (multi-way) contingency tables 

New tutorials using BSAS 2009 [May 2019].   
    
Replication of 3.2.1.1  Earnings differences – Elaboration

Three new modules:​
​   Stage 1:  3.2.1.5 Earnings differences 2009: Download and check file
​​​   Stage 2:  3.2.1.6_[earnings_differences_2009]_extracting_and_saving_selected_variables
​   Stage 3:  3.2.1.7  Earnings differences 2009:  Elaboration 
​
To see if earnings differences have changed over time, further tutorials will replicate exercises using data from all waves 1983 to 2017..
​
3.2.1.8  Earnings differences 2017: Preparing the data

Back to         Block 3 : Analysing two variables (and sometimes three)
Proudly powered by Weebly
  • Welcome
  • ​​Important notice
  • About the author
    • John F Hall: Career profile
    • John F Hall: Extra-curricular professional and political activities
  • About this site
    • What people have said about this site
    • Latest additions and modifications
    • How to use this site
  • Site guide + Search box
  • Dedications
  • Acknowledgments
    • Unsung heroes in support services
  • My personal pantheon (of the great and the good in survey research)
    • Mark Abrams >
      • Abrams publications
      • An interview with Mark Abrams (transcripts)
      • An interview with Mark Abrams (audio files)
      • Mark Abrams Prize
    • Angus Campbell >
      • SRU garden reception for Angus Campbell
    • Cathie Marsh
    • Tony Coxon
    • Roger Jowell
    • James A Davis
    • Norman Nie
  • Recent and planned activities
  • Textbooks for Research Methods and Data Analysis
    • Textbooks: SPSS >
      • Highly recommended SPSS textbooks >
        • McInnes (2017) >
          • MacInnes, Chapter 4:​ Getting Started with SPSS
          • MacInnes, Chapter 5 Dealing with Data Documentation
          • MacInness 2017 (Web links)
        • Marsh and Elliott (2008)
        • Sweet and Grace-Martin 2012
        • Babbie, Halley, Wagner and Zaino 2013
        • Babbie, Wagner and Zaino 2019
        • Julie Pallant, SPSS Survival Manual
        • Andy Field
        • Boslaugh 2005
        • McCormick & Salcedo (2015)
        • McCormick & Salcedo (2017)
      • SPSS textbooks worth a look >
        • Hy (1977)
      • On-line SPSS textbooks
      • Textbooks requested or awaiting review
    • Textbooks: Statistics for Social Research >
      • de Vries 2018
      • Bergin (2018)
    • Textbooks: Survey Methods >
      • Crouch & Housden (2003)
      • Andres (2012)
      • Blair, Czala and Blair (2014)
      • de Vaus (2014)
      • Hoinville, Jowell et al (1977)
      • Marsden & Wright [Eds] (2010) >
        • Contributors to Handbook of Survey Research
      • Marsh (1982)
      • Moser & Kalton (1971)
      • Oppenheim (1992)
      • Pallant 2016
    • Textbooks: Data curation and sharing >
      • Corti et el (2014)
  • 1: Survey Analysis Workshop (SPSS)
    • What is SPSS?
    • SPSS Without Tears >
      • My first time: in at the SPSS deep end (1972)
    • Introduction to Survey Analysis Workshop (SPSS) >
      • IBM® SPSS® Statistics (Overview)
      • Note on SPSS tutorials on this site
      • Background to current project >
        • Author's note
      • SPSS versions used
      • Stata and SPSS
    • Summary guide to SPSS tutorials >
      • Block 1: From questionnaire to SPSS saved file
      • Block 2: Analysing one variable >
        • 2.1: Nominal and ordinal variables
        • 2.2: Interval scale variables
        • 2.3: Data transformations
      • Block 3: Analysing two variables (and sometimes three) >
        • 3.1 Two variables (CROSSTABS)
        • 3.2 Three (or more) variables
        • 3.3 Multiple response (MULT RESPONSE)
        • 3.4 Conditional data transformations (IF and DO IF)
        • 3.5 Derived variables (COUNT and COMPUTE) >
          • 3.5.1 Introduction to COUNT and COMPUTE
          • 3.5.2 Teenage Attitudes (Tutorials)
      • Block 4: Hypothesis testing
      • SPSS files and documentation used for tutorials and exercises >
        • Data sets used in Survey Analysis Workshop >
          • British Social Attitudes
          • Pre-course questionnaire on interests and experience
          • Quality of Life in Britain
    • Useful links for SPSS >
      • On-line SPSS Intros and tutorials
      • SPSS courses
  • 1a: Statistical concepts and methods
  • 1b: Teaching with Survey Data
    • SN 28: Relative Deprivation and Social Justice 1962-63
  • 1c: Developing research projects using survey data
  • 1d: Workshop and presentations for ASSESS (SPSS users in Europe)
    • Old Dog, Old Tricks: Using SPSS syntax to beat the mouse-trap
    • The Beginners' Guide to Survey Analysis Using SPSS
    • Close Encounters of the Fourth Kind: working with alien SPSS files
    • ASSESS 2014 Links to Contents
  • 2: Survey Research Practice
    • SR 502: Survey Research Practice (1976 - 1992)
    • Courses in Survey Methods >
      • (United Kingdom) Degrees, diplomas and certificates
      • (USA & Canada) Degrees, diplomas and certificates in survey research
      • Summer schools for survey methods
      • Short courses for survey research
    • Opinion polls >
      • Election poll débâcles
    • Web-based resources for survey research >
      • Survey Resources Network
      • On-line surveys
      • Question Banks
      • Survey methods guides and tutorials
      • Clips, tips and blogs
    • Useful links for Survey Research
  • 2a: Survey Research Methodology, Practice and Training
    • The place of survey research in the social sciences
    • Survey Research and Social Action
    • Academic centres specialising in survey research >
      • United Kingdom
      • USA and Canada
      • Europe
    • Professional and Voluntary Associations
    • Survey research organisations
    • Journals for survey research
    • Articles on survey research
  • 2b: Major survey series
    • United Kingdom (Major survey series: academic and other) >
      • British Social Attitudes >
        • British Social Attitudes: ​Exploring the SPSS files >
          • British Social Attitudes 1983 onwards: Cumulative SPSS file
          • British Social Attitudes: Making files from different years compatible
    • United Kingdom (Major survey series: government) >
      • ONS National Well-being
    • Europe (Major survey series)
    • USA (Major survey series)
  • 3: Subjective Social Indicators (Quality of Life)
    • Quality of Life: Measurement and methodology
    • Measures of psychological well-being
    • Values and Quality of Life
    • SSRC Survey Unit Quality of Life in Britain surveys 1971-1975 >
      • Abstracts, data and documentation
      • Publications based on the SSRC Quality of Life in Britain surveys >
        • Bibliography for Quality of Life in Britain and related surveys
        • Quality of Life of the Elderly in Residential Care
      • Surveys in schools >
        • "Trinians" survey
        • Playground to Politics
  • 4: Survey Unit, Social Science Research Council (UK)
    • Surveys by SSRC Survey Unit
    • Publications: SSRC Survey Unit
    • Courses, Conferences and Seminars
  • 5a: Polytechnic of North London (1976-1992)
  • 5b: Survey Research Unit (1978-1992)
    • SRU Student publications
    • Training courses in survey methods
    • The place of SRU within PNL >
      • Director's Working Group on the Survey Research Unit
  • Village life in Normandy
    • Notre Dame de Cenilly >
      • Fête St Clair 2007
      • Fête St Clair 2010
      • Fête St Clair 2012 National pedal-car championships
      • La Noslière de Bas
    • War and Peace in N D de Cenilly >
      • Armistice Day
      • German Occupation (1940 - 1944)
      • D-Day (6th June 1944) >
        • D-Day ceremony 9 June 2013
        • D-Day 70th Anniversary 2014
        • Lancaster bomber crew (Memorial Ceremony 8 June 2011)
        • Lancaster bomber crew (Memorial Ceremony 8 June 2014)
        • Lancaster bomber crew (Memorial Ceremony 7 June 2015)
        • Lancaster bomber crew ​(Memorial ceremony 5 June 2016)
      • Liberation July 1944 >
        • Field hospital in N D de Cenilly
        • Liberation celebrations (July 2006)
        • Visit of US 2nd Armored Division veterans (2 Sep 2009)
        • Liberation celebrations 2014
        • Unveiling of new monument (13 June 2015)
        • Re-enactment camp (Gavray, 11 July 2015)
    • Midsummer music
    • Paris trip (post Brexit)
  • Contact
  • Origins of the British Crime Survey
  • British Crime Survey