1. Download MG-PLS here.
2. Open the file in Microsoft Excel.
3. Enable Macros when it is opening.
MG-PLS beta is a two-in-one excel based tool for computing multi-group analyses of partial least squared path analysis (or sometimes I call it variance-based structural equation modeling). There are two types of multi-group analyses that MG-PLS can handle. The computation of the first test is derived from the pairwise group difference test proposed by Henseler's (2007). The other test is based on Omnibus test of group difference documented in Sarstedt, Henseler, and Ringle (2011). Omnibus Test is so far the first test in the literature that is proposed to be able to reveal the statistical significance of group differences between three or more groups. In MG-PLS, it is able to test the group difference of parameter estimates between up to 5 groups simultaneously.
It is important to clarify that MG-PLS is unable to compute or estimate any parameter estimates from the partial least squared algorithm. Rather it relies on the boostrapped parameter estimates generated from other partial least squared modeling softwares such as SmartPLS, WarpPLS.
Also, the excel "program" only simulates the formulas proposed by the literatures, so there might be some degree of discrepancy between the result produced by MG-PLS and that generated by the scripts (run in R or other language platforms) of the authors. I did some initial tests and found the MG-PLS is able produce the result almost identical to Henseler's (2007) results. However, I am still not fully confident if MG-PLS is able to perform Omnibus test reliably because it requires a Monte-Carlo resampling procedure in the permutation process, which I am not sure excel is able to perform as other programs do. Also, I realise that the results of Omnibus test produced by MG-PLS tend to be over sensitive (very easy to reach statistical significance).
References:
Henseler, J. (2007). A new and simple approach to multi-group analysis in partial least squares path modeling. In: H. Martens & T. Næs (Eds.), Causalities explored by indirect observation: Proceedings of the 5th international symposium on PLS and related methods (PLS’07) (pp. 104–107). Oslo.
The citation looks funny because it's not a software. However, I would be appreciated if you let me know you are using it.
Chan, D. K. C. (2014). MG-PLS [Computer software]. Available from www.derwinchan.com.