Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Standard deviation | Excel Discussion (Misc queries) | |||
standard deviation | Charts and Charting in Excel | |||
standard deviation | Excel Discussion (Misc queries) | |||
Standard Deviation | Excel Worksheet Functions | |||
Standart deviation ? | Charts and Charting in Excel |