{"id":477,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/var-s\/"},"modified":"2021-02-13T11:36:52","modified_gmt":"2021-02-13T11:36:52","slug":"var-s","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/var-s\/","title":{"rendered":"VAR.S"},"content":{"rendered":"

Today, we will delve into a powerful statistical function available in Excel and Google Sheets \u2013 VAR.S. This function is designed to calculate the variance of a sample of data within a specified range, providing insights into the spread of values in a dataset.<\/p>\n

Introduction to the VAR.S Function<\/h2>\n

The VAR.S function is utilized for calculating the variance from a sample subset of data. Unlike some other functions that assume data from an entire population, VAR.S specifically addresses samples.<\/p>\n

Syntax<\/h2>\n

The syntax for the VAR.S function is consistent across both Excel and Google Sheets:<\/p>\n

=VAR.S(number1, [number2], ...)<\/code><\/pre>\n
where:<\/p>\n
    \n
  • number1<\/code>, number2<\/code>, … represent the data points of the sample from a population.<\/li>\n<\/ul>\n
    Examples of Using the VAR.S Function<\/h2>\n
    Let\u2019s review a few examples to better understand how the VAR.S function is implemented.<\/p>\n
    Example 1: Calculating Variance of Sales Data<\/h3>\n
    Consider a dataset containing a company’s sales figures in cells A1 to A10. To calculate the variance of this dataset, we utilize the VAR.S function in the following manner:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
    Data<\/th>\n<\/tr>\n
    120<\/td>\n<\/tr>\n
    150<\/td>\n<\/tr>\n
    130<\/td>\n<\/tr>\n
    140<\/td>\n<\/tr>\n
    160<\/td>\n<\/tr>\n
    170<\/td>\n<\/tr>\n
    180<\/td>\n<\/tr>\n
    190<\/td>\n<\/tr>\n
    200<\/td>\n<\/tr>\n
    210<\/td>\n<\/tr>\n<\/table>\n
    By entering the formula =VAR.S(A1:A10)<\/code>, the variance of the sales data is calculated.<\/p>\n
    Example 2: Calculating Variance of Exam Scores<\/h3>\n
    In another scenario, imagine we have a dataset of exam scores located in cells B1 to B8. The variance of these scores can be determined with the VAR.S function as follows:<\/p>\n\n\n\n\n\n\n\n\n\n\n
    Exam Scores<\/th>\n<\/tr>\n
    85<\/td>\n<\/tr>\n
    90<\/td>\n<\/tr>\n
    88<\/td>\n<\/tr>\n
    92<\/td>\n<\/tr>\n
    87<\/td>\n<\/tr>\n
    95<\/td>\n<\/tr>\n
    89<\/td>\n<\/tr>\n
    93<\/td>\n<\/tr>\n<\/table>\n
    Applying the formula =VAR.S(B1:B8)<\/code>, we compute the variance of the exam scores.<\/p>\n
    Conclusion<\/h2>\n
    The VAR.S function is an invaluable tool in Excel and Google Sheets for calculating the variance of sample datasets. Mastering this function allows you to analyze data variability effectively, supporting better decision-making based on statistical analysis.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Estimates variance based on a sample<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[203],"tags":[],"class_list":["post-477","post","type-post","status-publish","format-standard","hentry","category-statistical"],"acf":[],"yoast_head":"\nExcel VAR.S Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel VAR.S function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/en\/var-s\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel VAR.S Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel VAR.S function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/var-s\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-13T11:36:52+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel VAR.S Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/en\/var-s\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/var-s\/\",\"name\":\"Excel VAR.S Function \u2013 How It Works, Formula Examples and Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-13T11:36:52+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel VAR.S function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/var-s\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/var-s\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/var-s\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Function Excel\",\"item\":\"https:\/\/functiontranslator.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistical\",\"item\":\"https:\/\/functiontranslator.com\/en\/statistical\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"VAR.S\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel VAR.S Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel VAR.S function does. Clear syntax explanation and useful formula examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/en\/var-s\/","og_locale":"en_US","og_type":"article","og_title":"Excel VAR.S Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel VAR.S function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/var-s\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-13T11:36:52+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel VAR.S Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/var-s\/","url":"https:\/\/functiontranslator.com\/en\/var-s\/","name":"Excel VAR.S Function \u2013 How It Works, Formula Examples and Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-13T11:36:52+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel VAR.S function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/var-s\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/var-s\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/var-s\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Function Excel","item":"https:\/\/functiontranslator.com\/en\/"},{"@type":"ListItem","position":2,"name":"Statistical","item":"https:\/\/functiontranslator.com\/en\/statistical\/"},{"@type":"ListItem","position":3,"name":"VAR.S"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/477","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/comments?post=477"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/477\/revisions"}],"predecessor-version":[{"id":3368,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/477\/revisions\/3368"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}