If the covariance is positive, it indicates that the variables tend to change together in the same direction. Whereas, the negative covariance indicates that they tend to change together in the opposite direction (i.e. increase in one leads to decrease in the other). If you are interested in understanding how we mathematically calculate the covariance, here\u2019s the\u00a0<\/span>link<\/a>\u00a0<\/span>to it.<\/p>\n COVAR(data_y, data_x)<\/strong><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now let us go ahead and dive right into the practical application of this formula. Because examples always help us to reinforce our understanding. Please go through the following snapshot taken off the Google Sheets application.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/COVAR-formula-Illustration-Frame-2.png” alt=”COVAR Formula in Google Sheets” title_text=”covar-formula” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The parameters accept\u00a0the input values in two different ways. We can either choose to input the direct numeric datasets using curly braces that indicate ranges (first example). Or we can simply use range references (final three example).<\/p>\n You\u2019ll notice that we have used three different sets of y data against a single x dataset. There is no particular relation between the datasets in columns A and D. But, observe the data sets in columns B and C. And compare them with that of column D. You\u2019ll see they have positive and negative linear relationships respectively. The sign of the covariance shows the tendency in the linear relationship between the variables. This was evident from the third and fourth examples.<\/p>\n However, it is not straightforward to interpret the magnitude of the covariance. That is because it is not normalized and hence depends on the magnitudes of the variables. If we need to gauge the strength of the linear relationship though, we can use the\u00a0CORREL<\/a>\u00a0<\/span>formula.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Analyzing the data leads us to multiple interpretations as to what the underlying nature is. And we have many important statistical tools and metrics that help us with this exercise. One such important metric that mathematicians have at their disposal is the covariance. It measures the joint variability of two random variables. Given two data […]<\/p>\n","protected":false},"author":40,"featured_media":8839,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Analyzing the data leads us to multiple interpretations as to what the underlying nature is. And we have many important statistical tools and metrics that help us with this exercise. One such important metric that mathematicians have at their disposal is the covariance. It measures the joint variability of two random variables. Given two data sets, we can calculate this using the readily available COVAR<\/a> formula in Google Sheets.\n\nIf the covariance is positive, it indicates that the variables tend to change together in the same direction. Whereas, the negative covariance indicates that they tend to change together in the opposite direction (i.e. increase in one leads to decrease in the other). If you are interested in understanding how we mathematically calculate the covariance, here\u2019s the link<\/a> to it.\nSyntax<\/h3>\n
\n
Usage: COVAR formula in Google Sheets<\/h3>\n
Syntax<\/h3>\nCOVAR(data_y, data_x)<\/strong>\n
\n \t
Usage: COVAR formula in Google Sheets<\/h3>\nNow let us go ahead and dive right into the practical application of this formula. Because examples always help us to reinforce our understanding. Please go through the following snapshot taken off the Google Sheets application.\n\n
![\"COVAR](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/COVAR-formula-Illustration-Frame-2.png\")
\n\nThe parameters accept the input values in two different ways. We can either choose to input the direct numeric datasets using curly braces that indicate ranges (first example). Or we can simply use range references (final three example).\n\nYou'll notice that we have used three different sets of y data against a single x dataset. There is no particular relation between the datasets in columns A and D. But, observe the data sets in columns B and C. And compare them with that of column D. You'll see they have positive and negative linear relationships respectively. The sign of the covariance shows the tendency in the linear relationship between the variables. This was evident from the third and fourth examples.\n\nHowever, it is not straightforward to interpret the magnitude of the covariance. That is because it is not normalized and hence depends on the magnitudes of the variables. If we need to gauge the strength of the linear relationship though, we can use the CORREL<\/a> formula.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8838","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/8838","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=8838"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/8838\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/8839"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=8838"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=8838"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=8838"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}