Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sun, 11 Nov 2007 18:56:01 -0800 from Eric
: "Stan Brown" wrote: Sun, 11 Nov 2007 17:54:04 -0800 from Eric : Does anyone have any suggestions on how to determine the strength on correlation between two lists of numbers? Insert | Function and type Correlation in the search box. Thank you very much for your suggestions If two lists of numbers are different in scale, do you have any suggestions on how to fix it before performing correlation? For example, List 1 : 3,5,4,7,8,2,5,6,7,8 List 1 : 44,66,54,78,34,87,95,34,67,87 There's nothing to "fix". The data are what they are. Maybe you said "correlation" but actually meant something else? -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
20 different numbers want excel to determine which combo add to x | Excel Discussion (Misc queries) | |||
How to determine the prime numbers? | Excel Discussion (Misc queries) | |||
How to determine the formula to generate following numbers? | Excel Discussion (Misc queries) | |||
I'm trying to determine how a series of dropdown lists were creat. | Excel Discussion (Misc queries) | |||
how to do a correlation of numbers? | Excel Worksheet Functions |