I am using MS-Excel for the first time to evaluate Correlation. To learn it I made two sequences of one as shown below:
I understand I have selected range correctly (as can be seen in the correlation dialog box), but still I am getting #DIV/0! (I am expecting 1 here as the sequences are 100% similar) as can be seen here:
Appreciate your help in solving the issue.