[Libreoffice-bugs] [Bug 130835] New: Adding multivariate correlation analysis for nominal and parametric variables

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=130835

            Bug ID: 130835
           Summary: Adding multivariate correlation analysis for nominal
                    and parametric variables
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: f.s.farimani at gmail.com

Following this Tweet thread:

https://twitter.com/fsfarimani/status/1230626806484684801?s=20

I was asked 

https://www.reddit.com/r/libreoffice/comments/f71fgu/proposal_implementing_the_johnsonneyman_technique/fi9mu4q?utm_source=share&utm_medium=web2x

to open a feature request here.

Basically, the issue is that for multivariate correlation analysis at the
moment Andrew F. Hayes 's SPSS macro, PROCESS, is the de facto tool used in the
practice. As truly mentioned in this paper by Carden et al:

https://www.frontiersin.org/articles/10.3389/fpsyg.2017.01293/full


"There do exist a handful of ready-made solutions for implementing
[Johnson-Neyman Technique] JN, but they suffer from one of several drawbacks.
First, the highest-quality existing implementations are for software solutions
requiring expensive licenses. The best known is the PROCESS add-on (Hayes,
2013b) for SAS and SPSS. There are a few problems with this. First, some
researchers do not have access to SAS or SPSS, which are prohibitively
expensive. ... To be sure, there are free solutions, but they suffer from at
least one of the following drawbacks: the graphics are of bad quality, the
process is not streamlined in that it requires the user to complete the linear
regression and creation of the JN figure separately, or the user experience is
intimidating to those without programming experience. For example, the probemod
package (Tan, 2015) for R produces a graphic that would require considerable
editing before being suitable for publication, and the linear regression must
be completed separately beforehand, so the process is not as streamlined as it
could be. The “rockchalk” package (Johnson, 2016) produces a higher-quality
graphic but still requires the linear regression to be completed beforehand.
Last but not least, Kristopher Preacher maintains the website www.quantpsy.org
(Preacher et al., 2006) that allows one to run the JN technique. However, the
user must manually enter the coefficients, coefficient variances, and so forth.
As these must come from a software program, such as SPSS, one must toggle
between software and website. Thus, it is not as seamless as it could be, and
it may be prone to error when users enter their coefficients. Additionally, the
site produces figures that are not publication-ready."

the situation for multivariate correlation analysis is pretty cumbersome.
However, Condal et al., in my humble opinion, cease to address the concerns and
surprisingly try to replace one proprietary software, SPSS, with another,
Microsoft Excel:


"CAHOST, our workbook for implementing JN, is freely available, familiar to
researchers of all levels, automates the linear regression, and produces
publication-ready graphics."


Similarly, many people don't have access to the expensive MS products or, like
me detest using any proprietary software at all. So here my proposal is to
reimplement Hayes's PROCESS macro for LibreOffice Calc. Some of the Free,
Libre, And Open Sorce (FLOSS) reimplementations of the methodology are:

1. Quentin André Python library PyProcessMacro
https://github.com/QuentinAndre/pyprocessmacro
2. R package processR by Keon-Woong Moon:
https://github.com/cardiomoon/processR
3. processr R package by Mark White: https://github.com/markhwhiteii/processr/

This I believe would significantly increase LibreOffocice's user base,
especially in the humanities who are, stereotypically, more convenient with GUI
programs rather than programing languages.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200221/b4e6e19d/attachment.htm>