{"id":14159,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/cuartil-inc\/"},"modified":"2021-02-26T08:56:33","modified_gmt":"2021-02-26T08:56:33","slug":"quartile-inc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/quartile-inc\/","title":{"rendered":"CUARTIL.INC"},"content":{"rendered":"

Descripci\u00f3n General<\/h2>\n

La funci\u00f3n CUARTIL.INC, disponible en Excel y Google Sheets, se emplea para calcular el cuartil de un conjunto de datos. Esta funci\u00f3n es \u00fatil para comprender c\u00f3mo se distribuyen los datos. Un cuartil divide los datos ordenados en cuatro partes iguales, siendo los m\u00e1s utilizados el cuartil inferior (25%), el mediano (50%) y el superior (75%). La variante \u00abINC\u00bb de esta funci\u00f3n considera tanto el valor m\u00ednimo como el m\u00e1ximo en el c\u00e1lculo de los cuartiles.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis de la funci\u00f3n CUARTIL.INC es la siguiente:<\/p>\n

CUARTIL.INC(datos, cuartil)<\/code><\/pre>\n
Donde:<\/p>\n
    \n
  • datos<\/strong>: Es el rango o el arreglo de datos que se desea evaluar.<\/li>\n
  • cuartil<\/strong>: Es el cuartil que se desea calcular. Se puede especificar 0 para el m\u00ednimo, 1 para el cuartil del 25%, 2 para la mediana, 3 para el cuartil del 75% y 4 para el m\u00e1ximo.<\/li>\n<\/ul>\n
    Ejemplo en Excel:<\/p>\n
    Sup\u00f3n que tienes el siguiente conjunto de datos en A1:A10: 10, 20, 30, 40, 50, 60, 70, 80, 90, 100 Para encontrar el cuartil inferior (25%), usar\u00edas: =CUARTIL.INC(A1:A10, 1) El resultado ser\u00eda 30.<\/code><\/pre>\n
    Aplicaciones Pr\u00e1cticas<\/h2>\n
    1. An\u00e1lisis de salarios en una empresa<\/h2>\n
    Imagina que necesitas determinar la distribuci\u00f3n de los salarios en tu empresa para evaluar la equidad salarial. Podr\u00edas tener los salarios de todos los empleados en una hoja de c\u00e1lculo desde A1 hasta A100.<\/p>\n
    Para encontrar el salario correspondiente al cuartil inferior (25%), podr\u00edas utilizar: =CUARTIL.INC(A1:A100, 1) Este resultado te ayudar\u00e1 a entender cu\u00e1nto gana el 25% inferior de tus empleados en comparaci\u00f3n con el resto.<\/code><\/pre>\n
    2. An\u00e1lisis de resultados de ex\u00e1menes<\/h2>\n
    Como profesor, si deseas analizar los resultados de un examen para entender c\u00f3mo se distribuyen las calificaciones de tus estudiantes, puedes utilizar CUARTIL.INC para identificar los cuartiles f\u00e1cilmente.<\/p>\n
    Sup\u00f3n que tienes las notas de los estudiantes en B1:B30: Para calcular la mediana de las notas, utilizar\u00edas: =CUARTIL.INC(B1:B30, 2) Este c\u00e1lculo te ofrece una clara indicaci\u00f3n de la nota promedio, facilit\u00e1ndote ver si la mayor\u00eda de los estudiantes est\u00e1n por encima o por debajo de este valor.<\/code><\/pre>\n
    Utilizar CUARTIL.INC te proporciona una perspectiva m\u00e1s clara sobre diferentes conjuntos de datos y facilita la toma de decisiones basada en la distribuci\u00f3n de estos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el cuartil de un conjunto de datos<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[540],"tags":[],"class_list":["post-14159","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n QUARTILE.INC (CUARTIL.INC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n QUARTILE.INC (CUARTIL.INC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos 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\/es\/quartile-inc\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n QUARTILE.INC (CUARTIL.INC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n QUARTILE.INC (CUARTIL.INC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/quartile-inc\/\" \/>\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-26T08:56:33+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n QUARTILE.INC (CUARTIL.INC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\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\/es\/quartile-inc\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/quartile-inc\/\",\"name\":\"Funci\u00f3n QUARTILE.INC (CUARTIL.INC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:56:33+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n QUARTILE.INC (CUARTIL.INC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/quartile-inc\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/quartile-inc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/quartile-inc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Estad\u00edstica\",\"item\":\"https:\/\/functiontranslator.com\/es\/estadistica\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CUARTIL.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\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n QUARTILE.INC (CUARTIL.INC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n QUARTILE.INC (CUARTIL.INC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos 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\/es\/quartile-inc\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n QUARTILE.INC (CUARTIL.INC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n QUARTILE.INC (CUARTIL.INC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/quartile-inc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:56:33+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n QUARTILE.INC (CUARTIL.INC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/quartile-inc\/","url":"https:\/\/functiontranslator.com\/es\/quartile-inc\/","name":"Funci\u00f3n QUARTILE.INC (CUARTIL.INC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:56:33+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n QUARTILE.INC (CUARTIL.INC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/quartile-inc\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/quartile-inc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/quartile-inc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Estad\u00edstica","item":"https:\/\/functiontranslator.com\/es\/estadistica\/"},{"@type":"ListItem","position":3,"name":"CUARTIL.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":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14159","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=14159"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14159\/revisions"}],"predecessor-version":[{"id":30250,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14159\/revisions\/30250"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}