发新话题
打印

SPSS Analyses of Survey Data tutorial

SPSS Analyses of Survey Data tutorial

IntroductionThis document contains a short description of the analyses that have to be performed on the data collected with the survey that is part of the BRM course. The aim of these analyses is to test your hypotheses by for instance getting insight into (1) the differences between groups within the organization or between different variables and (2) the relationships between different variables.spsschina.cn$ H% y" b! {! k1 n4 _3 _9 l
In this process, three main steps are distinguished:www.spsschina.com ,spss论坛,数据分析,数据调查,市场调研,SPSS,PLS,DEA,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,spss是什么,spss13.0下载,SPSS教程,Spss视频,数据分析师,数据分析论坛,数据分析软件+ a, E9 }! W# {) \9 b! Q
  • Prepare data
  • Test operationalizations
  • Test theory (hypotheses)
Prepare dataFirst, we have to make sure the data are ready for further analyses. This concerns the following steps:spsschina.cn: d3 H: {7 E  I7 q4 h. Q
Check for errors-          WHAT?- o+ G2 F; v5 ^9 v# F9 }
Make sure that there are no errors in the dataset, such as impossible values or other mistakes that would affect your analysis.
  x1 [" n/ i0 K* Gspss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|Eviews-          HOW?6 e1 u' t) {( K9 D# A" `: J
- Look through the data set for strange things
* K& h1 I4 D# L$ ~4 R8 ~+ I- Get the descriptives for all itemsspsschina.cn+ G! [/ t9 v) [1 Q# n* m
-          WHERE?
2 t6 u- {& k  g2 S7 A; f6 dspss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|Eviews- Analyze  Descriptives  Frequencieswww.spsschina.com ,spss论坛,数据分析,数据调查,市场调研,SPSS,PLS,DEA,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,spss是什么,spss13.0下载,SPSS教程,Spss视频,数据分析师,数据分析论坛,数据分析软件% S& R* \! d; ~2 |% ~' f
- Analyze  Descriptives  Descriptives# q# g8 l0 ^. z! t+ \( f
Recode variables-          WHAT?www.spsschina.com ,spss论坛,数据分析,数据调查,市场调研,SPSS,PLS,DEA,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,spss是什么,spss13.0下载,SPSS教程,Spss视频,数据分析师,数据分析论坛,数据分析软件4 x% p3 ^! m2 z  q! y, \
Make sure that all items (= questions in the dataset) “point the same way”. Sometimes, the same concept is measured by items that are both positive and negative in terms of that concept. For instance, measuring attitude towards a product with items saying both “I like…” and “I dislike…”.www.spsschina.com ,spss论坛,数据分析,数据调查,市场调研,SPSS,PLS,DEA,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,spss是什么,spss13.0下载,SPSS教程,Spss视频,数据分析师,数据分析论坛,数据分析软件. S4 O, L& {* B* a- ?
-          HOW?. D0 R0 g" V& y  m- K. ?9 H
Reverse the codes for items that “point the wrong way”. Recode into new variables, and change values from 51, 42, 33, 24 and 15.
: J* ]; G9 H. r' F( \2 b; J0 aspss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|Eviews-          WHERE?spss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|Eviews7 V: ^- S) d+ s( N% K. P4 ]
Transform  Recode  into different variablesspsschina.cn8 i0 h5 }" g, V) _0 ]
Make new variables for open questions (if necessary)-          WHAT?
# \, U5 B- v; Fspsschina.cnSome questions may be open questions, e.g. “What’s your function?”. If that is the case, you don’t have a variable you can use to compare groups (for instance). In that case, you have to make a new variables with categories (e.g., management, sales, engineering, etc.).
$ b8 I; h. }( |spss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|Eviews-          HOW?
5 s$ ^' s) b0 |  }Insert a new variable in the dataset, and manually assign categories to the different functions. Go through the dataset case per case.
- U& N* z% H' P6 o2 zspsschina.cn-          WHERE?SPSS,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,数据分析师,数据分析论坛,数据分析软件,spss13.0下载,SPSS教程,Spss视频amos ,sem analysis,spss function,spss net,spss software,spss statistical,数据分析师,数据分析论坛,数据分析软件,PLS,DEA,& ^! C9 g) M4 J6 E6 D+ F5 P
Edit  Insert variables; A- Q" }& u8 B6 U" c# W9 _" W  W
Test operationalizationsHaving gotten our data up to date, we can check for the quality of our operationalizations – in other words, the quality of the way we have measured our variables. Before continuing with the data analysis, we have to make sure that the measures we are basing our analyses on, are OK.
7 M- A# }& k/ f5 uspss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|EviewsReliability analysis-          WHAT?spss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|Eviews5 w# r; p1 {- N
Test whether the different items that we assume to measure one variable, can indeed be taken together into one scale (e.g., kshare1 up to kshare8)." Y1 @5 y5 k3 C6 a& t
-          HOW?SPSS,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,数据分析师,数据分析论坛,数据分析软件,spss13.0下载,SPSS教程,Spss视频amos ,sem analysis,spss function,spss net,spss software,spss statistical,数据分析师,数据分析论坛,数据分析软件,PLS,DEA,3 V4 m% w: v$ I' P* M
Perform a reliability analysis. Pay attention to the following criteria:spss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|Eviews4 x$ q) j, ~# j* d; u# A' U& S
o   Cronbach’s alpha (is this higher than .65?)spss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|Eviews$ N( `9 X- O, W, f& E# n  c  F) W
o   Corrected item-total correlation (higher than .30?)
" e$ f7 E1 q) bwww.spsschina.com ,spss论坛,数据分析,数据调查,市场调研,SPSS,PLS,DEA,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,spss是什么,spss13.0下载,SPSS教程,Spss视频,数据分析师,数据分析论坛,数据分析软件o   Alpha if item deleted (can we relevantly improve reliability by deleting items?).SPSS,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,数据分析师,数据分析论坛,数据分析软件,spss13.0下载,SPSS教程,Spss视频amos ,sem analysis,spss function,spss net,spss software,spss statistical,数据分析师,数据分析论坛,数据分析软件,PLS,DEA,( A( c2 J" _* [% c+ ?
Based on these criteria, decide whether to continue with the scale, to delete some items or do away with the scale altogether.www.spsschina.com ,spss论坛,数据分析,数据调查,市场调研,SPSS,PLS,DEA,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,spss是什么,spss13.0下载,SPSS教程,Spss视频,数据分析师,数据分析论坛,数据分析软件3 r/ ]; L+ T, D7 |1 s2 w# V
-          WHERE?www.spsschina.com ,spss论坛,数据分析,数据调查,市场调研,SPSS,PLS,DEA,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,spss是什么,spss13.0下载,SPSS教程,Spss视频,数据分析师,数据分析论坛,数据分析软件- h  q3 S. ?; r
- Analyze  Scale  Reliability Analysiswww.spsschina.com ,spss论坛,数据分析,数据调查,市场调研,SPSS,PLS,DEA,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,spss是什么,spss13.0下载,SPSS教程,Spss视频,数据分析师,数据分析论坛,数据分析软件' Y8 @& ?( ?1 [. P6 {
- You can click “Statistics” here and ask for Descriptives for scale, items and scale if item deleted.2 v% a' l! u! g/ |
Create scales-          WHAT?SPSS,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,数据分析师,数据分析论坛,数据分析软件,spss13.0下载,SPSS教程,Spss视频amos ,sem analysis,spss function,spss net,spss software,spss statistical,数据分析师,数据分析论坛,数据分析软件,PLS,DEA,5 o/ p1 w% N# t  Y- _
Create the scales that you have just determined to be sound measurements of the variables you are measuring.
4 O/ u2 j; _+ u' H' h-          HOW?spsschina.cn# |* J. y. _! G
By adding the different items you have decided do belong together, or (preferably) computing the means of these sets of items. The advantage of using the means is that the scale will have scores between 1 to 5, and that you are able to compare the scores on different scales. Otherwise, you couldn’t compare the mean score on a scale consisting of 6 items (with scores ranging from 6 to 30) with the mean score on a scale with 8 items (with a range from 8 to 40).spsschina.cn* C& h$ L' N& Y% G. y4 Z
-          WHERE?
- d' {& A- p$ P. p+ O4 Fwww.spsschina.com ,spss论坛,数据分析,数据调查,市场调研,SPSS,PLS,DEA,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,spss是什么,spss13.0下载,SPSS教程,Spss视频,数据分析师,数据分析论坛,数据分析软件Transform  Compute
6 F" O8 u, J4 Q. Y9 _spsschina.cno   The “target variable” is the scale you are creating (for instance, “kshare”)./ ?" \& D( ^# O
o   The “numeric expression” would be the formula to create this scale, e.g.spss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|Eviews1 h' f. ?6 T2 i- H
§  Mean (kshare1, kshare2, kshare3,…, kshare8)
1 B* H4 X  n7 G+ _3 W' H1 cTest theory
4 Z- V& N  W9 s$ O; hThe previous steps have left you with a dataset in which all the key concepts are represented by scales that are valid measurements of these concepts. You now have a scale for each relevant concept, and of course the first few questions in the survey that provide you information on functions, departments, length of employment etc. You can now use these scales and other variables to test assumptions about differences and relationships.3 N9 J( S6 W+ x! Q: j
Test for differences-          WHAT?
9 y& j, d  U$ R! m# p/ f6 _spss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|EviewsIt is interesting to see whether (for instance) people fulfilling different positions in the organization score differently on relevant variables. Do high level experts share more knowledge than administrative personnel? Do managers have a more positive view of the organization than non-managers? Does IT have a more positive perception of IT performance than the business side?
5 m) I+ A, |/ }/ j( P* E8 k-          HOW?
0 G9 K, Z* A& Z" S  z( z. Z2 _* Dspss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|EviewsFor differences between two groups: Perform a t-test. If you’re comparing two groups, choose the independent samples t-test. The grouping variable is the variable based on which you make groups – for instance, function, where group 1 is managers and group 2 is non-managers. The test variables are the variables for which you want to test whether the groups score differently (for instance, knowledge sharing). Pay attention to the following criteria in the output:
, X0 K: Q: f5 C2 a8 G% c( yo   F-value and significance of F-value (undere “Levene’s test for Equality of Variances”). This value tells you nothing about the actual differences found, it basically tells you in which row of the output you should look for results. What’s tested here, is whether the variances of the scores of both groups on the test variable are equal or not. If they’re not, SPSS is extra cautious with a number of things. If the significance of this F-value is lower than .05, this means that the variances differ significantly – and that you can not assume that there are equal variances, in other words, you should look in the bottom row of the output. That’s where you look for the following statistics.
) q  u2 P. C! z1 V- I1 P& S* ISPSS,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,数据分析师,数据分析论坛,数据分析软件,spss13.0下载,SPSS教程,Spss视频amos ,sem analysis,spss function,spss net,spss software,spss statistical,数据分析师,数据分析论坛,数据分析软件,PLS,DEA,o   T-value: gives an indication of the strength of the difference.
1 D" g" i3 X: H5 @o   Degrees of freedom.
1 d0 h0 C8 ~, r$ @+ a& w1 {spss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|Eviewso   Significance of t-value: this is the decisive statistic. If the t-value is significant, this means that there is a significant difference between the groups – in other words, that (for instance) high level experts share more knowledge than administrative personnel.
! q8 y+ e! A! v  H& ]# S1 }-          For differences between more than two groups: Perform an analysis of variance (ANOVA). The “Factor” is the variable determining your groups (for instance, “department”), the “Dependent List” contains the variables for which you want to test whether there are differences between these groups (for instance, knowledge sharing). Pay attention to the following criteria in the output:spsschina.cn; Q3 _2 M8 C) ]: x
o   F-value and significance of F-value. For this test, this is the decisive statistic: If the F-value is significant, this means that you have found a significant difference between the groups on this variable. Look at the descriptives (you can click that in the menu for the ANOVA) to get more insight into the actual nature of these differences.spss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|Eviews7 `1 Y4 J' C4 c( y4 c+ u
o   The F-value and descriptives don’t provide a definitive insight into which of the groups you distinguish differ from each other. In order to be able to determine exactly which departments (for instance) score higher or lower than the other ones, click Post Hoc. Then, you can choose from a number of post hoc tests that do tell you which groups differ from each other. Common post hoc tests are LSD, Bonferroni and Tukey. LSD is relatively simple, as it performs a number of t-tests between each of the groups. If the F-value is not significant, doing a Post Hoc test does not make much sense. Then, the conclusion is that there are no differences.
) y8 S7 [8 ~- i- l' W. P! X. |. OSPSS,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,数据分析师,数据分析论坛,数据分析软件,spss13.0下载,SPSS教程,Spss视频amos ,sem analysis,spss function,spss net,spss software,spss statistical,数据分析师,数据分析论坛,数据分析软件,PLS,DEA,-          WHERE?spss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|Eviews* Z+ @9 f. b3 H( N4 U
o   T-test: Analyze  Compare Means  Independent Samples T-testwww.spsschina.com ,spss论坛,数据分析,数据调查,市场调研,SPSS,PLS,DEA,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,spss是什么,spss13.0下载,SPSS教程,Spss视频,数据分析师,数据分析论坛,数据分析软件- G+ ]: d: O% V* k* f6 X
o   ANOVA: Analyze  Compare Means  One-way ANOVA
# X0 |" ~! Z! `3 U- gspss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|Eviews§  Don’t forget Post Hoc
9 N- ?: w, \4 ~! N( Y. z$ PTest for relationships between variables-          WHAT?spss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|Eviews' T  d8 r- W  U/ k
Both theoretically and practically, you can have a lot of assumptions about relationships between variables. For instance, is a knowledge friendly organizational culture positively related to the level of relational social capital? Do the different dimensions of social capital explain the level of knowledge sharing in the organization?
) z2 r1 c& ^+ |8 L, E. s-          HOW?
: H$ V6 b7 D0 wCorrelations: If you’re only interested in the way variables are related, but not in the distinction between dependent and independent variables, you can compute correlations between these variables. Compute the Pearson correlation coefficient and see if the variables are positively related, negatively related, or not related at all. Pay attention to the following criteria in the output:6 ?2 p) Y% b' ^
o   Pearson’s r: this tells you the strength and direction of the relationship. If this statistic is 1, there is perfectly positive correlation, if it is -1, there is a perfectly negative correlation, and if it is 0, there is no correlation. In practice, of course, it will lie somewhere in between these extremes. There are a number of different views concerning what constitutes a strong or weak correlation, but the leading criterion is:$ ?( s% y& n4 l2 C" y9 s8 o0 |
o   The significance of this coefficient. If the level of significance is below .05 (p.05), the correlation is significant and we can conclude that the two variables are related.
: c( v: E9 p6 RSPSS,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,数据分析师,数据分析论坛,数据分析软件,spss13.0下载,SPSS教程,Spss视频amos ,sem analysis,spss function,spss net,spss software,spss statistical,数据分析师,数据分析论坛,数据分析软件,PLS,DEA,Regression analysis: Most of the time, you will be interested in the distinction between dependent and independent variables, and in the extent to which dependent variables are explained (or influenced) by these independent variables. Then, you will perform a regression analysis, which enables you to test a model like the following:www.spsschina.com ,spss论坛,数据分析,数据调查,市场调研,SPSS,PLS,DEA,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,spss是什么,spss13.0下载,SPSS教程,Spss视频,数据分析师,数据分析论坛,数据分析软件5 z/ K5 s. j1 t, \& ]% g5 {
Typically , Y will be what you enter in the “dependent” box, and X1, X2 and X3 will be entered in the “independents” box. In a regression analysis, pay attention to the following criteria in the output:0 [" V  o  N' a! q! ^8 L
o   (Adjusted) R-square. This tells you how much variance in the dependent variable is explained by the independents in your model. For instance, an R-square of .48 means that 48% of the variance in the dependent is explained by your model. There is some discussion whether you should look at the R-square itself or the Adjusted R-square, but since the latter is a more conservative estimate it is preferable to choose the Adjusted R-square.$ J2 ~5 v7 z9 n* Q+ Y) M
o   F-value and significance of F-value. Here, the F-value tells you whether the proportion of variance explained by your model is significant. In other words, whether the (Adj) R-square is significant, if the model has enough explanatory power to be valuable. If the F-value is not significant, that means it makes no sense to continue your analysis and you have to design a different model.spsschina.cn' Q8 t# b1 R* @3 D3 }
o   Betas and significance of Betas. The Beta can be compared to the correlation coefficient, and tells you how strong the relationship between your independent and dependent variable are, and what direction it has (positive or negative). Typically, Beta values will lie between -1 and 1, and the most important thing here is whether the Beta value is significant (p.05).
1 k5 ^3 I% H, j' e" }# `: s-          WHERE?www.spsschina.com ,spss论坛,数据分析,数据调查,市场调研,SPSS,PLS,DEA,spss下载,spss 下载,spss 教程,spss软件,spss中文版下载,spss免费下载,spss是什么,spss13.0下载,SPSS教程,Spss视频,数据分析师,数据分析论坛,数据分析软件  ~  H6 v6 r+ T6 f* E& I4 D; J! M
o   Analyze  Correlations  Bivariate9 P5 }9 @# h" S* `
o   Analyze  Regression  Linear

TOP

发新话题