PEARSON

[nicolas11Z]

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:
=PEARSON($matríz1$;$matríz2$)

[#2]

@nicolas11Z 

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.