Bootstrapping: Exclude Samples From Excel Output

Feel free to post your requests for new SmartPLS features and other suggestions.
Post Reply
PLS Junior User
Posts: 3
Joined: Mon Jun 18, 2018 12:16 am
Real name and title: Saradhi Motamarri (Mr)

Bootstrapping: Exclude Samples From Excel Output

Post by msaradhi » Mon Jan 21, 2019 3:22 am

I notice that when we use the option 'Export to Excel' especially for the bootstrapping results, it resultant Excel file is too large.
The reasons seems it exports the 5,000 (or whatever may be the number chosen) samples as well to the Excel file.

Not sure where this data will be useful? And
Is there any trigger to exclude samples while exporting?

Thank you for your valuable advice.
Regards, Saradhi.

SmartPLS Developer
Posts: 990
Joined: Tue Mar 28, 2006 11:09 am
Real name and title: Dr. Jan-Michael Becker

Re: Bootstrapping: Exclude Samples From Excel Output

Post by jmbecker » Mon Jan 21, 2019 8:42 am

Why it might be useful?
To calculate some extra statistics/parameters and use the bootstrap sampling distribution to assess their significance. For example, whether two path coefficients are significant can be assessed by looking at the significance of the difference between the two using these samples. Other examples include simple slopes and Johnson-Neyman points in moderation analysis.

When you export to excel the "Exclude large matrices" option could also help to prevent to include the samples matrix, if it is too large.
Dr. Jan-Michael Becker, University of Cologne, SmartPLS Developer
Researchgate: ... v=hdr_xprf
GoogleScholar: ... AAAJ&hl=de

Post Reply