One thought - CORREL?
Eg: =CORREL(A2:A6,B2:B6)
would return the Correlation coefficient
of the two numeric series in A2:A6 and B2:B6
The closer it is to 1, the better the correlation between the 2 series
Voila? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"rraybould" wrote:
I want to test a two series of numbers to see how closely the ORDER of each
series is to the other that is how far one Order deviates from the other.
Does Excel have a function that does this please.
Thanks rraybould