Functions - deviation

[rraybould]

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

 

[Max]

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