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

Introdu\u00e7\u00e3o ao Conceito de Quartis Exclusivos<\/h2>\n

Quartis s\u00e3o valores que dividem um conjunto de dados em quatro partes iguais, cada uma contendo 25% dos dados. A fun\u00e7\u00e3o QUARTIL.EXC, dispon\u00edvel tanto no Microsoft Excel quanto no Google Planilhas, \u00e9 usada para calcular o quartil de um conjunto de dados excluindo seus valores m\u00ednimo e m\u00e1ximo. Esta fun\u00e7\u00e3o difere de QUARTIL.INC, que considera todos os dados na divis\u00e3o dos quartis. Ela \u00e9 especialmente valiosa em an\u00e1lises estat\u00edsticas que necessitam de uma medi\u00e7\u00e3o robusta tanto da tend\u00eancia central quanto da dispers\u00e3o dos dados.<\/p>\n

Sintaxe e Usabilidade<\/h2>\n

A sintaxe para a fun\u00e7\u00e3o QUARTIL.EXC \u00e9 a mesma no Microsoft Excel e no Google Planilhas:<\/p>\n

=QUARTIL.EXC(intervalo; quartil)<\/code><\/pre>\n
Esta fun\u00e7\u00e3o requer dois argumentos:<\/p>\n
    \n
  • intervalo<\/code>: o conjunto de dados a ser analisado.<\/li>\n
  • quartil<\/code>: o n\u00famero do quartil a ser calculado, que pode ser 1, 2 ou 3:\n
      \n
    • 1<\/b>: 1\u00ba quartil (25\u00ba percentil)<\/li>\n
    • 2<\/b>: 2\u00ba quartil (mediana, 50\u00ba percentil)<\/li>\n
    • 3<\/b>: 3\u00ba quartil (75\u00ba percentil)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
      Por exemplo, para calcular o primeiro quartil de uma lista de n\u00fameros na faixa A1:A10, utilizamos:<\/p>\n
      =QUARTIL.EXC(A1:A10; 1)<\/code><\/pre>\n
      Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h2>\n
      An\u00e1lise de Distribui\u00e7\u00e3o de Notas em Provas<\/h2>\n
      Imagine um professor que deseja analisar as notas de uma prova, com resultados variando de 0 a 100, armazenadas de B1 a B30, para identificar diferentes n\u00edveis de desempenho estudantil:<\/p>\n
      1\u00ba Quartil (25\u00ba Percentil): =QUARTIL.EXC(B1:B30; 1) Mediana (50\u00ba Percentil): =QUARTIL.EXC(B1:B30; 2) 3\u00ba Quartil (75\u00ba Percentil): =QUARTIL.EXC(B1:B30; 3)<\/code><\/pre>\n
      Esses c\u00e1lculos permitem ao professor identificar rapidamente os alunos que est\u00e3o abaixo, dentro ou acima da m\u00e9dia da classe, ajudando na tomada de decis\u00f5es educacionais.<\/p>\n
      An\u00e1lise de Sal\u00e1rios em um Setor<\/h2>\n
      Um analista de RH pode querer avaliar a distribui\u00e7\u00e3o de sal\u00e1rios dentro de uma empresa para entender disparidades salariais e auxiliar na reformula\u00e7\u00e3o da pol\u00edtica de remunera\u00e7\u00f5es. Suponha que os sal\u00e1rios est\u00e3o listados de C1 a C40:<\/p>\n
      1\u00ba Quartil (Q1): =QUARTIL.EXC(C1:C40; 1) Mediana (M): =QUARTIL.EXC(C1:C40; 2) 3\u00ba Quartil (Q3): =QUARTIL.EXC(C1:C40; 3)<\/code><\/pre>\n
      Com esses dados, o analista pode visualizar como os sal\u00e1rios est\u00e3o distribu\u00eddos e propor ajustes justos com base em informa\u00e7\u00f5es concretas, visando a corre\u00e7\u00e3o de disparidades injustificadas.<\/p>\n
      Considera\u00e7\u00f5es Finais<\/h2>\n
      A fun\u00e7\u00e3o QUARTIL.EXC \u00e9 uma ferramenta valiosa para entender a distribui\u00e7\u00e3o de dados, ao excluir os extremos, proporcionando uma vis\u00e3o que pode ser mais representativa para conjuntos de dados onde valores extremos poderiam distorcer an\u00e1lises fundamentais.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Devolve o quartil do conjunto de dados, baseado em valores de percentil de 01, exclusivo<\/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-11080","post","type-post","status-publish","format-standard","hentry","category-estatistica"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o QUARTILE.EXC (QUARTIL.EXC) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o QUARTILE.EXC (QUARTIL.EXC) 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-exc\/\" \/>\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.EXC (QUARTIL.EXC) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o QUARTILE.EXC (QUARTIL.EXC) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/quartile-exc\/\" \/>\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:27+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.EXC (QUARTIL.EXC) 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-exc\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/quartile-exc\/\",\"name\":\"Fun\u00e7\u00e3o QUARTILE.EXC (QUARTIL.EXC) 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:27+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o QUARTILE.EXC (QUARTIL.EXC) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/quartile-exc\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/quartile-exc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/quartile-exc\/#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.EXC\"}]},{\"@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.EXC (QUARTIL.EXC) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o QUARTILE.EXC (QUARTIL.EXC) 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-exc\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o QUARTILE.EXC (QUARTIL.EXC) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o QUARTILE.EXC (QUARTIL.EXC) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/quartile-exc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:51+00:00","article_modified_time":"2021-02-25T17:27:27+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o QUARTILE.EXC (QUARTIL.EXC) 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-exc\/","url":"https:\/\/functiontranslator.com\/pt-pt\/quartile-exc\/","name":"Fun\u00e7\u00e3o QUARTILE.EXC (QUARTIL.EXC) 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:27+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o QUARTILE.EXC (QUARTIL.EXC) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/quartile-exc\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/quartile-exc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/quartile-exc\/#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.EXC"}]},{"@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\/11080","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=11080"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11080\/revisions"}],"predecessor-version":[{"id":27124,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11080\/revisions\/27124"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=11080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=11080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=11080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}