Correllation of Coefficient?

[RickyDee]

Ummm, I'm a bit lost now. I just hope I've got this in
the correct newsgroup.

Ok, here goes. I'm trying to write a program using some
information a friend sent me. Now, this friend knows I'm
not quite THAT good, but his mind works a different way.

Problem lies when I've got a 3 number sequence. Say for
instance 12-9-2 (as in sports W-L-T). He comes up with a
percentage. He sends me this:

The coefficient of correlation between the teams' win-loss-
tie percentage (column A) and the average of Forecaster's
Total ranking (column B) is +0.972.

What the heck is he talking about?
Thank you,
R/
RickyDee

 

[pfsardella]

Loookat the CORREL worksheet function in help if you want to run
correlations between two sets of data.

If I remember correctly, the correlation coefficient's limits are -1
to +1. A number close to +1 means that the two data sets are highly
correlated: -1 means that the data sets are inversely correlated. Zero
shows no correlation between the two sets.

0.972 means that your data correlates strongly with whatever he's
comparing it to.

Paul