Syntax<\/h3>\n
VAR(value1, [value2, \u2026])<\/strong><\/p>\n <\/strong><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Let us now consider a sample dataset and apply the formula practically so that we know what we are trying to accomplish. Please have a look at the following screenshot.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/VAR-formula-1.png” alt=”VAR formula 1″ title_text=”VAR formula 1″ _builder_version=”4.16″ _module_preset=”default” 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 If you are, by any chance, looking for some literature as to how we usually calculate variance, here\u2019s the\u00a0<\/span>link<\/a>\u00a0<\/span>to it.<\/p>\n The first example consumes direct numeric values and returns the calculated variance. The second demonstrates that the VAR formula is also capable of using references to cells that store numbers. In the third example, instead of sending multiple values or references, we have passed a single composite range. This composite cell range consists of all the values from A2 through A11. And, in the final example, we not only passed direct numeric values but also a couple range references. Therefore, regardless of the approach\u00a0that we have taken with the formula, the output is same across all the examples.<\/p>\n It is interesting to learn that the variance is nothing but the square of the\u00a0standard deviation<\/a>, another important metric in statistics. And we can we can obtain using the\u00a0<\/span>STDEV<\/a>\u00a0<\/span>formula in Google Sheets. Please see the image that illustrates this concept.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/VAR-formula-2.png” alt=”VAR formula 2″ title_text=”VAR formula 2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Data is what the spreadsheets are built for \u2013 and helping us analyze it is its primary goal. There are some key metrics one needs to use while statistically analyzing the datasets. And variance is an important one of them.\u00a0It measures how far a set of numbers are spread out from their average value. The\u00a0VAR\u00a0formula […]<\/p>\n","protected":false},"author":40,"featured_media":8788,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Data is what the spreadsheets are built for - and helping us analyze it is its primary goal. There are some key metrics one needs to use while statistically analyzing the datasets. And variance is an important one of them. It measures how far a set of numbers are spread out from their average value. The VAR<\/a> formula in Google Sheets is the corresponding readymade tool for us to be able to arrive at the variance of a dataset.\n\n
Usage: VAR formula in Google Sheets<\/h3>\n
Note<\/h4>\n
Syntax<\/h3>\nVAR(value1, [value2, ...])<\/strong>\n
\n \t
Usage: VAR formula in Google Sheets<\/h3>\nLet us now consider a sample dataset and apply the formula practically so that we know what we are trying to accomplish. Please have a look at the following screenshot.\n\n
![\"VAR](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/VAR-formula-Illustration-Frame-3.png\")
\n\n\nIf you are, by any chance, looking for some literature as to how we usually calculate variance, here's the link<\/a> to it.\n\nThe first example consumes direct numeric values and returns the calculated variance. The second demonstrates that the VAR formula is also capable of using references to cells that store numbers. In the third example, instead of sending multiple values or references, we have passed a single composite range. This composite cell range consists of all the values from A2 through A11. And, in the final example, we not only passed direct numeric values but also a couple range references. Therefore, regardless of the approach that we have taken with the formula, the output is same across all the examples.\nNote<\/h4>\nIt is interesting to learn that the variance is nothing but the square of the standard deviation<\/a>, another important metric in statistics. And we can we can obtain using the STDEV<\/a> formula in Google Sheets. Please see the image that illustrates this concept.\n\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/VAR-formula-Illustration-Frame-4.png\")
\n\n<\/div>","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8776","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\/pt\/wp-json\/wp\/v2\/posts\/8776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=8776"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/8776\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/8788"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=8776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=8776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=8776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}