Analysis and presentation of data
using
SPSS
Case : Sleep survey
Import Excel file into SPSS
Import Excel file into SPSS
Important
Data-type
(measure)
SPSS : variable
view
SPSS : variable
view
Data view
Case : Sleep survey
Instrument Design ,
Analysis and presentation of data
using
SPSS
Q.1. Gender Analysis
Code Book :
Case : Sleep survey
Coding & Editing
0 = female
1= male
Q.1. Gender Analysis
Code Book : Case : Sleep survey Q.1. Gender Analysis
0 = female Coding & Editing
1= male
Coding & Editing
Enter ➔ value = 0
Label=female
Add
Q.1. Gender Analysis
Nominal Data : a) Frequency & % Gender profile
Q.1. Gender Analysis
Nominal Data : a) Frequency & % Gender profile b) Pie chart
Q.1. Gender Analysis
Nominal Data : a) Frequency & % Gender profile b) Pie chart
Editing
b) Pie chart
Right click on Pie chart for Editing
Editing
b) Pie chart
Elements -> Show Data Labels
Editing
To Exit..
b) Pie chart
Properties : Data value Labels
Now..
Copy paste
Frequency table
and Pie chart in
Word file
Question ➔ Age : Open End question Analysis
Select Statistics options
Output
Age : Missing value imputation ( filling with mean )
Age : Missing value imputation ( filling with mean )
Age : After Missing value imputation ( Label new variable as Age)
Change default Label to Age
Age : Again do Analyze -> Descriptive -> Frequncies
Age : Create new Age variable of Group of Ages ➔ 15-25, 25-35….
Age : Create new Age variable of Group of Ages ➔ 15-25, 25-35….
Age : Create new Age variable of Group of Ages ➔ 15-25, 25-35….
Click Old and New Values
Age : Create new Age variable of Group of Ages ➔ 15-25, 25-35….
Code it as 1
Enter Range of 15-25
Click Add
Age : Create new Age variable of Group of Ages ➔ 15-25, 25-35….
Code it as 1
Click Continue
Age : Create new Age variable of Group of Ages ➔ 15-25, 25-35….
Code it as 1
Click change
Then
Click OK
Code it as 1
Again change values and Label
Cross Table : Age vs Sex
Cross Table : Age vs Sex
& Bar chart Rows : Age-groups
Column : sex
Check bar chart
Cross Table : Age vs Sex
& Bar chart
Output
Hypothesis : There is no
association between
Age & satisfaction of
sleep
Cross Table & Chi- Coding : Extreme ends
square test
Cross Table :
Age vs Satisfied sleep
& Chi-square test
Output
Findings & Conclusion:
There is no association Hypothesis Accepted
between Age & p-value > 0.05
satisfaction of sleep (0.779)
Age : Check for Normality (
Skewness )
Graph : Histogram with
Normal curve
Graphs ➔ Legacy Dialogs➔Histogram
Age : Check for
Normality (
Skewness )
Graph :
Histogram with
Normal curve
Graphs ➔ Legacy
Dialogs➔Histogram
Cross Tabulation : using Custom Tables
Research Question :
Does smoking and marital status impact sleep satisfaction
level?
Research
Question :
Does
smoking
and marital
status
impact
sleep
satisfaction
level?
• smoking
• marital
• status
sleep
satisfaction
level
Select ➔
Marital status
and
drag to Rows
Select ➔
satsleep
and
drag to columns
Select ➔
smoke
and
drag to Rows
After
marital
To display
Row % in cross-tab
Click
‘Summary Statistics
To display
Row % in cross-tab
Click
[Link] N % and
Bring it to Display
box
[Link] to ALL
[Link]
Output : Quiz : Code ‘marital’ & ‘smoke’ and ‘satsleep’ create Corss-table again
Marital : 1=single, 2=married, 3=divorced, 4=widow
Smoke : 1=yes, 2=no
Satsleep : 1 = very dissatisfied , 10=very satisfied
Output : with Coded ‘marital’ & ‘smoke’ and ‘satsleep’
Quiz : Convert ‘satsleep’ in to new variable with label as ‘ Sleep
satisfaction levels’ with following levels & create new table ( as
below)
Low : Score range : 1 to 4
Medium : 5 to 6
High : 7 to 10
Quiz : Convert ‘satsleep’ in to new variable with label as ‘ Sleep
satisfaction levels’ with following levels & create new table ( as
below)
Low : Score range : 1 to 4
Medium : 5 to 6
High : 7 to 10
Low : Score range : 1 to 4 ( code=1)
Medium : 5 to 6 ( code=2)
High : 7 to 10 ( code=3)
Low : Score range : 1 to 4 ( code=1)
Medium : 5 to 6 ( code=2)
High : 7 to 10 ( code=3)
Coding in ‘Variable view’
Research Question : Does smoking impact sleep satisfaction?
Hypothesis : Average satisfaction score of smokers is less than non-
smokers
Apply t-test
of two
Independent
samples
Apply t-test of two Independent samples
Apply t-test of two Independent samples
Output P-value = 0.240 > 0.05 [Rule : If p > 0.05 ➔ Reject H0 ]
Accept H0 : Average satisfaction score of smokers is
equal to non-smokers
Conclusion : Smoking does not impact sleep satisfaction
Research Question : Does education level impact sleep satisfaction?
Hypothesis : Average satisfaction score of all levels of education are
equal
To compare ➔ Two groups of means ➔ Apply t-test
To compare ➔ More than Two groups of means ➔
Apply One-way ANOVA
Coding in Variable view
Research Question : Does education level impact sleep satisfaction?
Hypothesis : Average satisfaction score of all levels of education are
equal
To compare ➔ More than Two groups of means ➔
Apply One-way ANOVA
One-way ANOVA ➔ Output
P-value: 0.585 > 0.05
➔Accept H0
Conclusion : Edu level does not
impact sleep satisfaction
One-way ANOVA ➔
Output
Except for primary edu level ,
other edu levels sleep satisfaction
is same
Research Question : Which variables are correlated
with sleep satisfaction scores ?
To calculate
Correlation coefficient
of all ‘Scale’ variables
Research Question : Which variables are correlated
with sleep satisfaction scores ?
Check for each
variable in
‘satsleep’ column
1. High
correlation
2. P-value
([Link]) < 0.05
Research Question : How to
estimate sleep satisfaction
score for given significant
factors affecting it?
Apply : Linear Regression
Apply : Linear
Regression
Depenedent variables
Independent
variables ( significant
correlated variables )
Output : Linear Regression
R-square = 0.202 (not high)
Model is significant
P-value = 0.000 < 0.05
Regression Equation
SS= -3.264+
0.857(hourwnit)+
0.347(hourwend)
Both [Link] significant
[ p(Sig) < 0.05 ]
Advanced Graphic Visual Analysis
Q. Analyze impact of
Gender and Smoking on
Satisfaction of sleep
Advanced Graphic Visual Analysis
Advanced Graphic Visual Analysis
Q. Analyze
impact of
Gender and
Smoking on
Satisfaction of
sleep
Advanced Graphic Visual Analysis
Box-plot Analysis
Advanced Graphic Visual Analysis
Age vs. Satisfaction sleep :
Box-plot Analysis
Advanced Graphic Visual Analysis
Age vs. Satisfaction sleep :
Box-plot Analysis
Advanced Graphic Visual Analysis
Age vs. Satisfaction sleep :
Box-plot Analysis
Age vs. Satisfaction sleep :
Advanced Graphic Visual Analysis
Box-plot Analysis
Q. Does it differ Genderwise ??
Age vs. Satisfaction sleep :
Advanced Graphic Visual Analysis
Box-plot Analysis
Q. Does it differ Genderwise ??
Age vs. Smoke Numbers
Advanced Graphic Visual Analysis
Correlation & Regression Plot Analysis
Age vs. Smoke Numbers Advanced Graphic Visual Analysis
Correlation & Regression Plot Analysis