The big picture

Before breaking down well-being into the various components and sub-components it will help to look at the overall picture. In which countries are personal and social well-being high, in which are they low?

Exercise 7

Simply calculate the means for personal and social well-being by country, using appropriate weighting. If you are using Nesstar, use the map function to visualise this. Which regions of Europe have highest personal and which highest social? Are they differences between the two types? (Note: Calculate these means using untransformed scores. If you wish, you can transform them afterwards but it’s not necessary and won’t change how the countries fare against one another).

Solution - Nesstar
1. Open the dataset.
2. Click the icon for weighting, and select the design weight.
3. Select the tab ‘Tabulation’, find the variable ‘map - Map identification code for countries’ in the variable group ‘Country’ and select ‘Add to row’.
4. Find the variable ‘Personal well-being’ in the variable group ‘Well-being, recoded and computed variables’, and select ‘Add as measure’.
5. Sort the table by clicking the column header ‘average’.
6. Visualise the results by clicking the icon for map.
7. Repeat 4 – 6 for the variable ‘Social well-being’.

Table 3.1. The rank orders (transformed or otherwise)
Personal Social
Denmark Denmark
Switzerland Norway
Austria Spain
Norway Switzerland
Finland Sweden
Ireland Ireland
Sweden Portugal
Netherlands Netherlands
Cyprus Finland
Belgium Austria
Germany Hungary
Spain Cyprus
UK Belgium
Slovenia Bulgaria
France UK
Poland Estonia
Estonia Germany
Portugal Poland
Slovakia France
Hungary Slovenia
Bulgaria Slovakia
Ukraine Ukraine

As you can see the regions with highest personal well-being are in Scandinavia, as well as Austria and Switzerland, the lowest being towards the East of Europe and Portugal. For social well-being, Scandinavia still does well, but so does Southern Europe. Meanwhile, Central and Eastern Europe, with some countries still doing badly (e.g. Ukraine) whilst others do better (e.g. Hungary).

Solution SPSS

Table 3.1. The rank orders (transformed or otherwise)
Personal Social
Denmark Denmark
Switzerland Norway
Austria Spain
Norway Switzerland
Finland Sweden
Ireland Ireland
Sweden Portugal
Netherlands Netherlands
Cyprus Finland
Belgium Austria
Germany Hungary
Spain Cyprus
UK Belgium
Slovenia Bulgaria
France UK
Poland Estonia
Estonia Germany
Portugal Poland
Slovakia France
Hungary Slovenia
Bulgaria Slovakia
Ukraine Ukraine

As you can see the regions with highest personal well-being are in Scandinavia, as well as Austria and Switzerland, the lowest being towards the East of Europe and Portugal. For social well-being, Scandinavia still does well, but so does Southern Europe. Meanwhile, Central and Eastern Europe, with some countries still doing badly (e.g. Ukraine) whilst others do better (e.g. Hungary).

WEIGHT BY dweight.

MEANS
TABLES=personal_WBI social_WBI BY CNTRY
/CELLS MEAN COUNT STDDEV.
Go to next page >>