Hi everyone,

If you list a column of any data, try to calculate CORREL for same
column (i.e., against itself), you get 1 (which is correct).

Now, try to calculate COVAR for that column (also against itself), and
STDEV. then try to get Correlation using COVAR/(STDEV^2) you don't get
1?!

What is the problem here? Shouldn't both get you 1?

Thanks,
Mike