Share on Facebook Share on Twitter Share on Google+ Share on Reddit Share on Pinterest Share on Linkedin Share on Tumblr ‘What does covariance tell us’ In mathematics and Statistics, Covariance gives the directional relationship between the two variables. It means covariance tell us how one variable changes are associated with the second variable. Covariance can be calculated by analyzing the correlation between the two variables by each variable’s standard deviation. Table of Contents The Covariance FormulaVideo: Calculate the correlation coefficient by using ExcelAdvantages of the Correlation CoefficientWhat is the difference between covariance and correlation?Is covariance always positive? The Covariance Formula The formula is: Cov(X,Y) = Σ E((X-μ)E(Y-ν)) / n-1 where: X is a random variable E(X) = μ is the expected value (the mean) of the random variable X and E(Y) = ν is the expected value (the mean) of the random variable Y n = the number of items in the data set Video: Calculate the correlation coefficient by using Excel this this Powered by Embed YouTube Video Calculate covariance for the following data set: x: 2.1, 2.5, 3.6, 4.0 (mean = 3.1) y: 8, 10, 12, 14 (mean = 11) Substitute the values into the formula and solve: Cov(X,Y) = ΣE((X-μ)(Y-ν)) / n-1 = (2.1-3.1)(8-11)+(2.5-3.1)(10-11)+(3.6-3.1)(12-11)+(4.0-3.1)(14-11) /(4-1) = (-1)(-3) + (-0.6)(-1)+(.5)(1)+(0.9)(3) / 3 = 3 + 0.6 + .5 + 2.7 / 3 = 6.8/3 = 2.267 The result is positive, meaning that the variables are positively related. Advantages of the Correlation Coefficient The Correlation Coefficient has several advantages over covariance for determining strengths of relationships: Covariance can take on practically any number while a correlation is limited: -1 to +1. Because of it’s numerical limitations, correlation is more useful for determining how strong the relationship is between the two variables. Correlation does not have units. Covariance always has units. Correlation isn’t affected by changes in the center (i.e. mean) or scale of the variables. What is the difference between covariance and correlation? A correlation has no dimension and it is free to measure between the variables whereas covariance is the measure of correlation. Commonly it is said to be a measure which is used to represent the random variables is known as correlation. Is covariance always positive? Positive covariance always positively related whereas the negative covariance inversely related hence it needs not to be always positive. Depends on the variables.