CORREL of % vs Total Numbers

Hi,

I have a question about correlation. We are looking at Website Actions (Represented as Goal #) and Correlation to a specific Goal (Represented as SV). We have the total count of each action as well as a conversion rate of each action. When comparing the conversion RATES, the correlation is close to 0, but when looking at the correlation of the total amounts, it's closer to 100%. I can't wrap my head around why this is... does it have to do with how I'm calculating it? How the Formula works? Hoping someone could help.

So to clarify, Why is the CORREL formula saying that two rates are not correlated, but the total numbers are?

Thanks in advance!

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

If in doubt... draw a picture (sheet 2). You will see that 3 values are probably skewing the whole thing. They are in the first 100 rows and have been highlighted in orange.

Even if they are removed, there is little or no correlation. Looks like your variables are unrrelated.

Yes... but IMHO the conclusion is that clicks are unrelated to the other parameters which do correlate.

How are clicks related to goals?

Stating the obvious but in seeking to compare different correlations it seems to me that one of the data sets should be consistent for each correlation.
L6, L9, L12 & L15 all use column G as the common data set but L3 doesn't. Admittedly it uses column I which in turn uses column G in its calculation but it also modifies this by dividing by the column B clicks, which comes back to the question above.

Why do some clicks exceed the number of goals and others don't. I'd need to understand a bit more about what your data is measuring to comment a bot more.

For instance if in column J you divided G by H you'd get 66% which given goal 13 is the largest number of goals might more accurately reflect the correlation, but as I say we really need to know more about the data. An obvious question is how was the goal SV column G constructed in the first place?