Manual Socio Economic
Manual Socio Economic
Manual Socio Economic
and
FOREST RESEARCH INSTITUTE MALAYSIA
Field Manual
Socio-economic
Survey
Training Workshop on REDD+ Research
Project in Peninsular Malaysia
10 – 12 February 2015
Xcape Resort, Kuala Tahan, Pahang
Contents
Part I: Introduction 2
Aim of this manual 2
Supporting Notes
Note 1 – Sampling techniques 13
Note 2 – Format of questionnaire 14
Note 3 – Do & Don’t in Conducting Socio-economic
Interview 18
Note 4 – Conducting the survey 19
Note 5 – Guidance for community meetings 20
Note 6 - Example of questionnaire 22
Note 7 – Using SPSS software 40
Note 8 – Using R software 83
1
Part I:Introduction
Socio-economic survey tools are means designed to collect information on
local resource management systems, resource use and the relative
importance of resources for households and villages. Surveys also provide
information on local interaction with the government decision-making
systems and community perceptions of trends and priority issues
regarding the conservation and establishment of protection forest.
Knowledge about community-based institutions, which is also obtained,
and their roles in the sustainable use and conservation of natural
resources.
2
Part II: Undertaking socio-economic
surveys
Data to be collected: The data required from the study area may be
discussed with informants and communities. The discussion helps in
planning the actual survey, improving the questions asked, formulating
questionnaire design, determining sampling techniques and conducting the
survey.
The data gathered through the survey process will need to reflect the
purpose of the study. In developing the survey, other considerations are
budget available, the length of time for the interview, availability of human
resources needed to effectively conduct the surveys, entering the data and
analyzing the results.
The first step to meet related local government officers to explain the
nature of the study.
4
Researchers must briefly introduce and explain the aim of the visit
and study. It is important to ensure that both local people and the
researchers/study team understand which area will be studied. The
aim of research/study must also be clearly introduced to avoid
misunderstandings or raise false expectations. Cooperation and
support from local people are essential to ensure successful
implementation of the study. It is easier to achieve this support if the
first impression is good. Nevertheless, it must be stressed that the
fieldwork consists only in data collection and does not promise
something such as local development project.
Types of questions
For all interview types (household interviews, focus groups and key
informants), questions can be structured and asked as open, closed or
partially open questions. The type of question used will depend on the
information required. There are advantages and disadvantages of all
question types (Supporting Note 2).
6
Through an open question, such as ‘Does the existence of national
parks have an impact on your daily life; either positive or negative
effects’? The interviewer can uncover the meaning behind an answer,
allowing respondents to provide examples and explain their answers.
These types of questions are more time-consuming to recode and
analyze. Open questions can be difficult to ask and interpreting the
responses could be complex, so training enumerators is essential.
Step 3 – Implementation
Survey approaches vary. Different approaches are used for different
purposes. For the purpose of the socio-economic study, three survey
methods are used:
Rapid Rural Appraisal includes
-Community meeting
-Key informant interview
-Group discussion 8
Household survey
Field research
Rapid Rural Appraisal
The methods used include group discussion, community meetings,
key informant interviews, mapping, ethno-histories, stories and
taking-note. This RRA technique is a tool that enables a quick
assessment of the existing environment and the possible impacts of
the forest resource utilization and the other environmental services
to the local socio-economic livelihood. Information collected during
the RRA includes population size, socio-economic activities,
household dependency on the forest resources and related issues
faced by the community. This technique can be applied as a
preliminary stage of the study, which will provide basic information,
and ethno-histories of the study site for baseline in questionnaire
design.
Community meeting
The draft questionnaire prepared could be tested in the focus group. Focus group
thus helps to formulate the questions in simple language and easily understood.
Household survey
Village and household survey is used
predominantly to collect quantitative and
qualitative data, through structured
interviews with the head of the
household, using both closed and open
questions. Survey forms for both
household- and village-level surveys are
designed to gather specific information,
relevant to the survey objective, as
discussed above.
Field research
Field research includes methods of research sometimes referred to as
participant observation, direction observation and case studies. This
technique provides qualitative data: observations not easily reduced to
number. It enables better understanding on the socio-economic conditions
and activities of villagers such as paddy farming, harvesting and marketing
of forest resources. Case studies involved the narration of typical
experience of villagers in relation to the utilisation of forest resources. The
data gathered are used to cross-check information collected from the10
survey.
The questionnaire
In conducting this study, the formation of the questionnaire is the most
important component. Formation of the questionnaire is based on the initial
survey (Rapid Rural Appraisal) to the study area and also by the results of
the initial questionnaire test in focus group. Formation of the questionnaire
usually is categorized based on types of questions to gather basic
information such as demographic background, perceptions and level of
involvement. Example of questionnaire is attached in Supporting Note 6.
Data analysis
The choice of method for data analysis will depend on the
volume of data collected, the expected use of the findings and
the availability of the analysis software.
The final analysis will need to reflect the original aims and objectives
of the survey. To help structure the analysis, research questions could
be developed, such as:
= 1136___
1+1136 (0.05)2
= 400 respondents
Where,
n = Sample Size
N = Population Size (No. of households)
e = level of precision
From the above example of sample size, taken at the level of precision of
5% or 0.05. The results showed that the sample size of 400 respondents is
the reliable sample size.
13 | P a g e
Note 2 – Format of questionnaire
Open questions
14 | P a g e
Table 1. Advantages and disadvantages of open questions
Advantages Disadvantages
The interviewer can elicit more The interviewer needs to have
information and possibly uncover experience to build discussion of
new information that had not particular topics and record the
been previously considered. findings.
The interview records can be used Data analysis requires expertise
in the report as interesting and a lot of time.
illustrations.
The responses provide additional
scope for analysis and allow a new
interpretation of the conclusions.
Advantages Disadvantages
Easy answers and Important answers could be missed if
quick note-taking there is no appropriate category
Easy analysis provided.
Some information may be forced into
existing categories and other
information might be lost.
If respondents hesitate and the
interviewer helps with grid answers, the
results are potentially biased.
Closed questions
16 | P a g e
With closed questions, respondents must choose one of the available
answers, and no room is provided for further explanation or elaboration.
Using closed questions is useful when time is short and very specific
information is required. Usually in this type of question use Likert Scale as
baseline for questionnaire.
Advantages Disadvantages
Answers can be quickly Further analysis of closed
gathered, thus saving time. questions can be difficult
Comparison of respondents’ because of the lack of
and groups’ answers over time supplementary questions for
is easy. respondents to elaborate on
the reasons for their answer.
17 | P a g e
Note 3 – Do & Don’t in Conducting Socio-Economic
Interviews
Do
1. Understand the projects background and objectives
2. Aware of questionnaire contents
3. Beware of languages
4. Proper attire or dress code (Formal, casual but most important neat,
and clean)
5. Always SMILE
6. Use suitable, understandable and simpler words (layman terms)
7. When asking a question:
a. Speak when respondent ready
b. Control volume of voice
c. Greet sincerely
d. Introduce yourself, show name tag with organization logo
e. Explain the purpose of the survey
f. Explain the importance of study
g. Inform respondent that information given is confidential
h. Ask only related question
8. Use supporting tools such as Likert Scale Card, Pictures, etc.
9. Be a good listener
10. Ask for permission before taking photo
11. Give a door gift as token of appreciation
12. End interview session with THANK YOU
Don’t
1. Don’t ask question if the respondent is not ready
2. Don’t ask respondent’s full name, to avoid respondent feeling
uncomfortable
3. Don’t force if people do not want to be interviewed, especially in
household survey
4. Don’t take an advantage to look around respondent’s house
5. Don’t force respondent to get an answer, especially on income. Ask
politely, instead.
6. Don’t ask for hand phone number, if not necessary.
18 | P a g e
Note 4 – Conducting the survey
Ask permission from the village head prior to carrying out any survey
Ensure that the village has been informed and permission from the
village head has been obtained sufficiently in advance of the survey
If necessary, write letter to Local Authority (JAKOA, District Office,
etc.), and Head of Villages
19 | P a g e
Note 5 – Guidance for community meetings
The guidance below will help to ensure that the community meeting gets
off to the best possible start.
1. Set the village hall as the meeting place, and schedule the meeting
with village leaders.
3. Describe the activities and what will be achieved from this study.
What will be provided to the community?
How can the community participate?
How can the community assist and advise the team
during the study?
5. Villages participation
Invite the villagers to introduce themselves or their
village.
20 | P a g e
Find out if villagers have time to participate in the survey
as needed, and when they have time to do it.
21 | P a g e
Note 6 - Questionnaire
Dan
Sebarang pertanyaan mengenai kajian ini, sila berhubung dengan Program Ekonomi & Analisa
Strategik, Institut Penyelidikan Perhutanan Malaysia (FRIM), 52109 Kepong, Selangor, Malaysia. Tel:
03-62797547/62797000
RES -
22 | P a g e
1. No sampel/ No of sample Penemuramah/Interviewer: ______________
23 | P a g e
C) Pandangan terhadap projek konservasi/pemuliharaan Hutan Perlindungan
Taman Negara / Views on conservation projects/ Conservation of National Park
Protection Forest
1. Adakah saudara sedar akan kewujudan persekitaran taman negara
bersempadanan penempatan saudara?/ Are you aware with the existence of
National Parks?
a. Ya/ yes b. Tidak/ No
Individu/ Individual
Positif/Positive Negatif/Negative
_____________________________ _____________________________
_____________________________ _____________________________
_____________________________ _____________________________
_____________________________ _____________________________
_____________________________ _____________________________
_____________________________ _____________________________
Komuniti/ Community
25 | P a g e
7. Adakah pihak berkuasa taman negara melibatkan saudara atau komuniti setempat
secara langsung dalam pembangunan taman negara diperingkat-peringkat tertentu
(perancangan, pendidikan, maklumat/informasi & sebagainya?
Does the national park authorities involve you or local communities directly in park
development on specific stages (planning, education, information / information & others?
___________________________________________________________________________
___________________________________________________________________________
___________________________________________________________________________
___________________________________________________________________________
E) Kedudukan ahli-ahli isi rumah (iaitu ahli keluarga yang tinggal bersama) di
kampung ini/ The members of the households (ie family members living
together) in the village.
1. Jumlah ahli keluarga yang tinggal bersama/ Number of family members living
together _______________________
2. Bilangan ahli keluarga yang bekerja/ Number of family members working
___________________
3. Bilangan ahli keluarga yang bergantung kepada ahli lain/ Number of dependent
family member to other members ___________
4. Bilangan ahli keluarga yang mengganggur/ The number of jobless family members
_______________________
5. Bilangan ahli keluarga berhijrah/ Number of family members migrated
___________________
6. Bangsa (Sila nyatakan)/Race (please state) _____________________
7. Kawasan tanah pertanian dimiliki oleh keluarga/ The area of agricultural land
owned by the family :
a. Luas tanah asal yang dimiliki / Land area owned _____________________ ekar/
acres
b. Jenis tanaman yang diusahakan (Mengikut keutamaan) /Types of crops
cultivated (by priority)
26 | P a g e
1. Padi/Paddy 2. Getah /Rubber 3. Dusun/Garden
Umur tanaman
Bil. Jenis tanaman Luas (ekar)
sekarang
Bil Type of crop Area (acre)
Age of crop
1. Padi / Paddy
2. Getah/ Rubber
3. Dusun/ Garden
4. Tanaman kontan/ Cash crops
5. Kelapa sawit/ Oil palm
6. Lain-lain (nyatakan)/ Others
(please state)
27 | P a g e
10=
Pesara/Retired
11= Suri
rumah/Housewife
12= Lain-
lain/Others
______________
Beker
ja/W
orkin
g
1
(ketu
a)(Le
ader)
2
3
4
5
6
Tak
Kerja
/Joble
ss
91
92
93
94
95
96
97
98
99
100
101
102
28 | P a g e
PENGGUNAAN SUMBER-SUMBER EKOSISTEM HUTAN SIMPAN
DAN KAWASAN SEKITAR & HUTAN PERLINDUNGAN TAMAN
NEGARA, 2013
USE OF FOREST RESERVED ECOSYSTEM RESOURCES AND RESPECTIVE
AREAS & FORESTS PRESERVED NATIONAL PARK, 2013
7. Nyatakan alatan yang dibawa/digunakan (kos tetap)/ Specify tools brought / used
(fixed costs)
(a) (b) (c) (d)
Jenis alatan/ Bilangan Harga beli Jangkahayat
Type of equipment Unit (RM) (tahun)
Price(RM) Lifespan (years)
1. _________________ ___________ __________ _____________
2. _________________ ___________ __________ _____________
3. _________________ ___________ __________ _____________
4. _________________ ___________ __________ _____________
Place
(Conserved Forest,. Government Land Distance from residence (km)
Country Land or Preseved Land)
30 | P a g e
4. Keranji/ Black velvet ___________________________
_____________
5. Petai / Bitter beans ___________________________ _____________
6. Ubatan/ Medicine ___________________________ _____________
7. Madu/Honey ___________________________ _____________
8. ________ ___________________________ _____________
9. ________ ___________________________ _____________
12. Bilangan pekerja yang terlibat untuk satu-satu trip/ The number of employees
involved for a trip
1. Ahli keluarga/ Family members ____________________ orang/person
2. Bukan ahli keluarga/Non Family members ____________________ orang/ person
13. Jika bukan ahli keluarga berapakah upah yang dibayar untuk satu-satu
trip:RM __________________ / seorang
Wages paid if not family members per trip : RM __________________ / person
14. Jangkamasa kerja ketika pengambilan hasil (untuk setiap trip)/
Duration of work during sample collecion (per trip)
1. Masuk hutan (jam) / In forest (hours) _______________
2. Keluar hutan (jam) Out forest (hours) _______________
1=Ya/Yes 2=Tidak/No
15. Adakah anda memproses sendiri hasil yang diambil:
Do you process the result taken by yourself:
16. Jika ‘tidak’ dimanakah ianya dijual dan purata harga jualan (ex-farm)
If 'no' where is it sold and the average selling price (ex-farm)
(a) (b) (c) (d)
Jenis NTFP Lokasi jualan dan jarak Harga jualan Cara
(Nama syarikat) (RM)/unit jualan
Type of NTFP Location of sale and distance Price Method of sales
(Name of company) (RM)/Unit
17. Jika dihantar sendiri, nyatakan jenis kenderaan yang digunakan dan
jumlah pekerja yang terlibat (16d):/ If delivered by hand, specify type of vehicle used
and no. of worker involved:
a. Jenis kenderaan/ Type of Vehicle: ____________________b. __________________
orang/person
31 | P a g e
18. Jika ianya diproses sendiri, apakah nama produk yang dikeluarkan:/ If it is
processed itself, named the products
(g)
Kos pembuatan/ Manufacturing cost
(RM/unit)
___________________
___________________
___________________
___________________
32 | P a g e
related to the support for the tourism sector (eg: business scale, doing homestays, guides
& suppliers)
a) Ya/ Yes b) Tidak/ No
______________________________________________________________________
33 | P a g e
J) Pesawah Padi / Paddy farmer
34 | P a g e
L) Pengusaha Ladang Kelapa Sawit
1. Luas kawasan dikerjakan/ Total area of land = ________ekar/ acre
2. Berapa tahun sudah bersawah/ How many years involve =______tahun/Years
3. Hasil keluaran2013 / Production 2013=_________tan/bulan
4. Hasil diterima 2013/ revenue 2013 =RM_________/tan
6. a. Kos penanaman (penyediaan tanah & anak pokok) = RM____
Cultivation cost (Land preparations and seedling)
b. Tahun ditanam/ planted year _________
7. Kos operasi purata 2013/ Operation cost 2013
a. Merumput/weeding RM_________
b. Beli racun/ pesticides RM_________
c. Meracun/ cost positioning RM_________
d. Beli baja/ fertilizer RM_________
e. Membaja/ cost fertilizing RM_________
f. Memetik buah / Picking fruit RM_________
g. Mengangkut hasil/ Transportation of fruit RM_________
h. Lain-lain/ others RM_________
8. Subsidi diterima 2013/ subsidies received 2013 = RM__________
1. Jenis spesis tanaman & harga jual (RM/kg)- Type of species and sales price
6. Pekerja yang terlibat untuk satu-satu trip/ No. Of workers per trips
a. Ahli keluarga/family members ____________orang/person
b. Bukan ahli keluarga/non-family members____________orang/person
7. Jika bukan ahli keluarga berapakah upah yang dibayar untuk satu-satu trip:
If non-family members, how much is their wages per trip
RM __________________ / seorang/person
N) Nelayan Tasik/Sungai
1. Jenis spesis tangkapan & harga jual (RM/kg) /Species of catches and Price if sell
8. Jika bukan ahli keluarga berapakah upah yang dibayar untuk satu-satu trip:
(If non-family, how much the wages per trip)
RM __________________ / seorang (person)
37 | P a g e
Bussines (c) Pengusaha chalet (Chalet operator) RM _____sebulan
(d) Pengusaha homestay(homestay operator RM___sebulan
(e) Pemandu bot (Boatman) RM _____sebulan
(f) Pemandu pelancong (tourguide)RM_____sebulan
(g) Kedai runcit/makan(grocery/restaurant)RM___sebulan
(h) Berniaga (bussines) RM______________sebulan
(i) Lain-lain (others) RM______________Sebulan
38 | P a g e
P) Pemilikan Harta Isirumah (household property ownership)
39 | P a g e
Note 7 – Using SPSS software
1.0 GETTING STARTED WITH SPSS
The SPSS package is a powerful and user-friendly statistical analysis tool . It provides
a simple point and click or drag interface for statistical analysis. It has a DATA
EDITOR, which is a spreadsheet that allows you to enter data easily. Statistical
analysis results are displayed in the OUTPUT window and tables and charts can be
copied and paste easily into other programs such as Word or Power-point for
documents and presentations.
To start SPSS, left click on the Start button (at the lower left corner), select Programs,
SPSS for Windows and SPSS 18.0 for Windows.
The SPSS windows dialogue appears and provides a list of tasks that you can do.By
default, the task is set as “Opening an existing data source”.
Click on the OK button and the Open Data dialogue box appears and provides a list
of available SPSS data sets in the SPSS folder.
40 | P a g e
Select required data example the “TRAINING “ from the list of SPSS files and click
on the Open button. If the data is save in SPSS format, it will appear extension
“.sav”.
The DATA EDITOR and the OUTPUT windows will appear. Select the DATA
EDITOR window.
41 | P a g e
At the top right corner of the DATA EDITOR window, there are three buttons for the
following tasks:
Minimize Left button with a dash (-)
Maximize Middle button with a square ()
Close Right button with a cross (x)
Maximize the data window by clicking on the middle button with a square.
You can now get a full view of the data in the Employee data file.
SPSS data files are saved with the extension “.sav’
42 | P a g e
The SPSS main windows are listed below:
Data Editor A spreadsheet for defining variables, entering and editing
data.
Output Viewer Displays statistical results, tables and charts.
Output can be saved as an output file for later use.
Output can be copied and paste into other programs such as
Word and Power-point.
Pivot Table Editor Output displayed in tables can be edited. Rows and column
can be interchanged.
Chart Editor Charts can be edited. Allows changes such as colour, font and
chart types.
Text Output Editor Allows text in output viewer to be edited.
Syntax Editor Allows saving SPSS syntax and running syntax commands
during an SPSS session.
Script Editor Allows advanced users to customize and automate SPSS tasks
by creating and modifying scripts within the program.
The DATA EDITOR allows you to define variables, enter or edit data easily.
At the left bottom corner of the DATA EDITOR window, there are the Data View
and the Variable View tabs.
To view
data
To view information
on variables
43 | P a g e
Click on the Variable View tab and information such as variable name, type, label
and declaration of missing values are displayed.
Click on the Data View tab to return to the DATA EDITOR Window.
44 | P a g e
The File menu in DATA EDITOR has a list of tasks such as creating New (Data,
Syntax, Output or Script), Open (Data, Syntax, Output or Script), Close, Save, Save
As (to different location), Export to Database (dBase, Excel or MS Access), and
listing of Recently Used Data or Recently Used Files.
The Edit menu provides tasks such as Cut, Copy, Paste, Clear, Insert Cases, Insert
Variable, Find (to find data for a particular variable), Go to Case (to locate certain
Case Numbers or observations) and Options (to change default settings)
45 | P a g e
The View menu allows changing the font style, remove grid lines and display
variables or value labels for coded variables (such as f = Female, m = Male).
The Data menu provides a list of tasks such as Copy Data Properties (copy selected
variable and data from other data sets), Sort Cases, Merge Files, Split File and
Select Cases.
46 | P a g e
The Transform menu allows you to Compute (create new variables such as sum,
ratio or log), Recode, Automatic Recode (recode several variables at once), Visual
Binning (create bins for interval variables), Rank Cases and Replace Missing
Values.
The Analyze menu provides a list of statistical analysis such as Descriptive Statistics
(frequencies and cross-tabulations), Compare Means (Independent-Samples T-test,
Paired-Samples T-test, ANOVA), General Linear Model, Correlation, Regression
and Non-parametric Tests.
47 | P a g e
The Graph menu enables you to create bar charts, pie charts, line charts, boxplots
and histogram using Chart Builder, Interactive or Legacy Dialogs.
The Help menu allows you to search information under Topics, learn more on how
to use SPSS using Tutorial, Case Studies or Statistics Coach.
48 | P a g e
2.0 CREATING SPSS DATA FILES
The SPSS DATA EDITOR is a spreadsheet that allows you to enter data easily.
Click on the File menu, select New and Data and the SPSS DATA EDITOR window
appears. The Untitled1[DataSet] at the top left corner indicates that this is a new file
and no filename has been given.
49 | P a g e
Move the cursor using the left arrow on the keyboard to the Type column.
Since gender is coded as “1” and “2”, it can be declared as Numeric. If gender is
coded as “m’ and “f” then you will need to select String. Use the default Numeric
type and click on OK.
In the Decimals columns, the default decimal place is 2. Decrease the decimal to zero
as gender is a categorical variable and not measured on a continuous scale. Move the
cursor using the left arrow on the keyboard to the Label column and type gender.
Next, move the cursor using the left arrow on the keyboard to the Values column.
Click on the small grey square button and the Value Labels dialogue window
appears. Type 1 in the Value box. Next, type male in the Label box and click on Add
button.
50 | P a g e
1. Right Click
Values column
3. Click Add
51 | P a g e
Continue defining the other variables as listed below.
Name Type Label Values
52 | P a g e
The Variable View window with all variables defined is shown below:
Click on the Data View button at the lower left corner to get back to the DATA
EDITOR window.
Enter the data for the first five respondents as shown below:
53 | P a g e
Click on the File menu and select Save As.
The Save Data As dialogue window appears
Under Save in, select the location (or folder) where you want to save your file by
clicking on the down arrow .
Type in survey in the File name box below the list of SPSS data files.
By default, the Save As type is SPSS (*.sav) for SPSS data file.
In this example, the survey.sav data is saved in the FRIM folder.
54 | P a g e
2.2 Importing Excel Files
This section illustrates how to import Excel data files into SPSS.
Go to the File menu, select Open and Data.
From the Open Data dialogue window, under Look in, click on the down arrow
and select the folder FRIM.
Next, under File of type, click on the down arrow and select Excel (.*xls).
55 | P a g e
In the Opening Data Source dialogue window, under Worksheet window, click the
down arrow and three Excel worksheets will be displayed. Select the first
worksheet WORKSHOP ([A1:M1].
Click OK and the data appears in the SPSS DATA EDITOR window.
Click on the File menu, select Save As. In the Save As In dialogue window, under
File name, type in WORKSHOP1 and click Save.
56 | P a g e
Repeat the whole process and import in the second Excel worksheet and save it as
WORKSHOP2.
57 | P a g e
This section illustrates how to merge three SPSS data file into one file.
Open the WORKSHOP1 SPSS data file using File, Open Data. From the Data menu,
select Merge files and Add Cases. In the dialogue window Add cases to
WORKSHOP1, under An Open data set, select WORKSHOP2 and click Continue.
Note that you will have to click on the An External SPSS data file button and
Browse to locate WORKSHOP2 if it is not an open data set.
58 | P a g e
In the Add Cases from WORKSHOP2 dialogue window, make sure that all the
variables are listed in the Variables in Active data set box. Click OK and the 73
observations in WORKSHOP2 will be included into the WORKSHOP1 SPSS data
set.
59 | P a g e
Click on File, select Save As and and type WORKSHOP_merge in the File Name box.
This SPSS data set contains observations from all three data sets.
60 | P a g e
3.0 DESCRIPTIVE STATISTICS AND CREATING CHARTS
Quantitative analysis should always start with some descriptive statistics and charts
before moving on to inferential statistics which involves modeling and hypothesis
testing. Simple descriptive statistics involve reporting the mean or median and
standard deviation of continuous variables, and the frequency distribution and
percentages for categorical variables. Charts are informative visual aids for
summarizing results and makes report looks interesting.
.
The Frequencies dialogue box appears. Select the variable “Name of Village” and
click on the middle button to move it to the Variable(s) box.
61 | P a g e
The SPSS output is shown below:
Statistics
Name of village
N Valid 239
Missing 0
Kg
Cumulative
Frequency Percent Valid Percent Percent
Note that since there are no missing values the Percent and Valid Percent values are
the same.
62 | P a g e
3.1.2 Descriptive statistics
Open the Employee Data.sav file
Click on Analyze and select Descriptive Statistics and then Descriptives.
In the Descriptives window, select teh variable ‘salary’ and ‘salbegin’ and move them
into the Variable(s) box.
Click on the Options tab and the Descritive:Options dialogue window appears.
By default the boxes for Mean, Std. Deviation, Minimum and Maximum are already
checked. Under Distribution, click on the Skewness and Kurtosis boxes.
Then, click Continue and OK.
The descriptive statistics results will appear in the OUTPUT window.
63 | P a g e
3.2 Creating Pie Charts
Click on the Charts button. Select Pie Chart. Under Chart Value, then select
Percentage.
64 | P a g e
Double click again on the pie chart in the Chart Editor window and the Properties
dialogue box appears. Click on Depth & Angle.
65 | P a g e
Double click on the 3-D pie-chart. From the Elements menu select Data Label Mode
and click on each slice of the pie-chart to put in the percentage value.
Click on Elements and Data Label Mode again to switch off the Data Label Mode.
66 | P a g e
Click on the Minimize button to return to the Output window. You have now
created a 3-D pie-chart with percentage values for each segment.
The Bar Charts dialogue window appears. Click on Simple and under Data in Chart
use the default “Summaries for groups of cases”. Click on Define.
67 | P a g e
In the Define Simple Bar:Summaries for Groups of Cases, select Gender and move
it to the Category Axis box. Click on the % of cases radio button and then click OK.
The simple bar chart for gender will appear in the OUTPUT window.
68 | P a g e
To create a 3-D simple bar chart, double click on the bar chart and the Chart Editor
window appears. Double click on one of the bars and from the Properties dialogue
box, click on Depth & Angle. Click on the 3-D radio button and then click Apply.
69 | P a g e
The 2-D simple bar chart changes to a 3-D chart. Click on Elements and select Data
Label Mode.
Click on each of the bar and the percentage value will appear.
Close the Chart Editor window by clicking on the Minimize button. to view the 3-D
bar chart in the OUTPUT window.
70 | P a g e
You can click on the bar chart in the Output window to select it.
Then, click on the Edit menu, select Copy and Paste the bar chart into a Word
document or power-point slide.
71 | P a g e
In the Define Clustered Bar:Summaries for Groups of Cases, select Marital Status
and move it to the Category Axis box. Then, select Gender and move it to the Define
Clusters by box. Click on the % of cases radio button and then click OK.
The clustered bar chart for gender clustered by marital status appears in the
OUTPUT window.
72 | P a g e
To create a 3-D clustered bar chart, double click on the bar chart and the Chart Editor
window appears. Double click on one of the bars and from the Properties dialogue
box, click on Depth & Angle. Click on the 3-D radio button and then click Apply.
The 2-D simple bar chart changes to a 3-D chart. Click on Elements and select Data
Label Mode.
73 | P a g e
Click on each of the bar and the percentage value will appear.
Close the Chart Editor window by clicking on the Minimize button to view the 3-D
bar chart in the OUTPUT window
74 | P a g e
3.5 Creating Stacked Bar Charts
75 | P a g e
In the Define Stacked Bar:Summaries for Groups of Cases, select Gender and move
it to the Category Axis box. Then, select Marital Status and move it to the Define
Stacks by box. Click on the % of cases radio button and then click OK.
The bar chart for gender stacked by marital status appears in the OUTPUT
window.
76 | P a g e
To create a 3-D clustered bar chart, double click on the bar chart and the Chart
Editor window appears. Double click on one of the bars and from the
Properties dialogue box, click on Depth & Angle. Click on the 3-D radio button
and then click Apply.
The 2-D simple bar chart changes to a 3-D chart. Click on Elements and select
Data Label Mode.
77 | P a g e
Click on each of the bar and the percentage value will appear.
Close the Chart Editor window by clicking on the Minimize button to view the 3-D
bar chart in the OUTPUT window.
78 | P a g e
3.6 Creating Simple Boxplots
The Boxplot dialogue window appears. Click on Simple and use the default
“Summaries for groups of cases”. Click on Define.
79 | P a g e
In the Define Simple Boxplot:Summaries for Groups of Cases, select Age and move
it to the Variable box. Then, select Gender and move it to the Category Axis box.
Then, click OK.
80 | P a g e
The dark horizontal line in the box, represents the median of age for each gender.The
boxplots show that the median age for male is higher than female. The long whiskers
indicate that the distribution of age is skewed to the right for each gender.The small
white circle indicates there is an outlier in the female group.
In the Define Clustered Boxplot:Summaries for Groups of Cases, select Age and
move it to the Variable box. Then, select Name of Village and move it to the Category
Axis box. Then, select Gender and move it to the Define Clusters by box and click
OK.
81 | P a g e
.
The clustered boxplot of Age for every village will appear in the OUTPUT window.
82 | P a g e
Note 8 – Using R software
Outline
Thanks for the great contributions from R developers and all other contributors!