Talk:Documentation/Calc Functions/PEARSON

    From The Document Foundation Wiki

    SF comments

    (1) General. Please apply relevant comments raised on the page for CORREL() to this page. The pages for the two functions look like they should be very similar.
    (2) Summary. Is this intended to calculate the sample Pearson correlation coefficient? Also, please insert space before “(r)”.
    (3) Arguments, 2nd bullet. Please check if logical values are really ignored, or are TRUE/FALSE used as 1/0 respectively?
    (4) Additional details. I do not think the lower part of this equation looks correct – it may be missing a summation (see Eq. 3 on Wikipedia page). Also, why is this version different to that on the CORREL page?

    --Stevefanning (talk) 2020-10-29T23:26:43 (UTC)

    Ronnie

    all points addressed.

    --Ronnie rg8888 (talk) 2020-11-27T17:27:23 (UTC)