Studying moderating effects in PLS Path Modeling with XLSTAT-PLSPM

Conjunto de datos para Aproximación PLS PPMX258 KB

Vídeo de tutorial

Ventajas

  • Sencillo y dirigido a los usuarios
    Sencillo y dirigido a los usuarios XLSTAT es un software que se integra de forma transparente con Microsoft Excel, que es la hoja de cálculo más difundida del mundo. Esta integración hace que sea una de las herramientas más sencillas para trabajar ya que utiliza la misma filosofía que Microsoft Excel. El programa está disponible en una ficha de XLSTAT. Los análisis se agrupan en menús funcionales. Los cuadros de diálogo están dirigidos a los usuarios, por lo que la preparación de los análisis es tarea sencilla.
  • Resultados y datos compartidos sin dificultad
    Resultados y datos compartidos sin dificultad Una de las mayores ventajas de XLSTAT es la forma transparente con la que se pueden compartir los datos y los resultados. Los resultados se almacenan en Microsoft Excel de modo que cualquier usuario puede acceder a ellos. No es necesario que el destinatario tenga una licencia de XLSTAT o cualquier visor adicional, lo que facilita y rentabiliza el trabajo en equipo. Del mismo modo, es fácil integrar los resultados en otras aplicaciones de Microsoft Office, como PowerPoint, por lo que se pueden crear estupendas presentaciones en cuestión de minutos.
  • Modular
    Modular XLSTAT es un producto modular. XLSTAT-Pro es un módulo principal de estadística de XLSTAT, que incluye todas las funcionalidades dominantes en el análisis estadístico y multivariado. Es posible añadir funciones más avanzadas por medio de módulos complementarios para aplicaciones específicas. De este modo es posible adaptar el software a sus necesidades, aumentando la rentabilidad.
  • Didáctico
    Didáctico Los resultados de XLSTAT están organizados por análisis y es fácil desplazarse por ellos. La información útil se proporciona junto con los resultados para ayudarle en su interpretación.
  • Asequible
    Asequible XLSTAT es una solución completa y modular que se puede ajustar a cualquier necesidad de análisis comercial. Tiene un precio muy razonable, por lo que el retorno de su inversión es casi inmediato. Todas las licencias de XLSTAT incluyen también un servicio de asistencia de la mayor calidad.
  • Accesible: disponible en muchos idiomas
    Accesible: disponible en muchos idiomas Nos hemos asegurado de que XLSTAT sea accesible para todos traduciendo el programa a muchos idiomas, incluyendo chino, inglés, alemán, italiano, japonés, polaco, portugués y español.
  • Automatizable y personalizable
    Automatizable y personalizable La mayoría de las funciones estadísticas disponibles en XLSTAT pueden llamarse directamente desde la ventana Visual Basic de Microsoft Excel. Pueden modificarse e integrarse en código fuente adicional para ajustarse a sus necesidades. Añadir tablas y trazados, así como modificar los resultados existentes se convierte en tarea sencilla. Además, XLSTAT incluye algunas herramientas especiales en los cuadros de diálogo para generar automáticamente el código fuente VBA para reproducir su análisis empleando el editor de VBA o simplemente cargar ajustes predeterminados. Esta automatización de análisis rutinarios sin esfuerzo le ahorrará gran cantidad de tiempo.

Moderating effects in PLS path modelling

In this tutorial, we present an application of the study of moderating effects. If you are not familiar with PLS Path Modeling, please refer to the tutorial: “Creating and running a basic XLSTAT-PLSPM project” More detailed explanations are available in the help of XLSTAT.

With XLSTAT, you can analyse moderating effects within a PLS model.

Two main approaches are used to identify and measure moderating effects in PLS Path Modeling:

  • The direct approach which is automatic in XLSTAT-PLSPM.
  • The two-step approach which need a two-step process in XLSTAT-PLSPM.

Moderating effects are very important in PLS Path Modeling. “In general terms, a moderator can be a qualitative (e.g., sex, race, class) or quantitative (e.g., level of reward) variable that affects the direction and/or strength of the relation between an independent or predictor variable and a dependent or criterion variable” (Baron/Kenny 1986 p 1174)

The effect of a moderator variable on the relation between two variables is called a “moderating effect” or an “interaction effect”. In the case of a qualitative moderating variable, the group comparison approach can be used (see tutorial on group comparison with XLSTAT-PLSPM). When the moderating variable is quantitative, an interaction latent variable is used.

Let A, B and C be three latent variables, we want to understand the moderating effect of B on the relation between A and C. We will have the following model:

 model moderating effect

The latent variables are A, B, C and A*B which is the interaction term. It is used to understand the strength of the moderating effect.

There are two methods for building the interaction latent variable:

  • The Product‐Indicator Approach:
    • Based on Kenny/Judd (1984) and Chin/Marcolin/ Newsted (1996, 2003).
    • Mode A (arrows outwards) has to be used.
    • Procedure:
      • Each of the g indicators of the exogenous variable is elementwise multiplied with each of the h indicators of the moderator variable, resulting in g*h product indicators.
      • These product indicators serve as indicators of the interaction term.
  • Two‐Stage Approach:
    • Chin/Marcolin/ Newsted (2003, online appendix).
    • Feasible for every Mode (Mode A, Mode B, Mode MIMIC, Mode PLS, Mode PCA).
    • Procedure:
      • Run the main effect model.
      • Extract the latent variable scores.
      • Use these latent variable scores as indicators of the exogenous and endogenous variables.
      • The elementwise product of the latent variable scores of the exogenous variable and the moderator variable serves as the indicator of the interaction term.

These two approaches can be used in XLSTAT-PLSPM, we will detail the application of each one.

Dataset to study moderating effects

We will use a part of the data used in the general tutorial on how to use XLSTAT-PLSPM. It is based on the ECSI model with a sample of 250 observations. The new file can be downloaded here. Note that this tutorial is only available for users of Excel 2007 and Excel 2010.

We want to study the moderating effect of the image of a mobile phone provider on the relation between satisfaction and loyalty of the customers.

Setting up the moderating effects for PLS path modelling

First of all, you have to switch to the expert display. In the XLSTAT-PLSPM menu, click on XLSTAT-PLSPM options.

plspmrebus1.gif

This dialog box appears:

plspmrebus2.gif

Select the expert display and save your settings. As in the general tutorial, we build a special model only including Image, Satisfaction and loyalty using the PLSPMGraph sheet and the “Path Modeling” toolbar. 

 simple model plspm

Once the model has been drawn, two approaches are available to study moderating effects.

The product indicator approach

This approach can be automatically applied in XLSTAT-PLSPM. First, add a latent variable to the model and click on the toolbar button to define the latent variable. The following dialog box appears.

 Dialog box manifest variables plspm

Instead of selecting data, click on the interaction button. A new tab is reachable in the dialog box. In the interaction tab, select the two exogenous variables which are image and satisfaction. We decide to standardize the manifest variables.

 dialog box manifest variables interaction

 Then, click on the "Ok" button. A new latent variable appears on the diagram with 6 manifest variables being the products of the manifest variables associated to satisfaction and image.

 model interaction variable plspm

You can now click on the run button of the XLSTAT-PLSPM bar located on the PLSPMGraph sheet. The run dialog box appears. In this tutorial, we will choose to standardize the manifest variables in the general tab.

 dialog box general run

In the options tab, we use the centroid scheme with OLS regression with no bootstrap. In the outputs tab, we ask for Standardized latent variables score.

 dialog box run outputs

Once you click on the "Ok" button, the computation starts.

The results are displayed on the PLSPM sheet of the workbook and can be seen on the diagram.

The most important result can be found in the path coefficients table.

results: path coefficients moderating 

We see that image and satisfaction have a positive effect on loyalty and that the interaction term has a non significant negative effect. That means that the moderating effect of image on the relation between satisfaction and loyalty is not significant.

The two-stage approach

If you already have applied the product indicator approach, first delete the interaction latent variable and launch XLSTAT-PLSPM using the run button of the toolbar located on the PLSPMGraph sheet.

The Run dialog box appears. We choose to standardize the manifest variables in the general tab.

 dialog box general run 

In the options tab, we use the centroid scheme with OLS regression and no bootstrap. In the outputs tab, we ask for Standardized latent variables score.

  dialog box run outputs

 Once you click on the "Ok" button, the computation starts.

The results are displayed on the PLSPM1 sheet of the workbook and can be seen on the diagram.

We are only interested in the latent variables scores for the simple model. In the PLSPM1 sheet, we compute the product of the latent variables Satisfaction and Image using Excel formulas next to the latent variable scores table.

latent variables two stage moderating 

 Then, we change the definition of the latent variable, replacing the manifest variables by the latent variable scores that can be selected in the PLSPM1 sheet. We add a latent variable with only one manifest variable being the new column. The new model has the following form:

 model two stage moderating plspm

 You can now run the model with the same parameters as before and study the results. The path coefficients are the most important results.

path coefficients moderating two stage

We see that image and satisfaction have a positive effect on loyalty and that the interaction term has a non significant negative effect. That means that the moderating effect of image on the relation between satisfaction and loyalty is not significant.