DATA ANALYSIS
DATA ENTRY
STAGES OF DATA ANALYSIS
ERROR
CHECKING
AND
VERIFICATION
CODING
EDITING
Introduction
Preparation of Data
Editing, Handling Blank responses, Coding,
Categorization and Data Entry
These activities ensure accuracy of the data and
its conversion from raw form to reduced data
Exploring, Displaying and Examining
data
Breaking down, inspecting and rearranging data
to start the search for meaningful descriptions,
patterns and relationship.
Coding Rules
Categories
should be
Appropriate to the
research problem
Exhaustive
Mutually exclusive
Derived from one
classification principle
Appropriateness
Let’s say your population is
students at institutions of higher
learning
What is you age group?
15 – 25 years
26 – 35 years
36 – 45 years
Above 45 years
Exhaustiveness
What is your race?
Malay
Chinese
Indians
Others
Single Dimension
What is your occupation type?
Professional Crafts
Managerial Operatives
Sales Unemployed
Clerical Housewife
Others
Coding Open-ended Responses
Coding Open Ended Questions
Handling Blank Responses
How do we take care of missing
responses?
If > 25% missing, throw out the questionnaire
Other ways of handling
•Use the midpoint of the scale
•Ignore (system missing)
•Mean of those responding
•Mean of the respondent
•Random number
How to Select a Test
Two-Sample Tests
____________________________________________
k-Sample Tests
____________________________________________
Measurement
Scale One-Sample Case Related Samples
Independent
Samples Related Samples
Independent
Samples
Nominal
Binomial
x
2
one-sample test
McNemar
Fisher exact
test
x
2
two-samples
test
Cochran Q
x
2
for k samples
Ordinal
Kolmogorov-
Smirnov one-sample
test
Runs test
Sign test
Wilcoxon
matched-pairs
test
Median test
Mann-Whitney
U
Kolmogorov-
Smirnov
Wald-Wolfowitz
Friedman two-
way ANOVA
Median
extension
Kruskal-Wallis
one-way ANOVA
Interval and
Ratio
t-test
Z test
t-test for paired
samples
t-test
Z test
Repeated-
measures ANOVA
One-way
ANOVA
n-way ANOVA
Data Transformation
Weights
Assigning numbers to responses on a
pre-determined rule
Respecification of the Variable
Transforming existing data to form new
variables or items
Recode
Compute
Scale Transformation
Reason for Transformation
to improve interpretation and
compatibility with other data sets
to enhance symmetry and stabilize
spread
improve linear relationship between
the variables (Standardized score)
s
XX
z
i
-
Data Transformation
Section 1 - Computer Anxiety
Computers make me feel
uncomfortable
1234567
I get a sinking feeling when I
think of trying to use a computer
1234567
Computers scare me 1234567
I feel comfortable using a
computer
1234567
Working with a computer makes
me nervous
1234567
Sample SPSS Codebook
Research Model
Attitude
Intention to
Share
Information
Subjective
norm
5 items
4 items
3 items
Perceived
Behavioral
Control
4 items
Actual
Sharing of
Information
5 items
Factor Analysis - Command
Assumptions in FA
KMO and Bartlett's Test
.882
2878.230
78
.000
Kaiser-Meyer-Olkin Measure of Sampling
Adequacy.
Approx. Chi-Square
df
Sig.
Bartlett's Test of
Sphericity
KMO should be > 0.5
Bartlett’s Test should
be significant ie; p <
0.05
Question:
How valid is our instrument?
Reliability
Reliability Statistics
.977 5
Cronbach's
Alpha N of Items
Item-Total Statistics
15.25 6.681 .973 .965
15.26 6.560 .925 .972
15.24 6.906 .929 .972
15.21 6.825 .900 .975
15.25 6.555 .935 .970
Att1
Att2
Att3
Att4
Att5
Scale Mean if
Item Deleted
Scale
Variance if
Item Deleted
Corrected
Item-Total
Correlation
Cronbach's
Alpha if Item
Deleted
Question:
How reliable are our instruments?
Should be
preferably > 0.3
Reliability
Reliability Statistics
.912 4
Cronbach's
Alpha N of Items
Item-Total Statistics
11.20 4.243 .761 .900
11.03 4.135 .855 .868
11.00 4.021 .856 .867
11.21 4.250 .736 .909
Sn1
Sn2
Sn3
Sn4
Scale Mean if
Item Deleted
Scale
Variance if
Item Deleted
Corrected
Item-Total
Correlation
Cronbach's
Alpha if Item
Deleted
Reliability
Reliability Statistics
.919 4
Cronbach's
Alpha N of Items
Item-Total Statistics
10.48 4.984 .814 .895
10.45 4.793 .826 .892
10.43 5.042 .809 .897
10.40 5.246 .814 .897
Pbc1
Pbc2
Pbc3
Pbc4
Scale Mean if
Item Deleted
Scale
Variance if
Item Deleted
Corrected
Item-Total
Correlation
Cronbach's
Alpha if Item
Deleted
Reliability
Reliability Statistics
.966 5
Cronbach's
Alpha N of Items
Item-Total Statistics
15.28 6.591 .951 .951
15.28 6.612 .888 .961
15.29 6.553 .901 .959
15.28 6.716 .877 .962
15.24 6.445 .904 .958
Intent1
Intent2
Intent3
Intent4
Intent5
Scale Mean if
Item Deleted
Scale
Variance if
Item Deleted
Corrected
Item-Total
Correlation
Cronbach's
Alpha if Item
Deleted
Table in Report
Variable N of ItemItem
Deleted
Alpha
Attitude 5 - 0.977
SN 4 - 0.912
Pbcontrol 4 - 0.919
Intention 5 - 0.966
Actual 3 - 0.771
Example - Recoding
Perceived Enjoyment
PE1 The actual process of
using Instant Messenger is
pleasant
1 2 3 4 5 6 7
PE2 I have fun using Instant
Messenger
1 2 3 4 5 6 7
PE3 Using Instant Messenger
bores me
1 2 3 4 5 6 7
PE4 Using Instant Messenger
provides me with a lot of
enjoyment
1 2 3 4 5 6 7
PE5 I enjoy using Instant
Messenger
1 2 3 4 5 6 7
Recoding - Command
Data before Transformation
Computing New Variable - Command
Data after Transformation
Frequencies - Command
Frequencies
Gender
144 75.0 75.0 75.0
48 25.0 25.0 100.0
192 100.0 100.0
Male
Female
Total
Valid
Frequency PercentValid Percent
Cumulative
Percent
Current Position
34 17.7 17.7 17.7
66 34.4 34.4 52.1
54 28.1 28.1 80.2
32 16.7 16.7 96.9
6 3.1 3.1 100.0
192 100.0 100.0
Technician
Engineer
Sr Engineer
Manager
Above manager
Total
Valid
Frequency PercentValid Percent
Cumulative
Percent
Question:
1.Is our sample representative?
2.Data entry error
Table in Report
Frequency Percentage
Gender
Male
Female
Position
Technician
Engineer
Sr Engineer
Manager
Above manager
144
48
34
66
54
32
6
75.0
25.0
17.7
34.4
28.1
16.7
3.1
Descriptives - Command
Descriptives
Descriptive Statistics
192 19 53 33.39 8.823 .667 .175 -.557 .349
192 1 18 5.36 4.435 1.448 .175 1.333 .349
192 1 28 9.04 7.276 1.051 .175 -.025 .349
192 2.00 5.00 3.8104 .64548 -.480 .175 .242 .349
192 2.00 5.00 3.7031 .67034 -.101 .175 .755 .349
192 2.00 5.00 3.4792 .73672 .015 .175 -.028 .349
192 2.00 5.00 3.8188 .63877 -.528 .175 .687 .349
192 2.33 5.00 4.0625 .58349 -.361 .175 -.328 .349
192
Age
Years working in the
organization
Total years of
working experience
Attitude
subjective
Pbcontrol
Intention
Actual
Valid N (listwise)
StatisticStatisticStatisticStatisticStatisticStatisticStd. ErrorStatisticStd. Error
N Minimum Maximum Mean Std.
Deviation
Skewness Kurtosis
Question:
1.Is there variation in our data?
2.What is the level of the phenomenon we are measuring?
Table in Report
Mean Std. Deviation
Attitude
3.81 0.65
Subjective Norm
3.70 0.67
Behavioral Control
3.48 0.74
Intention
3.82 0.64
Actual
4.06 0.58
Chi Square Test - Command
Crosstabulation
Gender * Intention Level Crosstabulation
110 34 144
76.4% 23.6% 100.0%
70.5% 94.4% 75.0%
57.3% 17.7% 75.0%
46 2 48
95.8% 4.2% 100.0%
29.5% 5.6% 25.0%
24.0% 1.0% 25.0%
156 36 192
81.3% 18.8% 100.0%
100.0% 100.0% 100.0%
81.3% 18.8% 100.0%
Count
% within Gender
% within Intention Level
% of Total
Count
% within Gender
% within Intention Level
% of Total
Count
% within Gender
% within Intention Level
% of Total
Male
Female
Gender
Total
Low High
Intention Level
Total
Chi-Square Tests
8.934
b
1 .003
7.704 1 .006
11.274 1 .001
.002 .001
8.888 1 .003
192
Pearson Chi-Square
Continuity Correction
a
Likelihood Ratio
Fisher's Exact Test
Linear-by-Linear
Association
N of Valid Cases
Value df
Asymp. Sig.
(2-sided)
Exact Sig.
(2-sided)
Exact Sig.
(1-sided)
Computed only for a 2x2 tablea.
0 cells (.0%) have expected count less than 5. The minimum expected count is 9.
00.
b.
Question:
Is level of sharing dependent on gender?
T-test - Command
t-test
(2 Independent)
Group Statistics
144 3.9000 .60302 .05025
48 3.5750 .68619 .09904
Gender
Male
Female
Intention
N Mean
Std.
Deviation
Std. Error
Mean
Independent Samples Test
3.591 .060 3.122 190 .002 .32500 .10410 .11965 .53035
2.926 72.729 .005 .32500 .11106 .10364 .54636
Equal variances
assumed
Equal variances
not assumed
Intention
F Sig.
Levene's Test for
Equality of Variances
t df Sig. (2-tailed)
Mean
Difference
Std. Error
DifferenceLower Upper
95% Confidence
Interval of the
Difference
t-test for Equality of Means
Question:
Does intention to share vary by gender?
Paired t-test - Command
t-test
(2 Dependent)
Paired Samples Statistics
3.8188 192 .63877 .04610
4.0625 192 .58349 .04211
Intention
Actual
Pair
1
Mean N
Std.
Deviation
Std. Error
Mean
Paired Samples Correlations
192 .817 .000Intention & ActualPair 1
N Correlation Sig.
Paired Samples Test
-.24375 .37326 .02694 -.29688 -.19062 -9.049 191 .000Intention - ActualPair 1
Mean
Std.
Deviation
Std. Error
Mean Lower Upper
95% Confidence
Interval of the
Difference
Paired Differences
t df Sig. (2-tailed)
Question:
Are there differences between intention to
share and actual sharing behavior?
One Way ANOVA - Command
One way ANOVA
(k independent)
ANOVA
Intention
7.864 4 1.966 5.247 .001
70.068 187 .375
77.933 191
Between Groups
Within Groups
Total
Sum of
Squares df Mean Square F Sig.
Intention
Duncan
a,b
66 3.6424
32 3.6625
34 3.8941
54 4.0000
6 4.5333
.101 1.000
Current Position
Engineer
Manager
Technician
Sr Engineer
Above manager
Sig.
N 1 2
Subset for alpha = .05
Means for groups in homogeneous subsets are displayed.
Uses Harmonic Mean Sample Size = 19.157.a.
The group sizes are unequal. The harmonic mean
of the group sizes is used. Type I error levels are
not guaranteed.
b.
Question:
Does intention vary by position?
Mann-Whitney - Command
Mann-Whitney
(2 independent)
Question:
Does the variables vary by gender?
Ranks
144 103.64 14924.00
48 75.08 3604.00
192
Gender
Male
Female
Total
Intention
N Mean Rank Sum of Ranks
Test Statistics
a
2428.000
3604.000
-3.266
.001
Mann-Whitney U
Wilcoxon W
Z
Asymp. Sig. (2-tailed)
Intention
Grouping Variable: Gendera.
Kruskal-Wallis - Command
Kruskal-Wallis
(k independent)
Question:
Does the variables vary by position?
Ranks
34 101.32
66 79.68
54 114.54
32 81.63
6 171.17
192
Position
Technician
Engineer
Sr Engineer
Manager
Above manager
Total
Intention
N Mean Rank
Test Statistics
a,b
28.179
4
.000
Chi-Square
df
Asymp. Sig.
Intention
Kruskal Wallis Testa.
Grouping Variable: Positionb.
Correlation - Command
Correlation
(Interval/ratio)
Question:
Are the variables related?
Correlations
1 .697** .212** .808** .606**
.000 .003 .000 .000
192 192 192 192 192
.697** 1 -.052 .653** .552**
.000 .471 .000 .000
192 192 192 192 192
.212** -.052 1 .281** .031
.003 .471 .000 .665
192 192 192 192 192
.808** .653** .281** 1 .817**
.000 .000 .000 .000
192 192 192 192 192
.606** .552** .031 .817** 1
.000 .000 .665 .000
192 192 192 192 192
Pearson Correlation
Sig. (2-tailed)
N
Pearson Correlation
Sig. (2-tailed)
N
Pearson Correlation
Sig. (2-tailed)
N
Pearson Correlation
Sig. (2-tailed)
N
Pearson Correlation
Sig. (2-tailed)
N
Attitude
subjective
Pbcontrol
Intention
Actual
AttitudesubjectivePbcontrolIntentionActual
Correlation is significant at the 0.01 level (2-tailed).**.
Correlation
(Ordinal)
Correlations
1.000 .043 -.415** -.019 -.090
. .314 .000 .417 .154
130 130 130 130 130
.043 1.000 -.476** -.263** -.259**
.314 . .000 .001 .001
130 130 130 130 130
-.415** -.476** 1.000 .117 .160*
.000 .000 . .092 .035
130 130 130 130 130
-.019 -.263** .117 1.000 .029
.417 .001 .092 . .372
130 130 130 130 130
-.090 -.259** .160* .029 1.000
.154 .001 .035 .372 .
130 130 130 130 130
Correlation Coefficient
Sig. (1-tailed)
N
Correlation Coefficient
Sig. (1-tailed)
N
Correlation Coefficient
Sig. (1-tailed)
N
Correlation Coefficient
Sig. (1-tailed)
N
Correlation Coefficient
Sig. (1-tailed)
N
Pay
Promotion
Work
Supervision
Coworkers
Spearman's rho
Pay Promotion Work SupervisionCoworkers
Correlation is significant at the 0.01 level (1-tailed).**.
Correlation is significant at the 0.05 level (1-tailed).*.
Question:
Are the variables related?
Friedman Test - Command
Friedman
(k related samples)
Question:
Is the rating similar?
Ranks
2.34
2.67
2.70
2.29
Sn1
Sn2
Sn3
Sn4
Mean Rank
Test Statistics
a
192
43.149
3
.000
N
Chi-Square
df
Asymp. Sig.
Friedman Testa.
Regression - Command
Multiple
Regression
Question:
Which variables can explain the intention to
share?
Variables Entered/Removed
b
Pbcontrol,
subjective,
Attitude
a
.Enter
Model
1
Variables
Entered
Variables
Removed Method
All requested variables entered.a.
Dependent Variable: Intentionb.
Model Summary
b
.832
a
.693 .688 .35703 1.501
Model
1
R R Square
Adjusted
R Square
Std. Error of
the Estimate
Durbin-
Watson
Predictors: (Constant), Pbcontrol, subjective, Attitudea.
Dependent Variable: Intentionb.
Multiple Regression
ANOVA
b
53.968 3 17.989 141.127 .000
a
23.964 188 .127
77.933 191
Regression
Residual
Total
Model
1
Sum of
Squares df Mean Square F Sig.
Predictors: (Constant), Pbcontrol, subjective, Attitudea.
Dependent Variable: Intentionb.
Coefficients
a
.191 .197 .971 .333
.601 .059 .607 10.103 .000 .453 2.210
.227 .056 .238 4.043 .000 .472 2.116
.143 .037 .165 3.821 .000 .877 1.140
(Constant)
Attitude
subjective
Pbcontrol
Model
1
B Std. Error
Unstandardized
Coefficients
Beta
Standardized
Coefficients
t Sig. Tolerance VIF
Collinearity Statistics
Dependent Variable: Intentiona.
After Removing Outliers
Model Summary
b
.900
a
.810 .807 .27373 1.725
Model
1
R R Square
Adjusted
R Square
Std. Error of
the Estimate
Durbin-
Watson
Predictors: (Constant), Pbcontrol, subjective, Attitudea.
Dependent Variable: Intentionb.
Coefficients
a
.067 .153 .441 .659
.758 .050 .784 15.281 .000 .396 2.523
.085 .047 .091 1.801 .073 .412 2.426
.145 .029 .173 5.015 .000 .875 1.143
(Constant)
Attitude
subjective
Pbcontrol
Model
1
B Std. Error
Unstandardized
Coefficients
Beta
Standardized
Coefficients
t Sig. Tolerance VIF
Collinearity Statistics
Dependent Variable: Intentiona.
ANOVA
b
58.261 3 19.420 259.182 .000
a
13.637 182 .075
71.898 185
Regression
Residual
Total
Model
1
Sum of
Squares df Mean Square F Sig.
Predictors: (Constant), Pbcontrol, subjective, Attitudea.
Dependent Variable: Intentionb.
Assumptions – Advanced Diagnostics
(Hair et al., 2006)
Residuals Statistics
a
2.1329 4.9380 3.8188 .53156 192
-3.172 2.106 .000 1.000 192
.027 .111 .048 .020 192
2.1423 4.9493 3.8179 .53167 192
-.96087 1.44295 .00000 .35421 192
-2.691 4.042 .000 .992 192
-2.731 4.253 .001 1.012 192
-.98909 1.59761 .00086 .36911 192
-2.779 4.461 .004 1.031 192
.130 17.495 2.984 3.453 192
.000 .485 .011 .051 192
.001 .092 .016 .018 192
Predicted Value
Std. Predicted Value
Standard Error of
Predicted Value
Adjusted Predicted Value
Residual
Std. Residual
Stud. Residual
Deleted Residual
Stud. Deleted Residual
Mahal. Distance
Cook's Distance
Centered Leverage
Value
Minimum Maximum Mean
Std.
Deviation N
Dependent Variable: Intentiona.
Assumptions (Normality)
6420-2-4
Regression Standardized Residual
70
60
50
40
30
20
10
0
F
r
e
q
u
e
n
c
y
Mean = -1.99E-17
Std. Dev. = 0.992
N = 192
Dependent Variable: Intention
Histogram
Assumptions
(Normality of the Error term)
1.00.80.60.40.20.0
Observed Cum Prob
1.0
0.8
0.6
0.4
0.2
0.0
E
x
p
e
c
t
e
d
C
u
m
P
r
o
b
Dependent Variable: Intention
Normal P-P Plot of Regression Standardized Residual
Assumptions (Constant Variance)
5.004.504.003.503.002.502.00
Intention
4
2
0
-2R
e
g
r
e
s
s
i
o
n
S
t
u
d
e
n
t
i
z
e
d
R
e
s
i
d
u
a
l
Dependent Variable: Intention
Scatterplot
Assumptions (Linearity)
10-1-2
Attitude
1.5
1.0
0.5
0.0
-0.5
-1.0
-1.5
I
n
t
e
n
t
i
o
n
Dependent Variable: Intention
Partial Regression Plot
Assumptions (Linearity)
210-1-2
subjective
2.0
1.5
1.0
0.5
0.0
-0.5
-1.0
I
n
t
e
n
t
i
o
n
Dependent Variable: Intention
Partial Regression Plot
Assumptions (Linearity)
10-1-2
Pbcontrol
2.0
1.5
1.0
0.5
0.0
-0.5
-1.0
I
n
t
e
n
t
i
o
n
Dependent Variable: Intention
Partial Regression Plot
Table Presentation
Variable Dependent = Intention
Standardized Beta
Attitude
Subjective Norm
Perceived Control
0.607**
0.238**
0.105**
R
2
Adjusted R
2
F Value
D-W
0.693
0.688
141.13
1.501
*p< 0.05, **p< 0.01
Discriminant - Command
Discriminant
Analysis
Analysis Case Processing Summary
127 66.1
0 .0
0 .0
0 .0
65 33.9
65 33.9
192 100.0
Unweighted Cases
Valid
Missing or out-of-range
group codes
At least one missing
discriminating variable
Both missing or
out-of-range group codes
and at least one missing
discriminating variable
Unselected
Total
Excluded
Total
N Percent
Dividing the Sample into Estimation and
Split/Holdout Sample: Random Selection
Command:
TRANSFORM RANDOM
NUMBER SEED
TRANSFORM COMPUTE
Randz = UNIFORM(1) > 0.65
will give 65% of respondent for
estimation and the remainder for
holdout sample
Question:
Which variables can discriminate high
and low intention to share?
Group Statistics
3.6481 .62349 104 104.000
3.5409 .62813 104 104.000
3.4038 .76981 104 104.000
4.3130 .57470 23 23.000
4.2609 .60995 23 23.000
3.6522 .78240 23 23.000
3.7685 .66448 127 127.000
3.6713 .68190 127 127.000
3.4488 .77494 127 127.000
Attitude
Norm
pbc
Attitude
Norm
pbc
Attitude
Norm
pbc
Level
Low
High
Total
Mean
Std.
DeviationUnweightedWeighted
Valid N (listwise)
Test for Model
Test Results
5.942
.939
6
9055.846
.465
Box's M
Approx.
df1
df2
Sig.
F
Tests null hypothesis of equal population covariance matrices.
Wilks' Lambda
.796 28.214 3 .000
Test of Function(s)
1
Wilks'
Lambda Chi-square df Sig.
Goodness of Model
Tests of Equality of Group Means
.850 22.007 1 125 .000
.833 24.998 1 125 .000
.985 1.949 1 125 .165
Attitude
Norm
pbc
Wilks'
Lambda F df1 df2 Sig.
Eigenvalues
.257
a
100.0 100.0 .452
Function
1
Eigenvalue
% of
VarianceCumulative %
Canonical
Correlation
First 1 canonical discriminant functions were used in the
analysis.
a.
Coefficients
Standardized Canonical
Discriminant Function Coefficients
.322
.741
.321
Attitude
Norm
pbc
1
Function
Canonical Discriminant Function Coefficients
.524
1.185
.415
-7.759
Attitude
Norm
pbc
(Constant)
1
Function
Unstandardized coefficients
Structure Matrix
.883
.828
.246
Norm
Attitude
pbc
1
Function
Pooled within-groups correlations between discriminating
variables and standardized canonical discriminant functions
Variables ordered by absolute size of correlation within
function.
Classification
NN
ZNZN
BA
ABBA
CU
Z
Z
A = centroid Group A
Z
B
= centroid Group B
N
A
& N
B
= Number in each group
Functions at Group Centroids
-.236
1.069
Level
Low
High
1
Function
Unstandardized canonical discriminant
functions evaluated at group means
Classification Function Coefficients
2.848 3.532
8.746 10.293
6.553 7.095
-32.031 -44.209
Attitude
Norm
pbc
(Constant)
Low High
Level
Fisher's linear discriminant functions
Predictive Validity
Classification Results
b,c,d
100 4 104
16 7 23
96.2 3.8 100.0
69.6 30.4 100.0
100 4 104
16 7 23
96.2 3.8 100.0
69.6 30.4 100.0
52 0 52
6 7 13
100.0 .0 100.0
46.2 53.8 100.0
Level
Low
High
Low
High
Low
High
Low
High
Low
High
Low
High
Count
%
Count
%
Count
%
Original
Cross-validated
a
Original
Cases Selected
Cases Not Selected
Low High
Predicted Group
Membership
Total
Cross validation is done only for those cases in the analysis. In cross validation, each
case is classified by the functions derived from all cases other than that case.
a.
84.3% of selected original grouped cases correctly classified.b.
90.8% of unselected original grouped cases correctly classified.c.
84.3% of selected cross-validated grouped cases correctly classified.d.
Benchmark for Comparison
How good is the Hit Ratio? Compute Hit Ratio for
split sample and compare it against
Maximum Chance Criterion: This is just the size of the largest
group. Minimum criterion to be met by the Hit Ratio
Proportional Chance Criterion: Should be used when group sizes
are unequal. If two groups this is given as follows:
Cpro = p2 + (1 - p)2 p = proportion in group
Press’s Q: Compares No. of correct classification (n) against Total
Sample (N) and Number of Groups (k)
Press Q
2
with 1 degree of freedom. (3.84, 6.64)
1)-N(k
k)]*(n - [N
Q Press
2
Logistic Regression- Command
Logistic Regression- Command
Case Processing Summary
192 100.0
0 .0
192 100.0
0 .0
192 100.0
Unweighted Cases
a
Included in Analysis
Missing Cases
Total
Selected Cases
Unselected Cases
Total
N Percent
If weight is in effect, see classification table for the total
number of cases.
a.
Dependent Variable Encoding
0
1
Original Value
Low
High
Internal Value
Classification Table
a,b
0 84 .0
0 108 100.0
56.3
Observed
Low
High
Sharing Level
Overall Percentage
Step 0
Low High
Sharing Level Percentage
Correct
Predicted
Constant is included in the model.a.
The cut value is .500b.
Initial Output
This is the proportion of
respondents in the high
Sharing category
Correctly classifies all those
With high values but misses
All those with low values.
No missing cases
Variables in the Equation
.251 .145 2.984 1 .084 1.286ConstantStep 0
B S.E. Wald df Sig. Exp(B)
Variables not in the Equation
30.588 1 .000
38.624 1 .000
.120 1 .729
41.833 3 .000
Attitude
SN
PBC
Variables
Overall Statistics
Step
0
Score df Sig.
Output
The Wald statistics is like the
t-value. The constant by
itself does not significantly
Improve prediction
The constant is entered
first, the other variables
are not included
Block 1: Method = Enter
Omnibus Tests of Model Coefficients
48.073 3 .000
48.073 3 .000
48.073 3 .000
Step
Block
Model
Step 1
Chi-square df Sig.
Model Summary
215.088
a
.221 .297
Step
1
-2 Log
likelihood
Cox & Snell
R Square
Nagelkerke
R Square
Estimation terminated at iteration number 5 because
parameter estimates changed by less than .001.
a.
Hosmer and Lemeshow Test
71.722 8 .000
Step
1
Chi-square df Sig.
Output
A significant chi square indicates
That the predicted probabilities do
Not match the observed probabilities.
This is not what we usually want.
The Model accounts
for 29.7% of the variance
Contingency Table for Hosmer and Lemeshow Test
16 15.496 2 2.504 18
18 15.112 2 4.888 20
14 12.942 6 7.058 20
12 8.200 8 11.800 20
4 1.512 0 2.488 4
2 12.814 32 21.186 34
10 6.312 8 11.688 18
2 6.777 20 15.223 22
0 3.959 20 16.041 20
6 .875 10 15.125 16
1
2
3
4
5
6
7
8
9
10
Step
1
ObservedExpected
Sharing Level = Low
ObservedExpected
Sharing Level = High
Total
Contingency Table – Hosmer Lemeshow
This is a more detailed assessment
of the Hosmer Lemeshow Test.
need to look at how close or
how different are the observed
and expected values for each group
Classification Table
a
48 36 57.1
8 100 92.6
77.1
Observed
Low
High
Sharing Level
Overall Percentage
Step 1
Low High
Sharing Level Percentage
Correct
Predicted
The cut value is .500a.
Variables in the Equation
.717 .415 2.993 1 .084 2.049 .909 4.617
1.351 .443 9.302 1 .002 3.860 1.620 9.193
-.197 .243 .657 1 .418 .821 .510 1.323
-6.741 1.501 20.171 1 .000 .001
Attitude
SN
PBC
Constant
Step
1
a
B S.E. Wald df Sig. Exp(B) Lower Upper
95.0% C.I.for EXP(B)
Variable(s) entered on step 1: Attitude, SN, PBC.a.
Classification
The overall Predictive
Accuracy = 77.1%
An increase of 1 unit on the Attitude
measure increases the odds of
Sharing at a higher level by 2.049
times, controlling for SN and PBC
An increase of 1 unit on the SN
measure increases the odds of
Sharing at a higher level by 3.860
times, controlling for SN and PBC