Correllation of Coefficient?

  • Thread starter Thread starter RickyDee
  • Start date Start date
R

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
 
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
 
Back
Top