{"id":11081,"date":"2025-07-15T13:34:51","date_gmt":"2025-07-15T13:34:51","guid":{"rendered":"https:\/\/functiontranslator.com\/quartil-inc\/"},"modified":"2021-02-25T17:27:28","modified_gmt":"2021-02-25T17:27:28","slug":"quartile-inc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/quartile-inc\/","title":{"rendered":"QUARTIL.INC"},"content":{"rendered":"

A fun\u00e7\u00e3o QUARTIL.INC, conhecida como QUARTILE.INC em ingl\u00eas, \u00e9 amplamente utilizada no Microsoft Excel e no Google Planilhas para calcular o quartil de um conjunto de dados. Esta fun\u00e7\u00e3o divide os dados em quatro partes iguais, oferecendo uma vis\u00e3o clara da distribui\u00e7\u00e3o dos valores. \u00datil em an\u00e1lises estat\u00edsticas, financeiras ou de mercado, a QUARTIL.INC ajuda na tomada de decis\u00f5es informadas ao revelar a dispers\u00e3o dos dados.<\/p>\n

Sintaxe e Exemplos<\/h2>\n

A sintaxe da fun\u00e7\u00e3o QUARTIL.INC \u00e9:<\/p>\n

QUARTIL.INC(matriz; quart)<\/code><\/pre>\n
Os par\u00e2metros s\u00e3o definidos como:<\/p>\n
    \n
  • matriz<\/b> – Refere-se ao conjunto de dados, que deve ser uma s\u00e9rie num\u00e9rica ou uma refer\u00eancia a c\u00e9lulas que cont\u00eam n\u00fameros.<\/li>\n
  • quart<\/b> – Especifica o quartil desejado para c\u00e1lculo. Os valores poss\u00edveis s\u00e3o 0 (m\u00ednimo), 1 (25%), 2 (mediana, 50%), 3 (75%) ou 4 (m\u00e1ximo).<\/li>\n<\/ul>\n
    Exemplo 1:<\/b> Considerando os dados de vendas de uma semana: 100, 200, 300, 400, 500.<\/p>\n
    Para calcular o quartil 3 (75%), use a seguinte f\u00f3rmula no Excel ou Google Planilhas:<\/p>\n
    =QUARTIL.INC(A1:A5; 3)<\/code><\/pre>\n
    O resultado ser\u00e1 400, indicando que 75% dos dados s\u00e3o menores ou iguais a este valor.<\/p>\n
    Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h2>\n
    Aplica\u00e7\u00e3o 1: An\u00e1lise Financeira<\/b><\/p>\n
    Imagine que voc\u00ea quer analisar a dispers\u00e3o dos pre\u00e7os de fechamento do mercado de a\u00e7\u00f5es de uma empresa ao longo de um m\u00eas. Calculando os tr\u00eas quartis, voc\u00ea obteria uma interpreta\u00e7\u00e3o clara sobre a varia\u00e7\u00e3o dos pre\u00e7os.<\/p>\n
    Para dados listados de B2 a B21, as f\u00f3rmulas seriam:<\/p>\n
    =QUARTIL.INC(B2:B21; 1) # Para Q1 =QUARTIL.INC(B2:B21; 2) # Para a Mediana =QUARTIL.INC(B2:B21; 3) # Para Q3<\/code><\/pre>\n
    Aplica\u00e7\u00e3o 2: Avalia\u00e7\u00e3o de Desempenho de Estudantes<\/b><\/p>\n
    Se voc\u00ea \u00e9 um educador avaliando notas de alunos em um exame, os quartis permitem identificar quais alunos est\u00e3o abaixo do quartil 1, entre o quartil 1 e a mediana, entre a mediana e o quartil 3, e acima do quartil 3.<\/p>\n
    Com as notas listadas de C2 a C30, voc\u00ea poderia estabelecer um sistema de avalia\u00e7\u00e3o utilizando quartis com as seguintes f\u00f3rmulas:<\/p>\n
    =QUARTIL.INC(C2:C30; 1) # Para identificar o limite inferior de 25% =QUARTIL.INC(C2:C30; 2) # Para encontrar a mediana =QUARTIL.INC(C2:C30; 3) # Para definir o limite superior de 75%<\/code><\/pre>\n
    Essas informa\u00e7\u00f5es fornecem uma base para an\u00e1lises detalhadas, suportando estrat\u00e9gias de ensino personalizadas e aumentando a efic\u00e1cia do processo educacional. Ao utilizar a fun\u00e7\u00e3o QUARTIL.INC, analistas e educadores podem realizar avalia\u00e7\u00f5es profundas e informadas, facilitando decis\u00f5es baseadas em objetivos quantitativos claros, e consequentemente, uma gest\u00e3o mais eficiente de varia\u00e7\u00f5es dentro de conjuntos num\u00e9ricos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devolve o quartil de um conjunto de dados<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[442],"tags":[],"class_list":["post-11081","post","type-post","status-publish","format-standard","hentry","category-estatistica"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o QUARTILE.INC (QUARTIL.INC) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o QUARTILE.INC (QUARTIL.INC) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\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\/pt-pt\/quartile-inc\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o QUARTILE.INC (QUARTIL.INC) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o QUARTILE.INC (QUARTIL.INC) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/quartile-inc\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:27:28+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o QUARTILE.INC (QUARTIL.INC) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/quartile-inc\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/quartile-inc\/\",\"name\":\"Fun\u00e7\u00e3o QUARTILE.INC (QUARTIL.INC) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:51+00:00\",\"dateModified\":\"2021-02-25T17:27:28+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o QUARTILE.INC (QUARTIL.INC) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/quartile-inc\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/quartile-inc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/quartile-inc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Estat\u00edstica\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/estatistica\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"QUARTIL.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\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@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\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o QUARTILE.INC (QUARTIL.INC) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o QUARTILE.INC (QUARTIL.INC) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","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\/pt-pt\/quartile-inc\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o QUARTILE.INC (QUARTIL.INC) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o QUARTILE.INC (QUARTIL.INC) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/quartile-inc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:51+00:00","article_modified_time":"2021-02-25T17:27:28+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o QUARTILE.INC (QUARTIL.INC) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/quartile-inc\/","url":"https:\/\/functiontranslator.com\/pt-pt\/quartile-inc\/","name":"Fun\u00e7\u00e3o QUARTILE.INC (QUARTIL.INC) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:51+00:00","dateModified":"2021-02-25T17:27:28+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o QUARTILE.INC (QUARTIL.INC) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/quartile-inc\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/quartile-inc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/quartile-inc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Estat\u00edstica","item":"https:\/\/functiontranslator.com\/pt-pt\/estatistica\/"},{"@type":"ListItem","position":3,"name":"QUARTIL.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":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@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\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11081","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=11081"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11081\/revisions"}],"predecessor-version":[{"id":25910,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11081\/revisions\/25910"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=11081"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=11081"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=11081"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}