Talk:Documentation/Calc Functions/PEARSON
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)