Comparing groups with XLSTAT-PLSPM

Dataset for PLS Path Modelling PPM396 KB

Tutorial video
  • PLSPM PLS Path Modelling software

  • System configuration

    • Windows:
      • Versions: 9x/Me/NT/2000/XP/Vista/Win 7
      • Excel: 97 and later
      • Processor: 32 or 64 bits
      • Hard disk: 150 Mb

Benefits

  • Easy and user-friendly
    Easy and user-friendly XLSTAT is flawlessly integrated with Microsoft Excel which is the most popular spreadsheet worldwide. This integration makes it one of the simplest available tools to work with as it utilizes the same philosophy as Microsoft Excel. The program is accessible in a dedicated XLSTAT tab. The analyses are grouped into functional menus. The dialog boxes are user-friendly and setting up an analysis is straightforward.
  • Data and results shared seamlessly
    Data and results shared seamlessly One of the greatest advantages of XLSTAT is the way you can share data and results seamlessly. As the results are stored in Microsoft Excel, anyone can access them. There is no need for the receiver to have an XLSTAT license or any additional viewer which makes your team-work easier and more affordable. In addition, results are easily integrable into other Microsoft Office software such as PowerPoint, so that you can create striking presentation in minutes.
  • Modular
    Modular XLSTAT is a modular product. XLSTAT-Pro is a core statistical module of XLSTAT which includes all the mainstream functionalities in statistics and multivariate analysis. More advanced features contained in add-on modules can be added for specific applications. This way you can adapt the software to your needs making the software more cost-efficient.
  • Didactic
    Didactic The results of XLSTAT are organized by analysis and are easy to navigate. Moreover useful information is provided along with the results to assist you in your interpretation.
  • Affordable
    Affordable XLSTAT is a complete and modular analytical solution that can suit any analytical business needs. It is very reasonably priced so that the return of your investment is almost immediate. Any XLSTAT license comes with top level support and assistance.
  • Accessible - Available in many languages
    Accessible - Available in many languages We have ensured XLSTAT is accessible to everyone by making the program available in many languages, including Chinese, English, French, German, Italian, Japanese, Polish, Portuguese and Spanish.
  • Automatable and customizable
    Automatable and customizable Most of the statistical functions available in XLSTAT can be called directly from the Visual Basic window of Microsoft Excel. They can be modified and integrated to more code to fit to the specificity of your domain. Adding tables and plots as well as modifying existing outputs becomes easy. Furthermore, XLSTAT includes some special tools on the dialog boxes to generate automatically the VBA code in order to reproduce your analysis using the VBA editor or to simply load pre-set settings. This effortless automation of routine analysis will be a huge time saver on your part.

XLSTAT is the first software to offer multigroup comparison methods in the framework of PLS Path Modeling presented by Wynne Chin (2005).

In this tutorial, we present an application of multigroup tests when a path model is defined. If you are not familiar with PLS Path Modeling, please refer to the tutorial: “Creating and running a basic XLSTAT-PLSPM project?” Two tests in order to compare parameters between groups are included in XLSTAT-PLSPM:

  • An adapted t test based on bootstrap standard errors. For two groups and a path coefficient beta : PLSPMGR7.gif Where n1 and n2 are the sizes of the groups and SE’² is the variance of coefficient beta obtained using the bootstrap sampling. This would follow a t-distribution with n1+n2-2 degrees of freedom. This approach works reasonably well if the two samples are not too non normal and the two variances are not too different from one another.
  • A permutation test (randomization test): It uses a statistic S to compare parameters. This statistic is computed on the original samples and samples are permuted. The original S is compared to each permuted S in order to obtain a p-value: PLSPMGR8.gif This test offers a good non parametric alternative to the t test.

The hypotheses to be tested are:

  • H0: parameters are not significantly different
  • Ha: parameters are significantly different

More detailed explanations are available in the help of XLSTAT.

Group comparison with XLSTAT-PLSPM

We will use the same data as in the general tutorial on how to use XLSTAT-PLSPM. It is based on the ECSI model with a sample of 250 observations. A grouping variable has been added. The new file can be downloaded here.

First of all, you have to switch to the expert display. In the XLSTAT-PLSPM toolbar, click on “XLSTAT-PLSPM options”. This dialog box appears: PLSPMGR2.gif

Select the expert display and save your settings. As in the general tutorial build the ECSI model using the PLSPMGraph sheet and the “Path Modeling” toolbar. PLSPMGR1.gif

Click on “define groups” in the “path modelling” toolbar. Select the “group” variable in order to define groups: PLSPMGR3.gif

Click on “run” in the “path modelling” toolbar. A new tab called “multigroup tests” has appeared: PLSPMGR4.gif

Select the multigroup t test. The number of bootstrap resamples is defined in the “options” tab with the confidence intervals. Note: If confidence intervals are not estimated using bootstrap, the multigroup t test cannot be run.

Select the permutation test; adjust the number of permutation and the significance level of the test. Many parameters can be compared: path coefficients, standardized loadings and model quality indexes (communalities, redundancies and GoF).

Note: If the number of groups is larger then two, the permutation test cannot be run.

Results and outputs of a multigroup comparison with XLSTAT-PLSPM

If groups and mutigroup tests are selected, some new outputs are available:

  • Worksheet PLSPM(Group): For each group, complete results are displayed in separated worksheets.
  • Worksheet PLSPM(Multigroup t test): For each path coefficient, results of the t test are summarized in a table. Each line represents a pair of groups.
  • Worksheet PLSPM(Permutation test): For each type of parameter, results of the permutation test are summarized in a table.

The two first sheets can be analyzed independently using the general method described in the XLSTAT-PLSPM tutorial.

The groups have been selected using the question: How well do you think “your mobile phone provider” compares with your ideal mobile phone provider?

Results of the multigroup t test are the following:

PLSPMGR5.gif

Results of the multigroup permutation test are the following:

PLSPMGR6.gif

These two tests results show a significant difference between the groups for two path coefficients:

  • the arrow between perceived value and satisfaction
  • the arrow between satisfaction and loyalty

The second one has a strategic impact in marketing studies and experts should pay a special attention to people answering negatively to the grouping question.