Saving PC scores
Hi, I'm trying to save the PC scores of my analysis to the Excel sheet so I can use them for further analysis, but the SUMPRODUCT workaround suggested on this forum (in 2018) doesn't work. For starters, I (nor Excel) have no clue what exactly I am referring to when specifying the array [1,2,3,4]. Could someone help me out?
Thanks!
Comments
Hi Gentianman, I'm not sure to understand what is your problem. Can you explicitly described what you want to copy to Excel (which analysis, which results, which OS you use)? I have just tried to copy-paste a table produced by an analysis in JASP to an Excel sheet, and that works without problem.
BTW: if you have an issue specific to JASP, it is then better to make an issue in GitHub (https://github.com/jasp-stats/jasp-issues/issues).
Bruno
Hi Bruno, I performed a PCA in JASP (on Mac Big Sur) and the analysis worked fine. However, I normally save the scores of the samples for each of the relevant Principal Components as new variables, but can't do this in JASP.
I found a similar question about this in the Discussions on this forum, where it was suggested that the scores can be computed (https://forum.cogsci.nl/discussion/4492/jasp-cannot-save-pca-components-to-variables). However, the suggested method does not work, and it is not clear to me what the function SUMPRODUCTS mentioned in the reply refers to.
On GitHub, I saw that there was a similar question 27 days ago (https://github.com/jasp-stats/jasp-issues/issues/1319#issuecomment-852145248) and the reply said "There is an open issue for this, but this is, unfortunately, more complicated than it sounds." Hence, it seems that this issue is known and probably people are trying to solve it...
Thanks for your answer!
OK it's clearer now. Don't hesitate to add your comments in the GitHub issue.