Pivot Tables
ANSWER ALL QUESTIONS
The Positive Leisure Organisation (PoLO) has commissioned a study to determine the influence
of a variety of television series on Nigerian society. You are the M&E official to the programme.
As part of your duties you have been tasked with a small side-line project, namely to analyse a
subset of the World Values Survey (WVS), which will give the programme management some
idea of the role of television in Nigerian society. The WVS is an on-going academic project that
assesses the state of socio-cultural, moral, religious, and political values of different cultures
around the world. Use the IS Practical Pivot [Link] find an extract of the data (for the year
2014) for Nigeria ([Link]). The dataset consists of 1 731 respondents and 14 variables.
The variables are explained on the next page.
Please compile a short report based on the topics that follow below.
SAVE YOUR REPORT
1.1. A demographic profile of the survey respondents, i.e. their distribution in terms of
1.1.1. gender;
1.1.2. age
1.1.3. marital status – not recoded
1.1.4. employment status; [20]
1.2. The extent to which each of the following four variables are related to the frequency of
watching television:
1.2.1. gender; [10]
1.2.2. marital status – recoded; [10]
1.2.3. employment status [10]
v01: What is your gender?
Male
Female
v02: What is your age?
v03: What is your marital status?
Single/Never married
Married
Living together as married
Separated / Divorced
Widowed
v03r: What is your marital status? (Recoded)
Single/Never married
Married / Living together as married
Separated / Divorced / Widowed
v04: Number of children
No child
1 child
2 children
3 children
4 children
5 children
6 or more children
v04r: Number of children (recoded)
No child
1 child
2-3 children
4+ children
v05: What is your employment status?
Employed
Housewife
Student
Unemployed
v06: Are you the chief wage earner in your house?
No
Yes
v07: How frequently do you watch television?
Do not watch TV
1-2 hours per day
2-3hours per day
More than 3 hours per day
v08: Televisionis my most important entertainment
Strongly agree
Agree
Disagree
Strongly disagree
v09: On a scale of 1 to 10, how satisfied are you with your life? (1 = dissatisfied;
10 = satisfied)
v10: On a scale of 1 to 10, how much freedom of choice and control do you experience?(1
= none at all; 10 = a great deal)
v11: On a scale of 1 to 10, how satisfied are you with the financial situation of your
household?(1 = dissatisfied; 10 = satisfied)
v12: On a scale of 1 to 10, how do you position yourself in terms of political orientation?(1 =
left; 10 = right)
