{"id":378,"date":"2025-07-15T13:34:46","date_gmt":"2025-07-15T13:34:46","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/quartile-inc\/"},"modified":"2021-02-13T11:36:06","modified_gmt":"2021-02-13T11:36:06","slug":"quartile-inc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/quartile-inc\/","title":{"rendered":"QUARTILE.INC"},"content":{"rendered":"

The QUARTILE.INC function in Excel and Google Sheets is employed to find the value at a specific quartile of a data set. This function effectively divides the data into four equal segments and identifies the value that matches the quartile specified by the user. It is frequently utilized in statistical analyses to assess the distribution of data points within a set.<\/p>\n

Syntax<\/h2>\n

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

=QUARTILE.INC(array, quart)<\/code><\/pre>\n
    \n
  • array<\/code>: This is the array or cell range that contains the data set for which the quartile is to be calculated.<\/li>\n
  • quart<\/code>: An integer between 0 and 4 that specifies the quartile to return:\n
      \n
    • quart = 0 returns the minimum value of the dataset.<\/li>\n
    • quart = 1 returns the 25th percentile, known as the first quartile.<\/li>\n
    • quart = 2 returns the 50th percentile, also called the second quartile or median.<\/li>\n
    • quart = 3 returns the 75th percentile, or third quartile.<\/li>\n
    • quart = 4 returns the maximum value of the dataset.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
      Examples<\/h2>\n
      Let’s explore some examples to better understand how the QUARTILE.INC function operates in Excel and Google Sheets:<\/p>\n
      Example 1: Finding Quartiles from a Dataset<\/h3>\n
      Consider the following dataset in cells A1 through A10:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
      Data<\/th>\n<\/tr>\n
      25<\/td>\n<\/tr>\n
      35<\/td>\n<\/tr>\n
      40<\/td>\n<\/tr>\n
      50<\/td>\n<\/tr>\n
      60<\/td>\n<\/tr>\n
      70<\/td>\n<\/tr>\n
      80<\/td>\n<\/tr>\n
      85<\/td>\n<\/tr>\n
      90<\/td>\n<\/tr>\n
      95<\/td>\n<\/tr>\n<\/table>\n
      To determine the first quartile (Q1), we can use the following formula:<\/p>\n
      =QUARTILE.INC(A1:A10, 1)<\/code><\/pre>\n
      This formula returns the value 40, which represents the 25th percentile of the dataset.<\/p>\n
      Similarly, to find the third quartile (Q3), apply the formula:<\/p>\n
      =QUARTILE.INC(A1:A10, 3)<\/code><\/pre>\n
      This yields the value 85, which is at the 75th percentile in the dataset.<\/p>\n
      Example 2: Handling Outliers with Quartiles<\/h3>\n
      Quartiles can be very useful in spotting outliers within a dataset. By comparing individual data points to the first and third quartiles, you can evaluate whether they lie significantly outside the expected range.<\/p>\n
      Assume you have an additional data point of 150 in cell A11. To determine if this point is an outlier, calculate the interquartile range (IQR) and set a cutoff for outliers.<\/p>\n
      First, find the IQR with:<\/p>\n
      =QUARTILE.INC(A1:A10, 3) - QUARTILE.INC(A1:A10, 1)<\/code><\/pre>\n
      Then, establish the outlier threshold as 1.5 times the IQR:<\/p>\n
      =QUARTILE.INC(A1:A10, 3) + 1.5 * IQR<\/code><\/pre>\n
      If the data point exceeds this threshold, it is likely an outlier and should be further analyzed.<\/p>\n
      The QUARTILE.INC function is a powerful tool for analyzing data distribution and identifying potential outliers in your datasets.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Returns the quartile of a data set<\/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-378","post","type-post","status-publish","format-standard","hentry","category-statistical"],"acf":[],"yoast_head":"\nExcel QUARTILE.INC Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel QUARTILE.INC 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\/quartile-inc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel QUARTILE.INC Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel QUARTILE.INC function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/quartile-inc\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-13T11:36:06+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel QUARTILE.INC 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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/en\/quartile-inc\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/quartile-inc\/\",\"name\":\"Excel QUARTILE.INC Function \u2013 How It Works, Formula Examples and Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:46+00:00\",\"dateModified\":\"2021-02-13T11:36:06+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel QUARTILE.INC function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/quartile-inc\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/quartile-inc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/quartile-inc\/#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\":\"QUARTILE.INC\"}]},{\"@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 QUARTILE.INC Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel QUARTILE.INC 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\/quartile-inc\/","og_locale":"en_US","og_type":"article","og_title":"Excel QUARTILE.INC Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel QUARTILE.INC function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/quartile-inc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:36:06+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel QUARTILE.INC Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/quartile-inc\/","url":"https:\/\/functiontranslator.com\/en\/quartile-inc\/","name":"Excel QUARTILE.INC Function \u2013 How It Works, Formula Examples and Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:46+00:00","dateModified":"2021-02-13T11:36:06+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel QUARTILE.INC function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/quartile-inc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/quartile-inc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/quartile-inc\/#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":"QUARTILE.INC"}]},{"@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\/378","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=378"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/378\/revisions"}],"predecessor-version":[{"id":3269,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/378\/revisions\/3269"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=378"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=378"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}