Calculating Correlation Between Two Series of Data

[JungleJme]

Hi,

I'm not a statistician and am an intermediate user of Excel but i want to take my knowledge to the next level and i think this could be a nice introduction!

I have a list with hundreds of customers. Each customer has two measures (i won't bore you with how they are calculated)

1) % Coverage by Salesman
2) % Of Opportunity Won

What tips and tricks can you give me to take my analysis to the next level? The example is a very limited sample and the data was made up using a formula so correlated very well, i've chucked in a couple of anamlous results to make it a bit more realistic.

One of the main things i would like to see is a correlation "score". I suppose if the two series correlated perfectly then the score would be 100%. The less they correlate, then the lower this score gets....any idea how i can figure that out?

In business terms, if i can run this rule over thousands of customers and get a good correlation - then it becomes a conversation with the salesman to show them that doing those pesky, boring coverage calls has a measurable impact on sales...and here is the number to prove it...

Anyway, that's just one idea. Anyone got any other ideas of how i can interpret this data?

Any helps or hints would be greatly appreciated!

J