| 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 | |||
Hybrid Mode
