Help to find relationship between two Data sets

[calof1]

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,

[#2]

@calof1 

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