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 customers this is a stronger relationship for.
I have data for 6 weeks with unit movement and price. Does anyone know how i a can find/examine the relationship between these two variables? I have seen excel, has a data analysis pack but unsure to how use for this scenario.
Any help would be greatly appreciated.
Many thanks,
1 Reply
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
