Forum Discussion
PEARSON
When using the PEARSON formula, it returns #DIV/0!. How can I solve this error if the order of the formula is correct, example: =PEARSON($array1$;$array2$) Al momento de utilizar la fórmula PEARS...
The only explanation I can think of is that one of the arrays contains only one unique value (i.e. all values are the same). If that is not the case:
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.