Functions - deviation
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 |
Functions - deviation
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 |
All times are GMT +1. The time now is 06:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com