Bootstrapping: Exclude Samples From Excel Output

This forum is closed, and read-only.
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 »

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: 1287
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 »

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, BI Norwegian Business School, SmartPLS Developer
GoogleScholar: ... AAAJ&hl=de