We assume that you have downloaded the dataset and that you have SPSS available.
Follow the procedure below to calculate standardised scores for two questions: ‘FMLSTRS - how much of the time spent with immediate family is stressful?’ and ‘SCLMEET - how often socially meet with friends, relatives or colleagues?’:
- First you should weight the data: Select ‘Data’ on the menu, then ‘Weight cases’, ‘Weight cases by’, find the combined weight and click ‘OK’.
- The next step is to calculate the means and standard deviations for the two variables.
- Then compute the z-scores using the formula shown earlier in this chapter: z-score = (x-mean)/s.d., where x is the value for each respondent. Use at least three decimal places in the calculations.
- If you want to check this has worked, now calculate means and standard deviations for the two new variables - the means should both be exactly 0, and the standard deviations should both be exactly 1.
Now you are going to compare the countries’ mean scores on these two variables. For which countries is the ‘friends’ score relatively higher than the ‘family’ one, and for which is the opposite true?
- Change the weighting to design weight.
- Calculate mean scores for the new variables by country.
The weighted mean and standard deviation for the two original variables are; for FMLSTRS, mean = 4.17 and s.d. = 1.58; for SCLMEET, mean=5.03 and s.d.=1.54. These numbers are used to compute the standardised variables.
Generally family life scores higher in more Eastern countries, and friends score higher in more Western countries. The exceptions to this are Ireland and Denmark. Countries where family life is better than general social life - Bulgaria, Cyprus, Denmark, Estonia, Hungary, Ireland, Poland, Slovenia, Slovakia, Ukraine. Countries where family life is worse - Austria, Belgium, Switzerland, Germany, Spain, Finland, France, UK, Netherlands, Norway, Portugal, Sweden.
You could also copy this syntax and paste it into a syntax window in SPSS:
What problem might there be from drawing strong conclusions from the results of exercise 4? Well, one problem is that they are based simply on two questions. For example, by choosing the question on family life being stressful, we are ignoring the question on family life being enjoyable. Surely we should take account of both questions to make judgements about family life overall for a given country. That’s why we aggregate.