Occasional Visitor

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 PEARSON, da como resultado #¡DIV/0!. Como puedo solucionar este erro si el orden de la fórmula está bien, ejemplo:

1 Reply


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.