I am very happy to see that people can actually progress in their work and get few advices online to use SPSS effectively!
I am Yafaa Sofia Ahres, currently working on a Project for my MSc. I have to use SPSS and the PLS Regression too. I would like to get few advices and guidelines, as I never used this before. I have the Julie Pallant's Book ''SPSS Survival Manual'' it's a huge help, I know how to do many things on SPSS now thanks to her; but unfortunately there's no chapter for PLS Regression ... Therefore, if anyone can share his/her knowledge and expertise that will be great.
I am basically following the Framework/ Research Methodology of Reinartz et al. (2004; see article below via Web-link
• A dependent variable is named ‘’objective performance’’; its value is 0.045, which represents the average return on asset of the years 2011 and 2012. I tried to enter its value (0.045) into ‘’Variable View’’ and precisely ‘’Values’’, but for some reason 0.045 is changed to 0.
Could you please advise me on how to enter this variable with its correct value and measure?
• Another issue is that, when I obtained few tables corresponded to ‘’Descriptive Statistics’’, Pearson etc., all the items (statement part of my questionnaire) and variables entered in SPSS ‘’Variable View’’ were included and listed in these tables.
⇒ I would like to know how to obtain the tables but with only the construct and not all the items that form the construct/scale (like in the summary statistics for the measurement scales in Reinartz et al 2004 journal article shared in this email) for:
- Descriptive Statistics (with Mean, Standard deviation. Minimum, Maximum etc.)
- Cronbach Alpha for Reliability Analysis.
- Pearson correlation and Spearman correlation.
After downloading the extension module (which was not really easy), I am trying to run PLS in SPSS considering the Equation (1), the Model 1 & 2 (see above and/or article provided) and the standardised PLS coefficients (provided by the authors for the construct model).
⇒ If you could give me some guidelines to run PLS correctly that will be fantastic; I have tried many times and no success..
• Equation (1):
(1) Economic performance =
+ β1 relationship initiation
+ β2 relationship maintenance
+ β3 relationship termination
+ β4 CRM-compatible organizational alignment
+ β5 CRM technology
+ γ1 (CRM-compatible organizational alignment x relationship initiation)
+ γ2 (CRM-compatible organizational alignment x relationship maintenance)
+ γ3 (CRM-compatible organizational alignment x relationship termination)
+ γ4 (CRM technology x relationship initiation)
+ γ5 (CRM technology x relationship maintenance)
+ γ6 (CRM technology x relationship termination)
+ σ1 Investment banks 1
+ σ2 Investment banks 2
+ σ3 Investment banks 3
+ σ4 Investment banks 4
Variables are grouped into:
• Main effects (β)
• Interaction effect (γ)
• Control variables (σ)
Formative multi-item measures:
• Relationship initiation, maintenance, relationship termination
• CRM-compatible organizational alignment
• CRM technology.
Subject to the economic performance (both objective and perceptual) we obtain two different models:
• MODEL 1: Economic performance (perceptual)= f(covariates
• MODEL 2: Economic Performance (objective)= f(covariates
• Standardised PLS coefficients:
.389 X IMEASURE + .379 X ACQUISIT + .375 X REGAINTRUST
.283 X MMEASURE + .340 X RETAIN + .388 X CROSS_UP + .267 X REFERRAL
.367 X TMEASURE + .759 X EXIT
• The Survival Book does not explain how to run ''Square roots of Average Variance Extracted (AVE) in the diagonal''; I am currently trying to find it out via blogs, YouTube etc. If anyone could share the steps to obtain AVE that will be nice.
• Histograms, Bar Graphs, Boxplot, Line Graphs, Scatterplots etc. are easy to obtain, but for how can I select several variables at the same time.
⇒ I would like to know how I could obtain the general construct instead of every single variable that form the he construct/scale.
• I plan to use the Spearman rho and/or Pearson correlation for the Correlation Analysis; however, the Journal article provided above does not include this correlation analysis.
⇒ Therefore, I would like to know if it is worthwhile to conduct a Correlation Analysis utilising Pearson, Spearman rho. In my opinion, it is as it allows to determining the direction of the relationship between the variables, and the strength of the relationship; but also calculating the coefficient of determination and assessing the significance level.
Many thanks; any assistance would be greatly appreciated.
Many thanks again!