Forum Discussion
Help to find relationship between two Data sets
Hi All. I have two lines of data, being the price, and account movement for each day. I wish to find the relationship between price and volume of units traded. I wish to identify for which custom...
Hey !
You might want to re-evaluate your problem definition (Is it worthwhile?)
There are 4 variables a) Price b) Units. c) Dates & d) Holder Id
Anyone outlier can vitiate any semblance of a relationship that you might develop
example
a)heavy movements for days wen there is no price movement refer cell P694 in Sheet1 Pivot
b) one Holder Id (say a Day Trader) might vitiate any results refer Sheet3 Holder Id
| S00097021912 |
movements for all days
I suggest you redefine your problem definition
Hope it makes sense or else you can disregard completely
Cheers