ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   what does a high covariance mean? (https://www.excelbanter.com/excel-worksheet-functions/107427-what-does-high-covariance-mean.html)

jhuybregts

what does a high covariance mean?
 
Does a higher 'covariance' number indicate a greater disparity between 2 data
sets?

When I calculated 'correlation' for the same dataset, the stronger
correlation was actually found on those datasets that had higher covariance.
Hmmm.

pdberger

what does a high covariance mean?
 
jhuy --

Covariance ranges between +1 & -1. A covariance of +1 means a perfect
positive relationship (both go up at the same time); -1 means a perfect
negative relationship (one goes up and the other always goes down); 0 means
there's no relationship between movement of one and of the other.

So that supports your idea that covariance and correlation are high together.

HTH

"jhuybregts" wrote:

Does a higher 'covariance' number indicate a greater disparity between 2 data
sets?

When I calculated 'correlation' for the same dataset, the stronger
correlation was actually found on those datasets that had higher covariance.
Hmmm.



All times are GMT +1. The time now is 03:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com