Why do I get '0' as a correlation coefficient for the following data sets, Set A and Set B? Is it correct? Where am I wrong?
Why do I get '0' as a correlation coefficient for the following data sets, Set A and Set B? Is it correct? Where am I wrong?
It's correct.
In E3 and copy down, =(B3 - AVERAGE($B$3:$B$12)) * (C3 - AVERAGE(C$3:C$12))
The total of those values in the numerator of the CORREL function, and it's zero.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks