Tuesday, October 11, 2016

how to calculate cosine correlation coefficient using Excel 

=power(SUMPRODUCT(A1:A3,B1:B3),2)/SUMSQ(A1:A3)/SUMSQ(B1:B3)


reference: http://stackoverflow.com/questions/22715120/excel-scalar-product-of-two-ranges
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)