Home

Pearson matrix correlation calculation in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-477474%22%20slang%3D%22en-US%22%3EPearson%20matrix%20correlation%20calculation%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-477474%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20use%20correlation%20to%20calculate%20r%20values%20for%20the%20following%20data%2C%20but%20calculated%20values%20are%20%22Div%2F0.%22%20Can%20anyone%20correct%20my%20improper%20setup%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%220%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E55%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E19%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E40%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E13%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E222%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E12%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E74%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E540%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E19%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E40%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E13%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E222%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E12%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E74%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E540%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E55%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E40%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E13%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E222%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E12%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E74%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E540%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E55%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E19%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E13%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E222%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E12%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E74%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E540%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E55%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E19%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E40%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E222%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E12%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E74%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E540%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E55%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E19%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E40%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E13%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E12%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E74%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E540%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E55%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E19%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E40%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E13%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E222%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E74%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E540%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E55%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E19%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E40%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E13%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E222%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E12%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E540%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E55%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E19%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E40%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E13%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E222%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E12%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3E74%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EJon%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-477474%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
jatkinson
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

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
7 Replies