Exercise 5

Calculate aggregated scores for ‘autonomy’ on the one hand and ‘social well-being’ on the other. You can use the structure we present, or decide for yourself which questions go into each component. Make sure you don’t overwrite any pre-existing variables.

Please note that the variables in the dataset are recoded in such a way that low values indicate low autonomy/supportive relations/trust and belonging, and high value indicates high on autonomy/supportive relations/trust and belonging.

Variables used to measure the concepts:

Autonomy

Social well-being

  1. Supportive relations
    • ‘FMLENJ - How much of the time spent with immediate family is enjoyable’
    • ‘FMLSTRS - How much of the time spent with immediate family is stressful’
    • ‘SCLMEET - How often socially meet with friends, relatives or colleagues’
    • ‘PPLLFCR - There are people in my life who care about me’
    • ‘INMDISC - Anyone to discuss intimate and personal matters with.
    • ‘FLTLNL - Felt lonely, how often past week’
  2. Trust and belonging
    • ‘PPLAHLP - Feel people in local area help one another’
    • ‘TRTRSP - Feel people treat you with respect’
    • ‘FLCLPLA - Feel close to the people in local area’
    • ‘TRTUNF - Feel people treat you unfairly’
    • ‘PPLTRST - Most people can be trusted or you can't be too careful’

The first step is to find the weighted (combined weight) mean and standard deviation of each of the variables.

Then you should compute the z-scores by inserting the mean and standard deviation into the formula: z=(variable x – mean of variable x)/standard deviation of variable x. The SPSS syntax for the variable dclvlf: COMPUTE zDCLVLF=(DCLVLF-3.9417)/0.89258. EXECUTE.

The third step is to use the z-scores to compute the aggregated scores of the three concepts; ‘autonomy_user’, ‘trust_and_belonging_user’ and ‘supportive_relations_user’. The SPSS syntax for the variable ‘autonomy_user’: COMPUTE autonomy_user=mean(zDCLVLF,zENJSTM). EXECUTE.

Finally, you should use the variables ‘trust_and_belonging_user’ and ‘supportive_relations_user’ to compute ‘social_WBI_user’.

Then, plot the relationships between income band and the two scores you have created, making sure to include confidence intervals.

  1. Select ‘Graphs – Line – Multiple’. Select ‘Summaries of Separate Variables’ and click ‘Define’.
  2. Lines should represent the variables ‘autonomy_user’ and ‘social_WBI_user’and income should be placed in the box for ‘Category Axis’.
  3. Click ‘Options’ and check ‘Display error bars’.
  4. Press ‘OK’, or paste the syntax into a syntax window before running it.

If you use the structure as we’ve presented, you should get a graph something like that in Figure 2.3.

How does income seem to determine these two components of well-being?

Solution and SPSS syntax

Focus on the parts of the income distribution where most respondents are (3 600 - 60 000 Euro). As you can see, whilst the social score continues to rise steadily between these bands, the autonomy score actually drops slightly. In other words, aside from the very rich and the very poor, increasing income actually, if anything, has a marginally negative impact on feelings of autonomy.

WEIGHT
BY COMWEIGHT.
 
DESCRIPTIVES VARIABLES=DCLVLF ENJSTM FMLENJ FMLSTRS INMDISC PPLLFCR SCLMEET FLTLNL PPLAHLP TRTRSP TRTUNF FLCLPLA PPLTRST
/STATISTICS=MEAN STDDEV.
 
COMPUTE zDCLVLF=(DCLVLF-3.9417)/0.89258.
COMPUTE zENJSTM=(ENJSTM-2.9984)/1.08467.
COMPUTE zFMLENJ=(FMLENJ-5.09586151614353)/1.04647052128614.
COMPUTE zFMLSTRS=(FMLSTRS-4.17171849136758)/1.57589187384221.
COMPUTE zINMDISC=(INMDISC-1.92105407665706)/0.26965865842679.
COMPUTE zPPLLFCR=(PPLLFCR-4.35013609636883)/0.728263042001109.
COMPUTE zSCLMEET=(SCLMEET-5.02630886477341)/1.53577850799754.
COMPUTE zFLTLNL=(FLTLNL-3.59609627370934)/0.698301985772749.
COMPUTE zPPLAHLP=(PPLAHLP-3.41155604551703)/1.55877472400037.
COMPUTE zTRTRSP=(TRTRSP-4.42700565871907)/1.1609980071544.
COMPUTE zTRTUNF=(TRTUNF-4.32951383508247)/1.39184142976578.
COMPUTE zFLCLPLA=(FLCLPLA-3.50392937567422)/0.972184350387443.
COMPUTE zPPLTRST=(PPLTRST-4.90038644113157)/2.35692654490545.
EXECUTE.
 
COMPUTE autonomy_user=mean(zDCLVLF,zENJSTM).
EXECUTE.
COMPUTE supportive_relations_user=mean(zFMLENJ,zFMLSTRS, zINMDISC, zPPLLFCR, zSCLMEET, zFLTLNL).
EXECUTE.
COMPUTE trust_belonging_user=mean(zPPLAHLP,zTRTRSP,zTRTUNF,zFLCLPLA,zPPLTRST).
EXECUTE.
COMPUTE social_WBI_user=mean(supportive_relations_user,trust_belonging_user).
EXECUTE.
 
GRAPH
/LINE(MULTIPLE)=MEAN(autonomy_user) MEAN(social_wbi_user) BY HINCTNT
/MISSING=LISTWISE
/INTERVAL CI(95.0).
Go to next page >>