Pearson matrix correlation calculation in Excel

Highlighted
Occasional Visitor

I am trying to use correlation to calculate r values for the following data, but calculated values are "Div/0." Can anyone correct my improper setup?

 

551940132221274540
194013222127454055
401322212745405519
132221274540551940
222127454055194013
127454055194013222
745405519401322212
540551940132221274

Thanks,

Jon

0 Replies