Before you ask, this is for WORK. I am not at school.
I have a two columns of data,
Date Number
Date Number
Date Number
Date Number
and
Date Number2
Date Number2
Date Number2
Date Number2
Now, the dates match up. What I want to do is normalise the second column with the data on the first.
So I want the Number2 to be normalise to consider the number in column 1.
For example, Number in column 1 represents "spending on adwords". Number2 in column 2 represents click throughs on adwords. What i want to do is normalise the click throughs so that they are adjusted in line with how much was spent that week. I.e. if we spent £50 and got 100 click throughs on week 1, and then £20 and got 200 click throughs on week 2, I want this to be shown.
Does that make senese? Can anyone help me? I've googled it to no avail!
Cookies for all!
Space for rent. Contact me for rates!
hehe
